1.xml 使用foreach
<insert id="insertList" parameterType="java.util.List"> insert into wh_dock_plan (arrival_date, ship_name, ship_batch, ship_phone, resource_code,pack_code, pack_j_weight, pack_m_weight, pai_code, spec, futures,owner,owner_next,prop_location,settle_accounts,place,plan_type, customer,final_customer,status,pda_tip_info, tenant_id, tenant_name, plan_id, created_time) values <foreach collection="planList" item="item" index="index" separator="," close=";"> ( #{item.arrivalDate}, #{item.shipName}, #{item.shipBatch}, #{item.shipPhone}, #{item.resourceCode}, #{item.packCode}, #{item.packJWeight}, #{item.packMWeight}, #{item.paiCode}, #{item.spec}, #{item.futures}, #{item.owner}, #{item.ownerNext}, #{item.propLocation}, #{item.settleAccounts}, #{item.place}, #{item.planType}, #{item.customer}, #{item.finalCustomer}, #{item.status}, #{item.pdaTipInfo}, #{item.tenantId}, #{item.tenantName}, #{item.planId}, now() ) </foreach> </insert>
2.XXXmapper.java定义传入的对象集合