Hibernate---Criteria查询

一、获取Session对象

Configuration configuration = new Configuration().configure();
SessionFactory sf = configuration.buildSessionFactory();
Session session = sf.openSession();
Transaction tran = session.beginTransaction();

二、开始持久化操作

//查询工资高于2000元的员工
List<Emp> list = session.createCriteria(Emp.class).add(Restrictions.gt("sal",2000d)).list();
for(Emp emp : list){
    System.out.println(emp.getEname);
}
//查询没有上级领导的员工
List<Emp> list = session.createCriteria(Emp.class).add(Restrictions.isNull("mgr")).list();
for(Emp emp : list){
    System.out.println(emp.getEname);
}
//查询职位是“MANAGER”或“CLERK”的员工
List<Emp> list = session.createCriteria(Emp.class).add(Restrictions.or(Restrictions.eq("job","MANAGER"),Restrictions.or(Restrictions.eq("job","CLERK"))).list();
for(Emp emp : list){
    System.out.println(emp.getEname);
}
//查询姓名中包括 “s”的员工
List<Emp> list = session.createCriteria(Emp.class).add(Restrictions.ilike("ename","s",MatchMode.ANYWHERE)).list();
for(Emp emp : list){
    System.out.println(emp.getEname);
}
//查询没有员工的部门
List<Dept> list = session.createCriteria(Dept.class,"d").add(Restrictions.isEmpty("d.emps")).list();
for(Dept d : list){
    System.out.println(d.dname);
}
//查询出工资最高的两名员工
List<Emp> list = Session.createCriteria(Emp.class).addOrder(Order.desc("sal")).setFirstResult(0).setMaxResult(2).list();
for(Emp emp : list){
    System.out.println(emp.getEname);
}