HQL语句动态条件查询可以根据条件是否存在自动封装hql语句的查询条件,在这里使用map集合来实现,也可以通过创建实体条件类来创建,但是创建类太多,如果使用该查询频率较高可以使用这种方法,实体类方法与map方法类似
其中自定义的条件名要与map键值对的key值相同,每一个and前要预留空格,否则会报org.hibernate.hql.ast.QuerySyntaxException异常
public static void zuhetiaojianchaxunformap(){
Session session = HibernateUtil.getSession();
Map<String, Object> map = new HashMap<>();
map.put("hnianling", 25);
map.put("lnianling", 22);
map.put("xingbie", 1);
map.put("xingming", "张三");
StringBuffer s = new StringBuffer();
s.append(" from Xuesheng where 1=1 ");
if (map.get("hnianling")!=null){
s.append(" and nianling<=:hnianling");
}
if(map.get("lnianling")!=null){
s.append(" and nianling>=:lnianling");
}
if(map.get("xingbie")!=null){
s.append(" and xingbie=:xingbie");
}
if(map.get("xingming")!=null){
s.append(" and xingming=:xingming");
}
Query query = session.createQuery(s.toString());
query.setProperties(map);
List<Xuesheng> list = query.list();
for (Xuesheng xuesheng : list) {
System.out.println("姓名:"+xuesheng.getXingming()+",年龄:"+xuesheng.getNianling());
}
}
map里有几个条件sql语句中就会添加几个,生成的sql语句如下:
select
xuesheng0_.xuehao as xuehao0_,
xuesheng0_.xingming as xingming0_,
xuesheng0_.xingbie as xingbie0_,
xuesheng0_.nianling as nianling0_
from
xueshengbiao xuesheng0_
where
1=1
and xuesheng0_.nianling<=?
and xuesheng0_.nianling>=?
and xuesheng0_.xingbie=?
and xuesheng0_.xingming=?