<if test="null!=idList and idList.size>0"> and id in <foreach
collection="idList" index="index" item="item" open="(" separator=","
close=")">#{item}</foreach></if>

and id in <foreach
collection="idList" index="index" item="item" open="(" separator=","
close=")">#{item}</foreach>

<if test="null!=userName and ''!=userName"> 
    and user_name = #{userName} 
</if>

<if test="null!=userName and ''!=userName">
    and user_name like  CONCAT(?,'%')
</if>

-- column
id,code,user_name,mobile_phone,address,create_time

<if test="@com.vonchange.mybatis.tpl.MyOgnl@isNotEmpty(idList) and @com.vonchange.mybatis.tpl.MyOgnl@isNotEmpty(userName) "> 
    and id in 
    <foreach collection="idList" index="index" item="item" open="(" separator="," close=")">
    #{item}</foreach> 
    and user_name like  CONCAT('%',#{userName},'%')  
</if>