因为项目要求,需要读取本地文件,实现数据采集,然后批量导入数据库。
友情提示:下面代码中关于数据库的操的代码有的是封装好的,比如save()方法,findBatchNum()方法并没有在本篇博客中贴出来,但是方法的作用会以注释形式声明。
数据采集(bean)
<span style="font-size:14px;">package test;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
public class User {
private String name;
private String address;
private String phone;
private String company;
private Integer idCard;
private Integer blood;
private Long id;
public static User parse(String str){
User u = new User();
String[] s = str.split("\\|");
u.setName(s[0].equals("未采集")?"":s[0]);
u.setAddress(s[1].equals("未采集")?"":s[1]);
u.setPhone(s[2].equals("未采集")?"":s[2]);
u.setCompany(s[3].equals("未采集")?"":s[3]);
u.setIdCard(s[4].equals("未采集")?0:Integer.parseInt(s[4]));
u.setBlood(s[5].equals("未采集")?0:Integer.parseInt(s[5]));
return u ;
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getCompany() {
return company;
}
public void setCompany(String company) {
this.company = company;
}
public Integer getIdCard() {
return idCard;
}
public void setIdCard(Integer idCard) {
this.idCard = idCard;
}
public Integer getBlood() {
return blood;
}
public void setBlood(In