Mybitis 批量插入实践

对应的DAO层

    int insertOrderBatch(List list);

批量插入mapper:

        insert into table_order
        (id, ref_no,finance)
        values
        
            (#{item.id,jdbcType=VARCHAR}, #{item.refNo,jdbcType=VARCHAR},#{item.finance,jdbcType=VARCHAR})