首页 > 其他 > 详细

hibernate查询语句实例代码

时间:2014-01-20 19:36:40      阅读:359      评论:0      收藏:0      [点我收藏+]

一、聚集函数的使用:

  • avg(...), sum(...), min(...), max(...)

  • count(*)

  • count(...), count(distinct ...), count(all...)

bubuko.com,布布扣
public DailyStatistics getPreviousDayStatistics(Integer dateNumber) {
        String hql = "from DailyStatistics bean where bean.dateNumber=" +
                    "(select max(ds.dateNumber) from DailyStatistics ds where ds.dateNumber<?  and ds.volumeZero=0)";
        Query query = getSession().createQuery(hql);
        query.setParameter(0, dateNumber);
        query.setMaxResults(1);
        System.out.println(query.getQueryString());
        return (DailyStatistics) query.uniqueResult();
}
bubuko.com,布布扣

 二、单属性查询:

List list = session.createQuery("select name from Student").list();
for(Iterator iterator = list.iterator();iterator.hasNext();) {
    String name = (String)iterator.next();
    System.out.println(name);
}

三、多属性查询:

List list = session.createQuery("select id,name from Student").list();
for(Iterator iterator = list.iterator();iterator.hasNext();) {
    Object[] object= (Object[])iterator.next();
    //object[0]是id值,object[1]是name值
    System.out.println(object[0]+ "   "+object[1]);
}

四、返回实体类:

List list = session.createQuery("select new Student(id,name) from Student").list();
for(Iterator iterator = list.iterator();iterator.hasNext();) {
    Student student= (Student)iterator.next();
    System.out.println(student.getId()+ "   "+student.getName());
}

五、多个属性查询:

bubuko.com,布布扣
List list = session.createQuery("select s.id,s.name from Student as s").list();
for(Iterator iterator = list.iterator();iterator.hasNext();) {
    Object[] object= (Object[])iterator.next();
    System.out.println(object[0]+ "   "+object[1]);
}

或

List list = session.createQuery("select id,name from Student s").list();
for(Iterator iterator = list.iterator();iterator.hasNext();) {
    Object[] object= (Object[])iterator.next();
    System.out.println(object[0]+ "   "+object[1]);
}
bubuko.com,布布扣

hibernate查询语句实例代码

原文:http://www.cnblogs.com/tq03/p/3526809.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!