学步园

String hql = "from User where 1=1";
          Map<String, Object> parmas = new HashMap<String, Object>();
          if(condition!=null){
              if(condition.getUsername()!=null&&!"".equals(condition.getUsername().trim())){
              hql += " and username like:username";
              parmas.put("username", "%"+condition.getUsername().trim()+"%");
           }
           if(condition.getPassword()!=null&&!"".equals(condition.getPassword().trim())){
               hql += " and password =:password";
               parmas.put("password", condition.getPassword().trim());
           }
           if(condition.getStatus()!=null && condition.getStatus().intValue()!=0){
               hql += " and status =:status";
               parmas.put("status", condition.getStatus().intValue());

           }

注意：每个拼接的hql语句的and前面要空一格，不然hql语句会出错。。。