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();

?