1.首先插入的时候传递的是list集合,那么就需要在collection后面写成list,例如:
<insert id ="InsertReaCodeDlInfos" parameterType="java.util.List" > INSERT INTO tpm_reacodegdlinfo (Guid,ReaCGGd,ReaCGd,Creator,CreateTime,LastModifyMan,LastModifyTime,Remark) VALUES <foreach collection ="list" item="reaCodeDlInfo" index= "index" separator =","> ( #{reaCodeDlInfo.guid}, #{reaCodeDlInfo.ReaCGGd},#{reaCodeDlInfo.ReaCGd},#{reaCodeDlInfo.creator}, #{reaCodeDlInfo.createTime},#{reaCodeDlInfo.lastModifyMan},#{reaCodeDlInfo.lastModifyTime},#{reaCodeDlInfo.Remark} ) </foreach > </insert >2.测试返回的数据是几条,我一次性插入的是两条数据,那么应该返回的结果是2,测试如下:
int i = reasongDAO.InsertReaCodeDlInfos(reaCodeGdlInfoList); if(i < reaCodeGdlInfoList.size()){ throw new SystemException("0x00001","新增失败"); }i的结果就是2.