<insert id="insertExcel" parameterType="java.util.ArrayList">
<foreach collection="list" item="item" separator=";">
INSERT INTO CUST_INFO
(
<include refid="Base_Column_List" />
)
VALUES
(
${item.custId},
${item.custName},
${item.custSex},
${item.custAge}
)
</foreach>
</insert>
结果
INSERT INTO CUST_INFO
(
CUST_ID,
CUST_NAME,
CUST_SEX,
CUST_AGE
)
VALUES
(9, 测试9, 女, 26);
INSERT INTO CUST_INFO
(
CUST_ID,
CUST_NAME,
CUST_SEX,
CUST_AGE
)
VALUES
(10, 测试10, 女, 27),