巧妙mybatis避免Where空条件的尴尬

 SELECT * FROM BLOG
 WHERE
 
 state = #{state}
  

 SELECT * FROM BLOG
 WHERE 1=1
 
 and state = #{state}
  

 SELECT * FROM BLOG
 
  
   and state = #{state}
  
  

@SelectProvider(type=DeptDynaSqlProvider.class,method="count")
 Integer count(Map params);
//DeptDynaSqlProvider.class 类中的方法
public String count(Map params){
return new SQL(){{SELECT("count(*)");FROM(DEPTTABLE);if(params.get("dept") != null){Dept dept = (Dept) params.get("dept");if(dept.getName() != null && !dept.getName().equals("")){WHERE(" name LIKE CONCAT ('%',#{dept.name},'%') ");}}}}.toString();}

@Select({""})