81,122
社区成员




String filePath = "D:\\bbb.csv";
BufferedReader bufferedReader = null;
Connection conn = null;
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, "root", "123456");
bufferedReader = new BufferedReader(new InputStreamReader(new FileInputStream(filePath)));
String line = null;
while ((line = bufferedReader.readLine()) != null) {
String[] columns = line.split(",");
if(columns[0].trim().equalsIgnoreCase("序号")){
continue;
}
PreparedStatement pstmt = conn.prepareStatement("insert into test(xh,kaohao,name,sex,sfz,zy,xf)values(?,?,?,?,?,?,?)");
pstmt.setString(1, columns[0]);
pstmt.setString(2, columns[1]);
pstmt.setString(3, columns[2]);
pstmt.setString(4, columns[3]);
pstmt.setString(5, columns[4]);
pstmt.setString(6, columns[5]);
pstmt.setString(7, columns[6]);
pstmt.executeUpdate();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
bufferedReader.close();
} catch (Exception e) {
e.printStackTrace();
}
}