Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Scalar штука описывающая какие поля будут возвращены, ниже пример и как получить несколько Scalar
- public String getXMLTags() throws SQLException, NoSuchMethodException {
- Session session = null;
- List tags = null;
- try {
- session = HibernateUtil.getSessionFactory().getCurrentSession();
- session.beginTransaction();
- tags = session.createSQLQuery("select count(aa.id_tag) as size, tags.name, tags.id " +
- "from (select tagsandbook.id_tag " +
- "from usersandbooks, tagsandbook " +
- "where tagsandbook.id_book = usersandbooks.id_book) as aa, tags " +
- "where tags.id = aa.id_tag " +
- "group by aa.id_tag").addScalar("name").addScalar("size").addScalar("id").list();
- session.getTransaction().commit();
- } finally {
- if (session != null && session.isOpen())
- session.close();
- }
- Iterator it = tags.iterator();
- String resultString = "<tags>";
- while(it.hasNext()){
- Object[] row = (Object[]) it.next();
- resultString += "<tag>";
- resultString += "<name>" + row[0] + "</name>";
- resultString += "<size>" + row[1] + "</size>";
- resultString += "<id>" + row[2] + "</id>";
- resultString += "<meuPeso>6</meuPeso>";
- resultString += "</tag>";
- }
- resultString+="</tags>";
- return resultString;
- }
Advertisement
Add Comment
Please, Sign In to add comment