<!-- 迭代 in 查询 -->
<select id="getJnrjVoByIn" parameterClass="map" resultClass="Jnrj">
select * from jnrj
<iterate prepend="where id in" property="idList" open="(" close=")" conjunction=",">
#idList[]#
</iterate>
</select>
通过 <iterate>标签进行处理 参入参数直接List即可
//测试 IN 查询
Map<String,List<Integer>> param = new HashMap<>();
param.put("idList", Arrays.asList(1740,1742,1743,1744));
List<Jnrj> list = sqlMap.queryForList("getJnrjVoByIn", param);
查看控制台打印信息