Examples of addScalar()

Examples of org.hibernate.Query.addScalar()

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

Examples of org.hibernate.Query.addScalar()

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

Examples of org.hibernate.Query.addScalar()

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

Examples of org.hibernate.Query.addScalar()

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

Examples of org.hibernate.Query.addScalar()

106
107
108
109
110
111
112
113
114
115
116
        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);
        return result;
View Full Code Here

Examples of org.hibernate.Query.addScalar()

107
108
109
110
111
112
113
114
115
116
117
        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);
        return result;
      }
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

126
127
128
129
130
131
132
133
134
135
136
        bindBlogEntryWhereClause(query, startDir, ignoreDoc, year, month, day, tag);

        query.setComment("Finding all blogEntry documents recursively in dir: " + startDir.getName());
        query.addEntity(WikiDocument.class);
        query.addScalar("COMMENT_COUNT", Hibernate.LONG);
        query.setFirstResult( pager.getQueryFirstResult() );
        query.setMaxResults( pager.getQueryMaxResults() );

        query.setResultTransformer(
            new ResultTransformer() {
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

155
156
157
158
159
160
161
162
163
164
165
            commentQueryString.append("where doc.NODE_ID in (:blogEntriesIds)").append(" ");
            commentQueryString.append("group by doc.NODE_ID");

            SQLQuery commentQuery = getSession().createSQLQuery(commentQueryString.toString());
            commentQuery.setComment("Finding comment count for blog entries");
            commentQuery.addScalar("DOC_ID");
            commentQuery.addScalar("COMMENT_COUNT");
            commentQuery.setParameterList("blogEntriesIds", blogEntryMap.keySet());

            commentQuery.setResultTransformer(
              new ResultTransformer() {
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

156
157
158
159
160
161
162
163
164
165
166
            commentQueryString.append("group by doc.NODE_ID");

            SQLQuery commentQuery = getSession().createSQLQuery(commentQueryString.toString());
            commentQuery.setComment("Finding comment count for blog entries");
            commentQuery.addScalar("DOC_ID");
            commentQuery.addScalar("COMMENT_COUNT");
            commentQuery.setParameterList("blogEntriesIds", blogEntryMap.keySet());

            commentQuery.setResultTransformer(
              new ResultTransformer() {
                  public Object transformTuple(Object[] result, String[] aliases) {
View Full Code Here

Examples of org.hibernate.SQLQuery.addScalar()

220
221
222
223
224
225
226
227
228
229
230
        SQLQuery query = getSession().createSQLQuery(queryString.toString());

        bindBlogEntryWhereClause(query, startDir, ignoreDoc, limitYear, limitMonth, limitDay, tag);

        query.setComment("Finding blogEntry counts");
        query.addScalar("NUM_OF_ENTRIES", Hibernate.LONG);
        if (projectYear)    query.addScalar("YEAR", Hibernate.INTEGER);
        if (projectMonth)   query.addScalar("MONTH", Hibernate.INTEGER);
        if (projectDay)     query.addScalar("DAY", Hibernate.INTEGER);

        query.setResultTransformer(
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.