Examples of addScalar()

Examples of com.liferay.portal.kernel.dao.orm.SQLQuery.addScalar()

51
52
53
54
55
56
57
58
59
60
61
      String sql = CustomSQLUtil.get(COUNT_BY_G1_G2_U1_U2);

      SQLQuery q = session.createSQLQuery(sql);

      q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

      QueryPos qPos = QueryPos.getInstance(q);

      qPos.add(groupId1);
      qPos.add(groupId2);
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.SQLQuery.addScalar()

20
21
22
23
24
25
26
27
28
29
30
        try {
            session = openSession();
            String qString = "SELECT Transaction.id, Book.id, Book.title, max(Transaction.id) AS max_Transaction__id FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId  GROUP BY Book.title";
//            String qString = "SELECT Transaction.id, Book.id, Book.title FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId";
            SQLQuery query = session.createSQLQuery(qString, true);
            query.addScalar("Book.id", Type.LONG);
            query.addScalar("Transaction.id", Type.LONG);
            query.addScalar("Book.title", Type.STRING);
            query.addScalar("max_Transaction__id", Type.LONG);
            System.out.println(qString);
            result = (List<Long>) QueryUtil.list(query, getDialect(), -1, -1);
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.SQLQuery.addScalar()

21
22
23
24
25
26
27
28
29
30
31
            session = openSession();
            String qString = "SELECT Transaction.id, Book.id, Book.title, max(Transaction.id) AS max_Transaction__id FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId  GROUP BY Book.title";
//            String qString = "SELECT Transaction.id, Book.id, Book.title FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId";
            SQLQuery query = session.createSQLQuery(qString, true);
            query.addScalar("Book.id", Type.LONG);
            query.addScalar("Transaction.id", Type.LONG);
            query.addScalar("Book.title", Type.STRING);
            query.addScalar("max_Transaction__id", Type.LONG);
            System.out.println(qString);
            result = (List<Long>) QueryUtil.list(query, getDialect(), -1, -1);
        } catch (Exception e) {
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.SQLQuery.addScalar()

22
23
24
25
26
27
28
29
30
31
32
            String qString = "SELECT Transaction.id, Book.id, Book.title, max(Transaction.id) AS max_Transaction__id FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId  GROUP BY Book.title";
//            String qString = "SELECT Transaction.id, Book.id, Book.title FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId";
            SQLQuery query = session.createSQLQuery(qString, true);
            query.addScalar("Book.id", Type.LONG);
            query.addScalar("Transaction.id", Type.LONG);
            query.addScalar("Book.title", Type.STRING);
            query.addScalar("max_Transaction__id", Type.LONG);
            System.out.println(qString);
            result = (List<Long>) QueryUtil.list(query, getDialect(), -1, -1);
        } catch (Exception e) {
            throw new SystemException(e);
View Full Code Here

Examples of com.liferay.portal.kernel.dao.orm.SQLQuery.addScalar()

23
24
25
26
27
28
29
30
31
32
33
//            String qString = "SELECT Transaction.id, Book.id, Book.title FROM Transaction  RIGHT JOIN Book  ON Book.id = Transaction.bookId";
            SQLQuery query = session.createSQLQuery(qString, true);
            query.addScalar("Book.id", Type.LONG);
            query.addScalar("Transaction.id", Type.LONG);
            query.addScalar("Book.title", Type.STRING);
            query.addScalar("max_Transaction__id", Type.LONG);
            System.out.println(qString);
            result = (List<Long>) QueryUtil.list(query, getDialect(), -1, -1);
        } catch (Exception e) {
            throw new SystemException(e);
        } finally {
View Full Code Here

Examples of org.hibernate.Query.addScalar()

58
59
60
61
62
63
64
65
66
67
68
    List data = this.getHibernateTemplate().executeFind(new HibernateCallback<Object>(){
      public Object doInHibernate(Session session){
       
        SQLQuery query = session.createSQLQuery(condSql);
        query.setResultTransformer(Transformers.aliasToBean(AccountDetail.class));
        query.addScalar("id", Hibernate.LONG);
        query.addScalar("time", Hibernate.TIMESTAMP);
        query.addScalar("score",Hibernate.DOUBLE);
        query.addScalar("type",Hibernate.STRING);
        query.addScalar("status",Hibernate.INTEGER);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
 
View Full Code Here

Examples of org.hibernate.Query.addScalar()

59
60
61
62
63
64
65
66
67
68
69
      public Object doInHibernate(Session session){
       
        SQLQuery query = session.createSQLQuery(condSql);
        query.setResultTransformer(Transformers.aliasToBean(AccountDetail.class));
        query.addScalar("id", Hibernate.LONG);
        query.addScalar("time", Hibernate.TIMESTAMP);
        query.addScalar("score",Hibernate.DOUBLE);
        query.addScalar("type",Hibernate.STRING);
        query.addScalar("status",Hibernate.INTEGER);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
            pageSize).list();
 
View Full Code Here

Examples of org.hibernate.Query.addScalar()

60
61
62
63
64
65
66
67
68
69
70
       
        SQLQuery query = session.createSQLQuery(condSql);
        query.setResultTransformer(Transformers.aliasToBean(AccountDetail.class));
        query.addScalar("id", Hibernate.LONG);
        query.addScalar("time", Hibernate.TIMESTAMP);
        query.addScalar("score",Hibernate.DOUBLE);
        query.addScalar("type",Hibernate.STRING);
        query.addScalar("status",Hibernate.INTEGER);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
            pageSize).list();
        System.out.println(result);
 
View Full Code Here

Examples of org.hibernate.Query.addScalar()

61
62
63
64
65
66
67
68
69
70
71
        SQLQuery query = session.createSQLQuery(condSql);
        query.setResultTransformer(Transformers.aliasToBean(AccountDetail.class));
        query.addScalar("id", Hibernate.LONG);
        query.addScalar("time", Hibernate.TIMESTAMP);
        query.addScalar("score",Hibernate.DOUBLE);
        query.addScalar("type",Hibernate.STRING);
        query.addScalar("status",Hibernate.INTEGER);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
            pageSize).list();
        System.out.println(result);
        return result;
View Full Code Here

Examples of org.hibernate.Query.addScalar()

62
63
64
65
66
67
68
69
70
71
72
        query.setResultTransformer(Transformers.aliasToBean(AccountDetail.class));
        query.addScalar("id", Hibernate.LONG);
        query.addScalar("time", Hibernate.TIMESTAMP);
        query.addScalar("score",Hibernate.DOUBLE);
        query.addScalar("type",Hibernate.STRING);
        query.addScalar("status",Hibernate.INTEGER);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
            pageSize).list();
        System.out.println(result);
        return result;
      }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.