id="addEmp">
insert into tbl_employee(last_name,gender,email,d_id)
values
foreach...emp" separator=",">
(#{emp.lastName},#{emp.gender},#{emp.email},#{emp.dept.id})
foreach..., dept=null]
Employee [id=6, lastName=timo, gender=0, email=timo@qq.com, dept=null]
第二种方式需要在配置连接数据源时使用...allowMultiQueries=true
然后在xml文件中:
foreach collection="emps" item="emp...>
这种方式的sql形如:insert into tbl_employee(last_name,gender,email,d_id) values (?