hibernate的 addScalar 方法是干什么用的? hibernate的 addScalar 方法是干什么用的? 麻烦详细讲解一下 谢了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 http://blog.163.com/liujunjie51072/blog/static/8689162120086186455915/请参考:1,addScalar 显式指定返回数据的类型String sql = "select count(*) as cnt from tblRead" + Misc.formatMoon(year, month) ...SQLQuery query = session.createSQLQuery(sql);query.addScalar("cnt", Hibernate.INTEGER);...count = (Integer) query.uniqueResult();2, 返回的结果集是多个列的情况String sql = "select day, count(*) as cnt from tblRead" + Misc.formatMoon(year, month) ...SQLQuery query = session.createSQLQuery(sql);query.addScalar("day", Hibernate.INTEGER);query.addScalar("cnt", Hibernate.INTEGER);...Iterator results = query.list().iterator();while (results.hasNext()){ Object[] rows = (Object[]) results.next(); int day = (Integer) rows[0]; int cnt = (Integer) rows[1]; ...} //使用addScalar方法将查询结果转换成标量值 Query query = session.createSQLQuery(sqlQuery) .addScalar("wdjdmc", org.hibernate.Hibernate.STRING) .addScalar("wdbm", org.hibernate.Hibernate.STRING) .addScalar("sbsj",org.hibernate.Hibernate.TIMESTAMP) .addScalar("hqsj", org.hibernate.Hibernate.TIMESTAMP) .setResultTransformer(Transformers.aliasToBean(ReportGrid.class));// Query query = session.createSQLQuery(sqlQuery); //将所查出来的数据设置为hashMap类型 query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); List<ReportGrid> lt = (List<ReportGrid>)query.list(); 谁有手机归属地对照表,给我一份 这个效果是怎么做出来的? 在JSP下如何发短信给手机? JSP页面中获得服务器的相对地址 !!!!!怎样做到电子文件只能查看,不能下载 tomcat在服务不停情况下任何更新应用下lib? dom4j读xml的属性 javaWeb部署好了,但依然无法访问到??? accp大哥,关于图片预览的问题,请进!! 我什么都不懂,想学java但不知如何下手。jsp=java吗?学java先要用什么工具,在哪下载? web问题求帮助 单例类的作用范围是整个WEB,还是SESSION呢?
请参考:
1,addScalar 显式指定返回数据的类型
String sql = "select count(*) as cnt from tblRead" + Misc.formatMoon(year, month) ...
SQLQuery query = session.createSQLQuery(sql);
query.addScalar("cnt", Hibernate.INTEGER);
...
count = (Integer) query.uniqueResult();
2, 返回的结果集是多个列的情况
String sql = "select day, count(*) as cnt from tblRead" + Misc.formatMoon(year, month) ...
SQLQuery query = session.createSQLQuery(sql);
query.addScalar("day", Hibernate.INTEGER);
query.addScalar("cnt", Hibernate.INTEGER);
...
Iterator results = query.list().iterator();
while (results.hasNext())
{
Object[] rows = (Object[]) results.next();
int day = (Integer) rows[0];
int cnt = (Integer) rows[1];
...
}
Query query = session.createSQLQuery(sqlQuery)
.addScalar("wdjdmc", org.hibernate.Hibernate.STRING)
.addScalar("wdbm", org.hibernate.Hibernate.STRING)
.addScalar("sbsj",org.hibernate.Hibernate.TIMESTAMP)
.addScalar("hqsj", org.hibernate.Hibernate.TIMESTAMP)
.setResultTransformer(Transformers.aliasToBean(ReportGrid.class));
// Query query = session.createSQLQuery(sqlQuery);
//将所查出来的数据设置为hashMap类型
query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
List<ReportGrid> lt = (List<ReportGrid>)query.list();