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 )