mybatis in集合查询

java 代码

ic class SpecialReportDao extends BaseDao{/** * 得到用户的所有的渠道专题 * privs:权限 * */public List<ReportIndex> getSpecialReport(String privs){Map map = new HashMap();map.put("privs", privs);return this.queryForList("SPECIAL_REPORT.getSpecialReport", map);}

mybatis 查询

<select id="getSpecialReport" parameterType="map" resultMap="reportIndexMap"> select * from TB_JN_CDE_INDEX where report_type  = 3 and index_id in (  ${privs} ) </select>

执行后的sql

 select * from TB_JN_CDE_INDEX where report_type = 3 and index_id in ( 601,60101,6010101,6010102 )