本文共 296 字,大约阅读时间需要 1 分钟。
常用于in和not in的操作:
<select id="queryList" resultMap="BaseResultMap">
SELECT * FROM em_camp_record r <where> <if test="null != gameIds"> and r.gameid in <foreach collection="gameIds" item="item" separator="," open="(" close=")"> #{item} </foreach> </if> </where> ORDER BY r.gmt_create DESC </select>转载地址:http://dpbai.baihongyu.com/