mybatis+mysql插入大批量数据

================
分批插入

int OPERATER_NUM = 2000;                 //每批插入几条数据
int listSize=newList.size();            //要插入的数据总数
int toIndex=OPERATER_NUM;                     //下一波插入数据的结尾
for(int i = 0;i<newList.size();i+=OPERATER_NUM){
    if(i+OPERATER_NUM>listSize){//作用为toIndex最后没有2000条数据则剩余几条newList中就装几条
        toIndex=listSize-i;
    }
    List<CloudIntegral> cloudIntegralList = newList.subList(i,i+toIndex);
    //批量插入
    cloudIntegralRpcService.insertBatch(cloudIntegralList);
}

 

=============================

mybatis：

<insert id="insertBatch" parameterType="java.util.List">
    insert into cloud_integral
    (<include refid="baseColumn"/>)
    values
    <foreach collection="list" item="item" index="index" separator=",">
        (
            #{item.id},
            #{item.customerId},
            #{item.loginName},
            #{item.customerName},
            #{item.cloudType}
        )
    </foreach>
</insert>

============