public List<GeoInfo> selectByLike(String name){
Session session = HbnUtil.getSession();
StringBuffer hql = new StringBuffer();
hql.append("from GeoInfo e where 1=1 and geoId<19");
if(null !=name){
hql.append(" and e.geoName like '%"+name+"%'");
}
Query query = session.createQuery(hql.toString());
List<GeoInfo> geoInfoName= query.list();
HbnUtil.closeSession();
if(geoInfoName.size()>0){ //判断一下,若不为空则返回
return geoInfoName;}
else{
return null;
}
}
HQL 模糊查询
最新推荐文章于 2021-02-28 12:52:25 发布