hibernate模糊查询的几种方式
(一)
??????? Session session=HibernateUtil.getSessionFactory().getCurrentSession();
??????? session.beginTransaction();
??????? String strSQL="from Province as a where a.cityName like :name";
??????? Query query = session.createQuery(strSQL);
??????
??????? query.setString("name", "%"+cityName+"%");
??????
???????? List result=query.list();
(二)
?????? Session session=HibernateUtil.getSessionFactory().getCurrentSession();
??
?? session.beginTransaction();
??
?? List result=session.createQuery("from Province as a where a.cityName like?????
?? '%"+cityName+"%'").list();
?
?(三)
???? Session session=HibernateUtil.getSessionFactory().getCurrentSession();
? session.beginTransaction();
???????
? List result=session.createQuery("from Province as a where a.cityName?
? like :name").setParameter("pid",cityName).list();
?