Hibernate查询方式
1、Query执行Hql语句
1)查询所有记录
Query query = session.createQuery("from Customer");
List<Customer> list = query.list();
System.Out.println(list);
2)条件查询
Query query = session.createQuery("from Customer where name=?");
query.setString(0,"张三");
List<Customer> list = query.list();
System.Out.println(list);
3)条件查询
Query query = session.createQuery("from Customer where name = ? and age = ?");
query.setString("aaa","张三");
query.setString("bbb","38");
System.Out.println(list);
4)分页查询
Query query = session.createQuery("from Customer");
query.setFirstResult(3);
query.setMaxResults(3);
List<Customer> list = query.list();
System.Out.println(list);
Criteria
1)查询所有记录
Criteria criteria = session.createCriteria(Customer.class);
List<Customer> list = criteria.list();
System.Out.println(list);
2)条件查询
Criteria criteria = session.createCriteria(Customer.class);
criteria.add(Restriction.eq("name","李健"));
List<Customer> list = criteria.list();
System.Out.println(list);
3)条件查询
Criteria criteria = session.createCriteria(Customer.class);
criteria.add(Restriction.eq("name","李健"));
criteria.add(Restriction.eq("age",16));
System.Out.println(list);
4)分页查询
Criteria criteria = session.createCriteria(Customer.class);
criteria.setFirstResult(3);
criteria.setMaxResult(3);
System.Out.println(list);
3、SQLQuery
1)基本查询
SQLQuery sqlQuery = session.createSQLQuery(“select * from cst_customer”);
List<Object[]> list = sqlQuery.list();
for(Object[] objects : list){
System.Out.println(objects)
}
SQLQuery sqlQuery = session.createSQlQuery("select * from cst_customer");
sqlQuery.addEntity(Customer.class);
List<Customer> list = sqlQuery.list();
for(Customer custoemr : list){
System.Out.println(customer);
}