mybatis中xml开发like的几种写法

方法1：concat

<if test="nickname != null and nickname != ''">
    AND nickname LIKE concat('%',#{nickname,jdbcType=VARCHAR},'%')
</if>

方法2：${}

<if test="nickname != null and nickname != ''">
    AND nickname LIKE '%${nickname,jdbcType=VARCHAR}%'
</if>

方法3：#{}

<if test="nickname != null and nickname != ''">
    AND nickname LIKE "%"#{nickname,jdbcType=VARCHAR}"%"
</if>

版权声明：本文为jeff06143132原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。