Hibernate中同一查询的几种写法

来源：互联网发布：greenplum 切换数据库编辑：程序博客网时间：2024/06/04 06:15

假设查询是：select first_name from user_info where birthday between ? and ? order by id limit ?,?，在hibernate中有以下几种写法：

（1）Criteria，以对象的方式描述SQL

Criteria criteria = session.createCriteria(Userinfo.class);criteria.setFirstResult(start);criteria.setMaxResults(count);criteria.setProjection(Property.forName("firstName"));criteria.add(Restrictions.between("birthday", startDate, endDate));criteria.addOrder(Order.desc("id"));List<Userinfo> users = criteria.list();

（2）HQL写法

String hql = "select firstName from Userinfo where birthday between ? and ? order by id limit ?,?;Query query = session.createQuery(hql);query.setDate(0,startDate);query.setDate(1,endDate);query.setInteger(2,start);query.setInteger(3,count);List<Userinfo> users = query.list();

（3）SQL写法

String sql = "select first_name from user_info where birthday between ? and ? order by id limit ?,?;SQLQuery query = session.createSQLQuery(hql);query.setDate(0,startDate);query.setDate(1,endDate);query.setInteger(2,start);query.setInteger(3,count);List<Userinfo> users = query.list();