最近的批量添加折磨的我死去活来
各种找资料各种尝试 终于整明白的一点
后台接到前台传来的数据,我接的是json 然后转List
将list存入map中
(eg:
map.put("man",list);
map.put("link_num",param);
),
xml里:
<span style="font-family:KaiTi_GB2312;font-size:18px;"><insert id="linkadd" parameterClass="java.util.HashMap">
insert all
<iterate conjunction="" property="man">
into tb_linkman
(linkm_id, linkm_num, linkm_name, linkm_tel, linkm_rel, linkm_add)
values
(#man[].linkm_id#,
#linkm_num#,
#man[].linkm_name#,
#man[].linkm_tel#,
#man[].linkm_rel#,
#man[].linkm_add#)
</iterate>
select * from dual
</insert></span>
<span style="font-family:KaiTi_GB2312;font-size:18px;"> linkm_num,每次都相同,所以不用man[]. ;</span>
<span style="font-family:KaiTi_GB2312;font-size:18px;">最后的</span><pre name="code" class="html"><span style="font-family:KaiTi_GB2312;font-size:18px;">select * from dual必须加上 否则会报缺失select关键字</span>