<if test="name != null and name!=''">
and NAME like concat('%',#{name,jdbcType=VARCHAR},'%')
</if>
set截取前后空格,不然过滤不到 this.name = name ==null?null:name.trim();
public String getName() {
return name;
}
public void setName(String name) {
this.name = name ==null?null:name.trim();
}