Hibernate使用HQL进行条件查询

最新推荐文章于 2021-02-13 14:43:57 发布

酒书

最新推荐文章于 2021-02-13 14:43:57 发布

阅读量2.3k

点赞数

本文链接：https://blog.csdn.net/royal1235/article/details/81872943

版权

public List<StTd> findTdInfoByManyConditionForZhcx(StTd form1) {
		Session session=HibernateUtil.getSession();
		StringBuffer hql=new StringBuffer();
		hql.append("from StTd where  1=1");
		if(form1.getZddm()!=null&&!"".equals(form1.getZddm())){
			hql.append(" and zddm="+form1.getZddm());
		}
		if(form1.getSyqx()!=null&&!"".equals(form1.getSyqx())){
			hql.append(" and syqx="+form1.getSyqx());
		}
		if(form1.getJzlx()!=null&&!"".equals(form1.getJzlx())){
			hql.append(" and jzlx=:jzlx");
		}
		if(form1.getJzmd()!=null&&!"".equals(form1.getJzmd())){
			hql.append(" and jzmd="+form1.getJzmd());
		}
		if(form1.getRjl()!=null&&!"".equals(form1.getRjl())){
			hql.append(" and rjl="+form1.getRjl());
		}
		if(form1.getPzyt()!=null&&!"".equals(form1.getPzyt())){
			hql.append(" and pzyt="+form1.getPzyt());
		}
		if(form1.getSjyt()!=null&&!"".equals(form1.getSjyt())){
			hql.append(" and sjyt="+form1.getSjyt());
		}
		if(form1.getQsxz()!=null&&!"".equals(form1.getQsxz())){
			hql.append(" and qsxz="+form1.getQsxz());
		}
		if(form1.getSyqlx()!=null&&!"".equals(form1.getSyqlx())){
			hql.append(" and syqlx="+form1.getSyqlx());
		}
		Query query = session.createQuery(hql.toString());
		List<StTd> list = query.list();  
		return list;
	}