Mybatis-Mysql批量插入

发表于 | 更新于 | 分类于

摘要：Mybatis-Mysql批量插入实现

dao 批量插入方法
1
int batchInsert( @Param("list") List<Demo> demoList);
mapper.xml 批量插入SQL配置
1
2
3
4
5
6
7
8
9
10
11
12
13
<insert id="batchInsert" parameterType="java.util.List">
    INSERT INTO t_demo
    <trim prefix="(" suffix=")" suffixOverrides=",">
        id, name
    </trim>
    <trim prefix="VALUES " suffixOverrides=",">
        <foreach collection="list" item="var" separator=",">
            <trim prefix="(" suffix=")" suffixOverrides=",">
                #{var.id}, #{var.name},
            </trim>
        </foreach>
    </trim>
</insert>