MyBatis写入大量数据

合集 - MyBatis(16)

1.resultType和resultMap的区别2018-05-262.<association>关联的结果查询2018-05-263.新增返回主键2018-05-274.<foreach/>标签原理及用法2018-05-275.返回List<Map<String, String>>键值对格式2018-05-266.<collection>映射集合结果查询2018-05-267.Mybatis的执行流程2022-06-08

8.MyBatis写入大量数据2020-04-16

9.MyBatis读取大量数据（流式读取）2020-04-0810.MyBatis Generator 自动生成工具（dao / mapping / model）2018-08-2211.MyBatisPlus怎么忽略映射字段2018-05-2712.MyBatisPlus AutoGenrator代码自动生成2018-05-2713.<resultMap/> 标签支持继承 extends2018-05-2714.SpringData JPA、Hibernate、Mybatis三者的区别2023-10-1715.Mybatis代码生成——velocity模板元素2023-10-2716.Mybatis代码生成——velocity模板语法2023-10-27

收起

1. Servcie

public void insertBatch(List<ExtendedAreaSucharge> extendedAreaSucharges) {
    int groupSize = 500;
    int groupNo = extendedAreaSucharges.size() / groupSize;

    if (extendedAreaSucharges.size() <= groupSize) {
        extendedAreaSuchargeDao.saveBatch(extendedAreaSucharges);
    } else {
        List<ExtendedAreaSucharge> subList = null;
        for (int i = 0; i < groupNo; i++) {
            subList = extendedAreaSucharges.subList(0, groupSize);
            extendedAreaSuchargeDao.saveBatch(subList);
            extendedAreaSucharges.subList(0, groupSize).clear();
        }
        if (extendedAreaSucharges.size() > 0) {
            extendedAreaSuchargeDao.saveBatch(extendedAreaSucharges);
        }
    }
}

2. Mapper.java

@Mapper
public interface ExtendedAreaSuchargeDao {
    void saveBatch(@Param("extendedAreaSuchargeList") List<ExtendedAreaSucharge> extendedAreaSuchargeList);
}

3. Mapper.xml

<sql id="keyBatch">
        id,organization_id,version,calc_type,country_code,country_name,covert,kg_price,logistics_supplier_item_id,logistics_supplier_item_name,min_charge,no_zero_length,number_code,original_desc,post_code,post_code_end,post_code_start,post_code_type,prefix,post_code_end4char,post_code_start4char
    </sql>
    <sql id="valueBatch">
        #{item.id},#{item.organizationId},#{item.version},#{item.calcType, typeHandler=org.apache.ibatis.type.EnumOrdinalTypeHandler},#{item.countryCode},#{item.countryName},#{item.covert},#{item.kgPrice},#{item.logisticsSupplierItemId},#{item.logisticsSupplierItemName},#{item.minCharge},#{item.noZeroLength},#{item.numberCode},#{item.originalDesc},#{item.postCode},#{item.postCodeEnd},#{item.postCodeStart},#{item.postCodeType, typeHandler=org.apache.ibatis.type.EnumOrdinalTypeHandler},#{item.prefix},#{item.postCodeEnd4Char},#{item.postCodeStart4Char}
    </sql>
    <insert id="saveBatch">
        INSERT INTO surc_extended_area_sucharge
        (<include refid="keyBatch"/>)
        values
        <foreach collection="extendedAreaSuchargeList" item="item" index="index" separator=",">
            (<include refid="valueBatch"/>)
        </foreach>
    </insert>