根据实体反射以及map查询

最新推荐文章于 2021-08-02 10:09:00 发布

Linweiqiang5

最新推荐文章于 2021-08-02 10:09:00 发布

阅读量169

点赞数

本文链接：https://blog.csdn.net/Linweiqiang5/article/details/106396762

版权

本文介绍了一种使用Map作为参数在数据库中查询实体的方法。通过将查询条件存储在Map中，可以灵活地添加多种查询方式，如等于、小于、大于等，并支持对集合类型的查询。此外，还展示了如何在Hibernate中实现这一查询逻辑。

摘要由CSDN通过智能技术生成

 //根据map查找实体
Map<String, Object> entrys = new HashMap<String, Object>();
if (StringUtil.isNotEmpty(declareType)) {
   entrys.put("type", "1");
}
List<T> rlist = commonDao.findByMapProperty(T.class, entrys);

public <T> List<T> findByMapProperty(Class<T> entityClass,
      Map<String, Object> entrys) ;

//dao实现
public <T> List<T> findByMapProperty(Class<T> entityClass,
      Map<String, Object> entrys) {
   Criteria criteria = getSession().createCriteria(entityClass);
   for (String key:entrys.keySet()) {
      Object value = entrys.get(key);
      String queryWay  = "eq";
      if(key.indexOf(":")!=-1){
         if(key.split(":").length>=2){
            queryWay= key.split(":")[1];
         }
         key = key.split(":")[0];
      }
      
      if(value!=null){
         if("le".equals(queryWay)){
            criteria.add(Restrictions.le(key, value));
         }else if("lt".equals(queryWay)){
            criteria.add(Restrictions.lt(key, value));
         }else if("ge".equals(queryWay)){
            criteria.add(Restrictions.ge(key, value));
         }else if("gt".equals(queryWay)){
            criteria.add(Restrictions.gt(key, value));
         }else if("like".equals(queryWay)){//like未添加%%则装值时需要自行添加
            criteria.add(Restrictions.like(key, value));
         }else if("ne".equals(queryWay)){
            criteria.add(Restrictions.ne(key, value));
         }else if("not".equals(queryWay)){
            Object obj = value;
            if (obj instanceof Collection){
               List clist =(List)obj;
               criteria.add(Restrictions.not(Restrictions.in(key, clist)));
            }                          
         }else if("in".equals(queryWay)){
            Object obj = value;
            if (obj instanceof Collection){
               List clist =(List)obj;
               criteria.add(Restrictions.in(key, clist));
            }                       
         }else if("order".equals(queryWay)){
            criteria.addOrder(Order.desc(key));
         }else{
            criteria.add(Restrictions.eq(key, value));
         }
      }else{
         criteria.add(Restrictions.isNull(key));
      }
      
   }
   return (List<T>) criteria.list();
   
}