Mybatis之批量插入

1397535668

<insert id="insertEmpSelectiveBatch" parameterType="java.util.List" >
begin
<foreach collection="list" item="item" index="index" separator=";" >
insert into EMP
<trim prefix="(" suffix=")" suffixOverrides="," >
<if test="item.empno != null">
EMPNO,
</if>
<if test="item.ename != null">
ENAME,
</if>
<if test="item.job != null">
JOB,
</if>
<if test="item.mgr != null">
MGR,
</if>
<if test="item.hiredate != null">
HIREDATE,
</if>
<if test="item.sal != null">
SAL,
</if>
<if test="item.comm != null">
COMM,
</if>
<if test="item.deptno != null">
DEPTNO,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="item.empno != null">
#{item.empno,jdbcType=DECIMAL},
</if>
<if test="item.ename != null">
#{item.ename,jdbcType=VARCHAR},
</if>
<if test="item.job != null">
#{item.job,jdbcType=VARCHAR},
</if>
<if test="item.mgr != null">
#{item.mgr,jdbcType=DECIMAL},
</if>
<if test="item.hiredate != null">
#{item.hiredate,jdbcType=TIMESTAMP},
</if>
<if test="item.sal != null">
#{item.sal,jdbcType=DECIMAL},
</if>
<if test="item.comm != null">
#{item.comm,jdbcType=DECIMAL},
</if>
<if test="item.deptno != null">
#{item.deptno,jdbcType=DECIMAL},
</if>
</trim>
</foreach>
;commit;end;
</insert>