mybatis map中存放数组进行foreach遍历

1.入参 JSON格式

{
    "id":"1234567"
    "type": [1, 2, 3]
}

2.mapper 方法

List<Map<String, Object>> query(Map<String, Object> param);

3.sql

foreach中  collection="type"  为入参中map 的key，  item 自定义 代表值的名称

<select id="query" resultType="java.util.HashMap">
       SELECT *
	   FROM tableName t
	   WHERE  1=1 and t.type IN
	   <foreach collection="type" item="item" open="(" separator="," close=")">
            #{item}
       </foreach>
</select>