<insert id="test" parameterType="list">
insert into test(id,name)
<foreach collection="list" separator="union all" index="index" item="obj">
select #{obj.id},#{obj.name} from dual
</foreach>
</insert>
@Test
public void testTest() {
List<Map<String,Object>> list = new ArrayList<Map<String,Object>>();
Map<String,Object> map= new HashMap<String,Object>();
map.put("id", 1);
map.put("name", "张三");
Map<String,Object> map2= new HashMap<String,Object>();
map2.put("id", 2);
map2.put("name", "李四");
list.add(map);
list.add(map2);
onlineProjectMybatisDao.test(list);
}
生成的sql:
insert into test(id,name) select ?,? from dual union all select ?,? from dual