MyBatis完成MySQL的批量操作主要是通过<foreach>标签来拼装相应的SQL语句.
例如:
- <insert id="insertBatch" >
- insert into tbl_employee(last_name,email,gender,d_id) values
- <foreach collection="emps" item="curr_emp" separator=",">
- (#{curr_emp.lastName},#{curr_emp.email},#{curr_emp.gender},#{curr_emp.dept.id})
- </foreach>
- </insert>