Question

mybatis传值同时传入list和string该怎么弄

Answer 1

参数用map

insert into table
<foreach collection="list" item="item" index="index" separator=" union all ">
   select #{key1}, #{key2}, #{item.value}
</foreach>

调用方法

Map<String, Object> map = new HashMap<String, Object>();
map.put("key1", value1);
map.put("key2", value2);
map.put("list", list);
mapper.insert(map);