mybatis的xml中集合用法

mybatis 集合

select * from t_user where 1 = 1 

<if test="null != userNameList anduserNameList .size > 0">

  and user_name in

<foreach collection="userNameList " item="userName" open="(" separator=","  close=")">
 #{userName}
</foreach>
</if>