最近项目中遇到一个问题：导入数据到后台并将数据插入到数据库中，导入的数据量有上万条数据，考虑采用批量插入数据的方式；
结合网上资料，写了个小demo，文章末尾附上demo下载地址
1、新建项目：项目目录结构如下图所示，添加相应的jar包
2、新建数据库表：ACCOUNT_INFO
CREATE TABLE ACCOUNT_INFO ( "ID" NUMBER(12) NOT NULL , "USERNAME" VARCHAR2(64 BYTE) NULL , "PASSWORD" VARCHAR2(64 BYTE) NULL , "GENDER" CHAR(1 BYTE) NULL , "EMAIL" VARCHAR2(64 BYTE) NULL , "CREATE_DATE" DATE NULL )
3、创建AccountInfo实体类：
package com.oracle.entity;
import java.sql.Date;
public class AccountInfo {
private Long id;
private String userName;
private String password;
private String gender;
private String email;
private Date createDate;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public Date getCreateDate() {
return createDate;
}
public void setCreateDate(Date createDate) {
this.createDate = createDate;
}
@Override
public String toString() {
return "AccountInfo [id=" + id + ", userName=" + userName
+ ", password=" + password + ", gender=" + gender + ", email="
+ email + ", createDate=" + createDate + "]";
}
}
4、新建接口映射类：AccountInfoMapper.java
package com.oracle.mapper;
import java.util.List;
import com.oracle.entity.AccountInfo;
public interface AccountInfoMapper {
/**
* 查询所有的数据
* @return
*/
List<AccountInfo> queryAllAccountInfo();
/**
* 批量插入数据
*
* @param accountInfoList
* @return
*/
int batchInsertAccountInfo(List<AccountInfo> accountInfoList);
}
5、创建mybatis配置文件：mybatis-configuration.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC" /> <dataSource type="POOLED"> <property name="driver" value="oracle.jdbc.driver.OracleDriver" /> <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" /> <property name="username" value="xxx" /> <property name="password" value="xxx" /> </dataSource> </environment> </environments> <mappers> <mapper resource="config/AccountInfoMapper.xml" /> </mappers> </configuration>
6、创建接口映射配置文件：AccountInfoMapper.xml
Oracle的批量插入数据库跟MySQL不一样，
MySQL：
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持phpstudy。