ibatis批量导入

ibatis批量导入

ibatis中xml，sql配置文件写法，list[]对应传入的list对象

<insert id="abatorgenerated_insertByBatch" parameterClass="java.util.List" >
    <!--
      WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
      This element was generated on Fri May 18 15:34:06 CST 2018.
    -->
    <![CDATA[  
           insert into t_cpl_info (cpl_uuid, material_name, clip, remark1, remark2, valid, create_time,
      create_user, update_time, update_user) values  
       ]]>    
       <iterate  conjunction ="," >   
           <![CDATA[  
               (#list[].cplUuid#, #list[].materialName#, #list[].clip#,#list[].remark1#,#list[].remark2#,#list[].valid#,#list[].createTime#,#list[].createUser#,#list[].updateTime#,#list[].updateUser#)  
           ]]>
       </iterate>   
  </insert>

对应的dao层批量插入实现：

public Long insertByBatch(List<CplInfo> list) {
	//每批次插入数量
        int batchCount = 1000;
        //游标
        int index = 0;
        //批次
        int batchNum = 1;
        for(;;){
            if(index+batchCount>=list.size()){
                //一次可全部插入
                getSqlMapClientTemplate().insert("ext_cpl_info.abatorgenerated_insertByBatch"
                    , list.subList(index,list.size()));
                break;
            }else {
                //需要多次插入
            	List<CplInfo> cplInfo = list.subList(index, index + batchCount);
                getSqlMapClientTemplate().insert("ext_cpl_info.abatorgenerated_insertByBatch"
                    , cplInfo);
                index = index+batchCount;
            }
            batchNum++;
        }
        System.out.println("over~,总共插入"+list.size()+"条，插入了"+batchNum+"批");
        return null;
	}

通过上面的实现数据批量的限制条数的插入。