mybatis 批量將list數(shù)據(jù)插入到數(shù)據(jù)庫(kù)的實(shí)現(xiàn)
隨著業(yè)務(wù)需要,有時(shí)我們需要將數(shù)據(jù)批量添加到數(shù)據(jù)庫(kù),mybatis提供了將list集合循環(huán)添加到數(shù)據(jù)庫(kù)的方法。具體實(shí)現(xiàn)代碼如下:
1、mapper層中創(chuàng)建 insertForeach(List < Fund > list) 方法,返回值是批量添加的數(shù)據(jù)條數(shù)
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類(lèi)代碼如下:
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語(yǔ)句如下:
<?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 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>
到此這篇關(guān)于mybatis 批量將list數(shù)據(jù)插入到數(shù)據(jù)庫(kù)的實(shí)現(xiàn)的文章就介紹到這了,更多相關(guān)mybatis 批量list插入到數(shù)據(jù)庫(kù)內(nèi)容請(qǐng)搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!
相關(guān)文章:
1. MySQL Community Server 5.1.492. MYSQL數(shù)據(jù)庫(kù)存文本轉(zhuǎn)存數(shù)據(jù)庫(kù)問(wèn)題3. 快速刪除ORACLE重復(fù)記錄4. MySQL中 concat函數(shù)的使用5. 數(shù)據(jù)庫(kù)相關(guān)的幾個(gè)技能:ACCESS轉(zhuǎn)SQL6. Oracle災(zāi)難防護(hù)的關(guān)鍵技術(shù)7. Mysql入門(mén)系列:MYSQL創(chuàng)建、刪除、索引和更改表8. MySql遠(yuǎn)程連接的實(shí)現(xiàn)方法9. Delphi中的Access技巧集10. Windows下不能啟動(dòng)mysql服務(wù)--錯(cuò)誤總結(jié)

網(wǎng)公網(wǎng)安備