mybatis批量处理

DAO层方法

int insertBatch(@Param("entities") List entities);

Mapper.xml

    
        insert into CATALOG_CHECK_RES_ITEM(CHECK_RES_ITEM_ID,CHECK_RES_ID ,CATALOG_ID, RESOURCE_ID) values (sys_guid(), #{entity.checkResId},#{entity.catalogId}, #{entity.resourceId})
    

DAO层方法

int saveInfoBatch(List list);

Mapper.xml 

        INSERT INTO catalog.CATALOG_PUBLISH_INFO (ID,SERIAL_NO,ORG_ID,CATALOG_ID
        ,CATALOG_NUMBER,CREATOR_DEPT_ID,
        CREATE_TIME,PUBLISH_TIME,OPERATOR_ID,OPERATOR_DEPT_ID,OPERATE_TIME) select
        A.* from(
        
            SELECt
            #{list.id,jdbcType=VARCHAR} ID,
            #{list.serialNo,jdbcType=VARCHAR} SERIAL_NO,
            #{list.orgId,jdbcType=VARCHAR} ORG_ID,
            #{list.catalogId,jdbcType=VARCHAR} CATALOG_ID,
            #{list.catalogNumber,jdbcType=VARCHAR} CATALOG_NUMBER,
            #{list.creatorDeptId,jdbcType=NUMERIC} CREATOR_DEPT_ID,
            to_date(#{list.createTime,jdbcType=VARCHAR},'yyyy-MM-dd hh24:mi:ss') CREATE_TIME,
            to_date(#{list.publishTime,jdbcType=VARCHAR},'yyyy-MM-dd hh24:mi:ss') PUBLISH_TIME,
            #{list.operatorId,jdbcType=VARCHAR} OPERATOR_ID,
            #{list.operatorDeptId,jdbcType=VARCHAR} OPERATOR_DEPT_ID,
            to_date(#{list.operateTime,jdbcType=VARCHAR},'yyyy-MM-dd hh24:mi:ss') OPERATE_TIME
            FROM dual
        
        ) A

DAO层方法

int updateInfoBatch( List entities);

Mapper.xml

    update catalog.CATALOG_PUBLISH_INFO
    
        
            
                when id = #{item.id} then #{item.serialNo}
            
        
        
            
                when id = #{item.id} then #{item.orgId}
            
         
         
            
                when id = #{item.id} then #{item.catalogNumber}
            
         
         
             
                when id = #{item.id} then #{item.catalogName}
             
         
         
             
                 when id = #{item.id} then #{item.publishContent}
             
         
    
    where id in
    
        #{item.id}
    

DAO层方法

int deleteCatalogPublishInfoChildren(List list);

Mapper.xml

    delete
        from catalog.CATALOG_PUBLISH_RES_ITEM
        where id in (
        
            #{id}
        
        )