hibernate 查询的用法

hibernate 的两种查询方式




一.常用的hql语句：




persion


private Integer id;
private String name;
private Integer age;


1. from Person person；
2. from Person person where person.name='zhangsan';
3. from Person person where person.id between 1 and 2;
4. from Person person where person.id in(1,2)
5. from Person person where person.name like '%li%'
6. update Person person set person.name='lily' where person.id=1;
7. delete from Person person where person.age = 10;




二.Criteria


用法：1.
单张表查询
Criteria criteria = getSession().createCriteria(TblReserveOrderItem.class, "orderItem");
      criteria.add(Restrictions.ge("order.reserveDatetime", nextDateTime));
      criteria.list();
      2.多张表查询
Criteria criteria = getSession().createCriteria(TblReserveOrderItem.class, "orderItem");
criteria.createAlias("orderItem.tblReserveOrder", "order");
criteria.createAlias("order.tblStarbucksStore", "store");
criteria.add(Restrictions.eq("store.storeId", storeId));
criteria.add(Restrictions.eq("orderItem.statusId", statesId));
criteria.add(Restrictions.ge("order.reserveDatetime", nextDateTime));
criteria.addOrder(Order.asc("order.name"));//根据名字升序排列
criteria.list();
Restrictions的常用的
Restrictions.eq equals 等于
Restrictions.gt great than 大于
Restrictions.ge great equals 大于等于
Restrictions.lt less than 小于
Restrictions.le less equals 小于等于
Restrictions.between
Restrictions.like
Restrictions.in
Restrictions.and
Restrictions.or
Restrictions.isNull
Restrictions.isNotNull