<insert id="addEmps">
<foreach collection="list" item="emp" open="begin" close="end;">
insert into emptest(
<include refid="insertColumn"></include>
) values
( #{emp.empno}, #{emp.ename}, #{emp.job}, #{emp.mgr}, #{emp.hiredate}, #{emp.sal} );
</foreach>
</insert>
<!-- sql标签 抽取可重用的sql片段,方便重复引用
<include>标签来引用已经抽取的sql
-->
<sql id="insertColumn">
empno, ename, job, mgr,hiredate,sal
</sql>
include标签中还可以定义属性,如下
<include refid="insertColumn">
<property name="testCol" value="abc"/>
</include>
在sql标签中就可以通过 ${testCol}取出"abc"