https://www.cnblogs.com/yg_zhang/p/4314602.html
<select id="getDeviceAndCondition3" resultType="java.util.HashMap" parameterType="java.util.Map">
select * from ossh_personal_device where 1=1
<!-- 由于标签就是由<>组成的,在xml文件中是具有特殊含义的字符,在解析xml时发生错误,解析器xmlcdata块中是普通的字符 -->
<!-- ${key}默认字符 #{key}默认数字 或者指定 #{studentBirthday, jdbcType=DATE} -->
<foreach collection="params.keys" item="key" open=" " close=" " separator=" " >
<![CDATA[ and ${key} like concat(concat('%',#{params[${key}]}),'%') ]]>
</foreach>
ORDER BY code
</select>