动态sql 单选变多选

实体类
添加数组存储值
private ArrayList tssjfjList;

<!--            <if test="tssjfj != null  and tssjfj != ''">and tssjfj = #{tssjfj}</if>--><if test="tssjfjList != null and tssjfjList.size() > 0">AND tssjfj IN<foreach item="item" index="index" collection="tssjfjList" open="(" separator="," close=")">#{item}</foreach></if>

存在循环且模糊匹配的情况

  <if test="corpbqList != null and corpbqList.size() > 0">AND (<foreach item="item" index="index" collection="corpbqList" open="(" separator=" OR " close=")">typed LIKE CONCAT('%', #{item}::text, '%')</foreach>)</if>