1.mapper.java
Integer insertClaimInvoices(@Param("claimInvoices") List<ClaimInvoice> claimInvoices);
有的说可以不写,但是写了一定没错
<!-- 批量插入数据 --> <insert id="insertClaimInvoices" parameterType="java.util.List"> INSERT INTO CLAIM_INVOICE ( ID, CLAIM_NO, CONTRACT_NO, POLICY_NO, COVERAGE_CODE, COVERAGE_NAME, FEE_TYPE_CODE, SUM_EVALUATE, TAX_IND, TAX_RATE, INVOICE_AMOUNT, INVOICE_PARTY, INVOICE_TYPE ) VALUES <!--这个是系统生成的,这块当初有个括号,删除便好了 --> <foreach collection="claimInvoices" index="index" item="item" separator=","> (<!--claimInvoices与mapper.java名词一致。 item 与下面插入的数据一致--> #{item.id}, #{item.claimNo}, #{item.contractNo}, #{item.policyNo}, #{item.coverageCode}, #{item.coverageName}, #{item.feeTypeCode}, #{item.sumEvaluate}, #{item.taxInd}, #{item.taxRate}, #{item.invoiceAmount}, #{item.invoiceParty}, #{item.invoiceType} ) </foreach> </insert>