---多个参数in。(foreach)
<select id="get" resultType="int">
select name from table where mid in
<foreach item="item" index="index" collection="list" open="(" separator="," close=")">
#{item}
</foreach>
</select>
---choose
<choose>
<when test="paramMap.comcode != null and paramMap.comcode != '' ">
and comcode like concat(#{paramMap.comcode},'%')
</when>
<otherwise>
and 1 = 2
</otherwise>
</choose>