foreach属性
xml
insert into u_test ( id,lcid) <foreach collection="list" item="item" index="index" separator=" union all" open="(" close=")"> select #{item.id}, #{item.lcid} from dual </foreach>
正常批量执行SQL
INSERT INTO u_test(id, lcid) (select '1','123' from dual union all select '2','345' from dual)