62,614
社区成员
发帖
与我相关
我的任务
分享
String[] parts = line.split(",");
StringBuilder b = new StringBuilder();
b.append("insert into myTable(id,name,address,phone) values (");
for (String s : parts) {
b.append("'" + s + "',");
}
b.deleteCharAt(b.length() - 1);
b.append(")");
String sql = b.toString();
insert into myTable(id,name,address,phone) values ('1','java2000.net','天津','不告诉你')
private static void readCSV() throws IOException {
File[] files = new File("D:\\csvfile").listFiles();//到目录下取文件
BufferedReader br = null;
try {
for (File file : files) {//遍历所有文件
if (!file.isFile()) {//如果不是文件则跳过
continue;
}
br = new BufferedReader(new InputStreamReader(
new FileInputStream(file)));//获得文件流
String line = null;
while ((line = br.readLine()) != null) {//读取一行
// inserDb(line.split(","));//将这一行插入db
}
}
} finally {
if (br != null) {
br.close();
}
}
}