有问题的代码
<if test="name != null and name != ''">
and name like CONCAT('%',#{name},'%')
</if>
修改后,添加了 or name == '0'
<if test="name != null and name != '' or name == '0'">
and name like CONCAT('%',#{name},'%')
</if>