mybatis在使用参数为list时候
<select id="getAllSupplierFileMessage" resultType="com.benleiyun.adminbiz.BO.ReturnFileMessage">
SELECT
file.id,
file.file_name,
file.file_type,
file.file_url,
file.created_by,
file.updated_time,
operation.id AS operationId,
operation.pro_name,
type.file_type AS type
FROM
pro_file file
INNER JOIN pro_epiboly_record record ON file.biz_id = record.pro_id
LEFT JOIN pro_file_type type ON type.id = file.file_type
LEFT JOIN pro_operation operation ON file.biz_id = operation.id
<where> file.del_flag = '0'
<if test="queryFileMessage.supName != null and queryFileMessage.supName !=''">and record.sup_name = #{queryFileMessage.supName}</if>
<if test="queryFileMessage.fileName != null and queryFileMessage.fileName !=''">and file.file_name = #{queryFileMessage.fileName}</if>
<if test="queryFileMessage.fileType != null and queryFileMessage.fileType !=''">and file.file_type = #{queryFileMessage.fileType}</if>
<if test="queryFileMessage.proName != null and queryFileMessage.proName !=''">and operation.pro_name = #{queryFileMessage.proName}</if>
<if test="queryFileMessage.proIds != null">
AND operation.id in
<foreach item="item" index="index" collection="queryFileMessage.proIds"
open="(" separator="," close=")">
#{item}
</foreach>
</if>
</where>
</select>