hibernate hql like 用法

public class MavinDAOImpl extends HibernateBaseDAOImpl implements MavinDAO ...................
@SuppressWarnings("unchecked")
	public List<TbExpert> searchMavin(final String expertName,final String expertOnline) throws DAOException
	{
		List<TbExpert> mavinList = new ArrayList<TbExpert>();
		mavinList = this.getMyHibernateTemplate().executeFind(new HibernateCallback()
		{
			public Object doInHibernate(Session session)throws HibernateException, SQLException 
			{
				//全部专家
				if(expertOnline.equals("all"))
				{
					String hql = "from TbExpert e where e.expertName like:expertName ";
					System.out.println("HQL :"+hql);
					Query q = session.createQuery(hql);
					q.setString("expertName","%"+expertName+"%");
					System.out.println("-------------------------------"+q.list().size());
					return q.list();
				}else
				{
					String hql = "from TbExpert e where e.expertOnline=:expertOnline and expertName like:expertName";
					System.out.println("HQL :"+hql);
					Query q = session.createQuery(hql);
					q.setString("expertName","%"+expertName+"%");
					q.setString("expertOnline", expertOnline);
					System.out.println("---------------------------------"+q.list().size());
					return q.list();
				}
			}
		});
		return mavinList ;
	}

评论

1 楼 snowday88 2011-07-09  

在hibernate中 like的查询有很多种方法：hql是一种。Criteria 有两种：如下

1.session.createCriteria(User.class).add(Restrictions.like("name","%chengyu%")).list();

2.session.createCriteria(User.class).add(Expression.like("name", "%chengyu%"));[size=large][/size]