Mybatis 批量将list数据插入到数据库竟然这样处理

- 日理万妓 2022-10-13 05:22 130阅读 0赞

随着业务需要，有时我们需要将数据批量添加到数据库，`mybatis`提供了将`list`集合循环添加到数据库的方法。具体实现代码如下:

<table style="width:568px;"> 
 <tbody> 
  <tr> 
   <td style="width:565px;"><strong>mapper/serverice层中创建<code>insertForeach</code> 接口方法,返回值是批量添加的数据条数</strong></td> 
  </tr> 
 </tbody> 
</table>

package com.center.manager.mapper;
    	import java.util.List;
    	import org.apache.ibatis.annotations.Mapper;
    	import com.center.manager.entity.Fund;
    	@Mapper
    	public interface FundMapper {
    	
    		int insertForeach(List<Fund> list);
    	}

--------------------

Fund类代码如下:

package com.center.manager.entity;
    	import java.util.Date;
    
        @Lomok
    	public class Fund {
    
    	    private  String id;
    	
    		private String fundName;      
    	
    		private String fundCode;      
    	
    		private String dateX;         
    	
    		private String dataY;         
    
    	    private String remarks; 
    	
    		private String createBy; 
    	
    		private Date createDate; 
    	
    		private String updateBy; 
    	
    		private Date updateDate; 
    	
    		private String delFlag; 
    
    	}

--------------------

**mybatis的xml文件中的insert语句如下:**

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    <mapper namespace="com.center.manager.mapper.FundMapper">
    
    	<insert id="insertForeach" parameterType="java.util.List" useGeneratedKeys="false">
        			insert into fund
        			( id,fund_name,fund_code,date_x,data_y,create_by,create_date,update_by,update_date,remarks,del_flag)
        			values
        			<foreach collection="list" item="item" index="index" separator=",">
        				(
        					#{item.id},
        					#{item.fundName},
        					#{item.fundCode},
        					#{item.dateX},
        					#{item.dataY},
        					#{item.createBy},
        					#{item.createDate},
        					#{item.updateBy},
        					#{item.updateDate},
        					#{item.remarks},
        					#{item.delFlag}
        				)
        		     </foreach>		
        </insert>    
    </mapper>

--------------------

![format_png][]

**想要实时关注更多干货好文，扫描下图关注成功后回复【小程序】：**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70][]

[format_png]: /images/20221005/991015454c8f4ffa9d6a1a814cfb08b9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70]: /images/20221005/43e9bfb186b24952ac6f0526237149c9.png