hibernate hql like 用法

最新推荐文章于 2021-01-27 00:10:20 发布

maomaoyu2099163

最新推荐文章于 2021-01-27 00:10:20 发布

阅读量301

点赞数

分类专栏： hibernate 文章标签： Hibernate

本文链接：https://blog.csdn.net/maomaoyu2099163/article/details/83531583

版权

hibernate 专栏收录该内容

11 篇文章 0 订阅

订阅专栏


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 ;
	}