<select id="findLikeByName" parameterType="String" resultMap="BaseResultMap">
select
<include refid="Base_Column_List"></include>
from
admin_role
<where>
<if test="name != null and name != ''">
name like "%"#{name}"%"
</if>
</where>
</select>
需要注意,模糊查询是双引号 + 百分号,不是单引号,否则会出现不能进行模糊查询