隨著業務需要，有時我們需要將數據批量添加到數據庫，mybatis提供了將list集合循環添加到數據庫的方法。具體實現代碼如下:
1、mapper層中創建 insertForeach(List < Fund > list) 方法,返回值是批量添加的數據條數
|
1
2
3
4
5
6
7
8
9
|
package com.center.manager.mapper;import java.util.List;import org.apache.ibatis.annotations.Mapper;import com.center.manager.entity.Fund;@Mapperpublic interface FundMapper {int insertForeach(List<Fund> list);} |
Fund類代碼如下:
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
package com.center.manager.entity;import java.util.Date;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; public String getId() {return id;}public void setId(String id) {this.id = id;}public String getFundName() {return fundName;}public void setFundName(String fundName) {this.fundName = fundName;}public String getFundCode() {return fundCode;}public void setFundCode(String fundCode) {this.fundCode = fundCode;}public String getDateX() {return dateX;}public void setDateX(String dateX) {this.dateX = dateX;}public String getDataY() {return dataY;}public void setDataY(String dataY) {this.dataY = dataY;} public String getRemarks() {return remarks;}public void setRemarks(String remarks) {this.remarks = remarks;}public String getCreateBy() {return createBy;}public void setCreateBy(String createBy) {this.createBy = createBy;}public Date getCreateDate() {return createDate;}public void setCreateDate(Date createDate) {this.createDate = createDate;}public String getUpdateBy() {return updateBy;}public void setUpdateBy(String updateBy) {this.updateBy = updateBy;}public Date getUpdateDate() {return updateDate;}public void setUpdateDate(Date updateDate) {this.updateDate = updateDate;}public String getDelFlag() {return delFlag;}public void setDelFlag(String delFlag) {this.delFlag = delFlag;}} |
2、mybatis的xml文件中的insert語句如下:
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
<?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> |
到此這篇關于mybatis 批量將list數據插入到數據庫的實現的文章就介紹到這了,更多相關mybatis 批量list插入到數據庫內容請搜索服務器之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持服務器之家！
原文鏈接：https://blog.csdn.net/wsjzzcbq/article/details/81779588
