Package org.hibernate

Examples of org.hibernate.SQLQuery.addScalar()

662
663
664
665
666
667
668
669
670
671
672
                    }
                }

                if (scalars != null) {
                    for (String key : scalars.keySet()) {
                        query.addScalar(key, scalars.get(key));
                    }
                }

                if (aliasClass != null) {
                    if (aliasClass.equals(Map.class)) {
View Full Code Here
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
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
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
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
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
102
103
104
105
106
107
108
109
110
111
112
    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);
        query.addScalar("description",Hibernate.STRING);
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
      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);
        query.addScalar("description",Hibernate.STRING);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
 
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
       
        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);
        query.addScalar("description",Hibernate.STRING);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
            pageSize).list();
 
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
        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);
        query.addScalar("description",Hibernate.STRING);
        List result  = query.setFirstResult((pageNum-1)*pageSize).setMaxResults(
            pageSize).list();
        System.out.println(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.