Mybatisd对MySQL批量插入、批量更新及批量删除语句

1、批量插入

`<insert

1    id="insertBatch" 
2
3    parameterType="java.util.List">
4
5    insert into 
6
7        t_student(name, age, class)
8
9    values
10
11    <foreach 
12
13        collection="list" 
14
15        item="item" 
16
17        index="index" 
18
19        separator=",">
20
21        (
22
23            #{item.name,jdbcType=VARCHAR}, 
24
25            #{item.age,jdbcType=INTEGER},
26
27            #{item.class,jdbcType=LONGVARCHAR}
28
29        )
30
31    </foreach>

</insert>`

2、批量更新