mybaits 的一些用法

mybaits 的一些用法

in

传参为List<texture>

<if test="texture != null and texture.size() != 0">
	AND c.texture in
		<foreach close=")" collection="texture" item="listItem" open="(" separator=",">
			#{listItem}
		</foreach>
</if>

like

传参为字符串

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