1.把多个ID嵌入入到DTO的一个List中,并把DTO传入到Mybatis中。
DTO类的例子,嵌入一个POJO的类的List
public class TargetDTO implements Serializable {
private static final long serialVersionUID = -**********;
List<Integer> intList;
public List<Integer> getIntList() {
return intList;
}
public void setIntList(List<Integer> intList) {
this.intList = intList;
}
}
MyBatis的Sql配置文件
<select id="select" parameterType="com.finway.boss.admin.basicfunction.dto.TargetDTO" resultType="com.finway.boss.admin.basicfunction.vo.Target">
SELECT * FROM boss_target_setup WHERE 1 = 1
<if test='intList!=null and intList.size()>0'>
and setup_id IN
<foreach collection="intList" item="item" index="index" open="(" separator="," close=")">
#{item}
</foreach>
</if>
</select>