mybatis中hashMap为参数,循环插入key,value数据

map格式:

Map<String,Boolean> map = new HashMap<>();
map.put("2020-3-3",Boolean.TRUE)
map.put("2020-3-6",Boolean.TRUE)
map.put("2020-3-7",Boolean.TRUE)
map.put("2020-3-8",Boolean.TRUE)

mapper:

int insert(@Param("paramsMap")Map<String,Boolean> paramsMap);

sql:

insert into <include refid="tablename" />
(date_key,holiday) values
<foreach item="item" index="key" collection="paramsMap" separator=",">
  (#{key}, #{item})
</foreach>
posted @ 2020-04-29 10:33  冬凛  阅读(2229)  评论(0)    收藏  举报