hibernate SQLquery提取变量 [英] hibernate SQLquery extract variable
问题描述
如何从hibernate SQL查询中提取变量total,min,max并将它们分配给java变量?
$ b $ pre $
(选择总数计数(*),min(price)作为min,max(price)作为产品的最大值)。 addScalar(total,Hibernate.INTEGER).addScalar(min,Hibernate.INTEGER).addScalar(max,Hibernate.INTEGER);
稍后编辑: How can I extract variables total, min, max from hibernate SQL queries and assign them to java variables?
This post should help you. Later edit:
这篇关于hibernate SQLquery提取变量的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
String sQuery =从MyEntity中选择min(myEntity.x),max(myEntity.y) myEntity所;
Query hQuery = session.createQuery(sQuery);
列表结果= hQuery.list();
Iterator iterator = result.iterator();
while(iterator.hasNext()){
Object [] row =(Object [])iterator.next();
for(int col = 0; col< row.length; col ++){
System.out.println(row [col]);
}
}
(select count(*) as total, min(price) as min, max(price) as max from product).addScalar("total", Hibernate.INTEGER).addScalar("min", Hibernate.INTEGER).addScalar("max", Hibernate.INTEGER);
String sQuery = "select min(myEntity.x), max(myEntity.y) from MyEntity myEntity";
Query hQuery = session.createQuery(sQuery);
List result = hQuery.list();
Iterator iterator = result.iterator();
while (iterator.hasNext()) {
Object[] row = (Object[])iterator.next();
for (int col = 0; col < row.length; col++) {
System.out.println(row[col]);
}
}