温故而知新,本文回顾一下Hibernate中的查询方式。
1.hql查询
//第一种:查询所有
Session session = HibernateUtils.getCurrentSession();
Transaction ts = session.beginTransaction();
String hql="from Customer";
Query query = session.createQuery(hql);
List list = query.list();
System.out.println(list);
//第二种:查询单条数据
Session session = HibernateUtils.getCurrentSession();
Transaction ts = session.beginTransaction();
//?占位符
String hql="from Customer where custId=?";//根据实体的属性来查询
Query query = session.createQuery(hql);
query.setParameter(1);//传入的值的类型与数据库定义的类型相符合
Customer customer = (Customer)query.uniqueResult();
//此处也可以用list来接收,具体根据业务需求来确定
//命名占位符
String hql2="from Customer where custId=:cust_id and custName =:cust_name";
Query query=session.createQuery();
query.setParameter("cust_id",1L);
query.setParameter("cust_name","dsx