03_mybatis批量插入

数据批量插入数据库：如新增用户的批量插入

 

1、实体代码

package com.center.manager.entity;

@lombok
public class User{
    private  String id;
    private String name;      
    private String age;      
}

 

2、dao代码

package com.center.manager.mapper;

import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import com.center.manager.entity.User;

@Mapper
public interface UserMapper {
	int insertForeach(List<User> list);
}

 

3、xml代码

<?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.UserMapper">
 
	<insert id="insertForeach" parameterType="java.util.List" useGeneratedKeys="false">
        insert into fund
        ( id,name,age)
        values
        <foreach collection="list" item="item" index="index" separator=",">
            (
            	#{item.id},
            	#{item.name},
            	#{item.age}
            )
        </foreach>		
    </insert>    
</mapper