public class TestReadcsvFile {
public static void main(String[] args) {
readFile("D:/csvf/csvTestFile.csv");
}
public static void readFile(String filePath){
Connection conn = null;
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
CsvReader read = null;
try {
Class.forName(driver);
conn = (Connection) DriverManager.getConnection(url, "root", "panpan");
// 创建CSV读对象 例如:CsvReader(文件路径,分隔符,编码格式);
read = new CsvReader(filePath, ',', Charset.forName("UTF-8"));
// 跳过第一行 如果需要,可以忽略
read.readHeaders();
while(read.readRecord()){
System.out.println(read.getRawRecord());
String lineTxt = read.getRawRecord();
String[] columns = lineTxt.split(",");
String sql = "insert into T_USER(NAME,PASSWORD,AGE,ADDRESS) values(?,?,?,?)";
PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
ps.setString(1, columns[0]);
ps.setString(2, columns[1]);
ps.setString(3, columns[2]);
ps.setString(4, columns[3]);
ps.executeUpdate();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
read.close();
} catch (Exception e) {
// TODO Auto-generated catch block
System.out.println("读取文件出错");
e.printStackTrace();
}
}
}
public static void main(String[] args) {
readFile("D:/csvf/csvTestFile.csv");
}
public static void readFile(String filePath){
Connection conn = null;
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
CsvReader read = null;
try {
Class.forName(driver);
conn = (Connection) DriverManager.getConnection(url, "root", "panpan");
// 创建CSV读对象 例如:CsvReader(文件路径,分隔符,编码格式);
read = new CsvReader(filePath, ',', Charset.forName("UTF-8"));
// 跳过第一行 如果需要,可以忽略
read.readHeaders();
while(read.readRecord()){
System.out.println(read.getRawRecord());
String lineTxt = read.getRawRecord();
String[] columns = lineTxt.split(",");
String sql = "insert into T_USER(NAME,PASSWORD,AGE,ADDRESS) values(?,?,?,?)";
PreparedStatement ps = (PreparedStatement) conn.prepareStatement(sql);
ps.setString(1, columns[0]);
ps.setString(2, columns[1]);
ps.setString(3, columns[2]);
ps.setString(4, columns[3]);
ps.executeUpdate();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
read.close();
} catch (Exception e) {
// TODO Auto-generated catch block
System.out.println("读取文件出错");
e.printStackTrace();
}
}
}
}
需要导入javacsv,mysql-connector-java jar包。