最近项目中遇到一个问题:导入数据到后台并将数据插入到数据库中,导入的数据量有上万条数据,考虑采用批量插入数据的方式;
结合网上资料,写了个小demo,文章末尾附上demo下载地址
1、新建项目:项目目录结构如下图所示,添加相应的jar包
2、新建数据库表:ACCOUNT_INFO
1 CREATE TABLE ACCOUNT_INFO (
2 "ID" NUMBER(12) NOT NULL ,
3 "USERNAME" VARCHAR2(64 BYTE) NULL ,
4 "PASSWORD" VARCHAR2(64 BYTE) NULL ,
5 "GENDER" CHAR(1 BYTE) NULL ,
6 "EMAIL" VARCHAR2(64 BYTE) NULL ,
7 "CREATE_DATE" DATE NULL
8 )
3、创建AccountInfo实体类:
1 package com.oracle.entity;
2
3 import java.sql.Date;
4
5 public class AccountInfo {
6 private Long id;
7 private String userName;
8 private String password;
9 private String gender;
10 private String email;
11 private Date createDate;
12
13 public Long getId() {
14 return id;
15 }
16
17 public void setId(Long id) {
18 this.id = id;
19 }
20
21 public String getUserName() {
22 return userName;
23 }
24
25 public void setUserName(String userName) {
26 this.userName = userName;
27 }
28
29 public String getPassword() {
30 return password;
31 }
32
33 public void setPassword(String password) {
34 this.password = password;