定时读取一个目录下文本文件数据存入oracle数据库（原创）

我这种插入数据是每个文件中数据对应表中一个字段

import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.util.List;


public class saveData {
public static void main(String[] args) throws Exception {
double begin = System.currentTimeMillis();
Connection conn = null;// 得到数据库连接
PreparedStatement ps = null;
try {
conn = DBUtil.getConnection();
conn.setAutoCommit(false);// 设置自动提交
String dir = "E:/dir";
File file = new File(dir);
if (file.isDirectory()) {
String[] filelist = file.list();
// Map<Integer, List<String>> map = new HashMap<Integer,
// List<String>>();
List<String> Xlist = null;
List<String> Ylist = null;
List<String> WDlist = null;

for (int i = 0; i < filelist.length; i++) {

//把结果集放到map里面，这种方式不知道会不会根据文件对应表中字段插入（我实验几次都行，郁闷）

// listdata = getData(dir + "\\" + filelist[i]);   
// map.put(i + 1, listdata);
File readfile = new File(dir + "\\" + filelist[i]);
if (readfile.isFile()) {
if (filelist[i].contains("lat")) {
Xlist = getData(readfile.getPath());
}
if (filelist[i].contains("lon")) {
Ylist = getData(readfile.getPath());
}
if (filelist[i].contains("t2")) {
WDlist = getData(readfile.getPath());
}
}
}
int n = 0;
for (; n < (Xlist.size()); n++) {
ps = conn
.prepareStatement("insert into TFYJ_RCTQ_YC(id,sb,x,y,wd) values(TFYJ_RCTQ_YC_ID.nextval,?,?,?,?)");


ps.setString(1, "2011-11-10");
ps.setObject(2, Xlist.get(n));
ps.setObject(3, Ylist.get(n));
ps.setObject(4, WDlist.get(n));
// ps.setString(2, map.get(1).get(n));
// ps.setString(3, map.get(2).get(n));
// ps.setString(4, map.get(3).get(n));
ps.addBatch();
ps.executeBatch();
ps.clearBatch();
ps.close();    //在外边关闭会出现超过最大游标数，这么循环插入数据库，我能找到得方法就是在里面关闭了
}
DBUtil.commit(conn);
double end = System.currentTimeMillis();
System.out.println("导入数据表" + n + "条记录用时" + (end - begin)
+ "毫秒,平均存入每条记录用时" + ((end - begin) / n) + "毫秒");


}
} catch (Exception e) {
e.printStackTrace();
} finally {
DBUtil.close(conn);
}
}


public static List<String> getData(String readPath) throws IOException {


File file = new File(readPath);
if (!file.exists()) {
System.out.println("File not exist!");
System.exit(0);
}
BufferedReader br;
br = new BufferedReader(new FileReader(readPath));
String line;
String[] strArr = null;
List<String> list = new ArrayList<String>();
Pattern p = Pattern.compile("^\\s*\\d.*");
if (file.exists()) {


int n = 1;
while ((line = br.readLine()) != null) {
n++;
if (p.matcher(line).matches()) {
strArr = line.replace(";","").replaceAll("\\s*", "").split(",");// 与文件中的分隔符要一致


for (String data : strArr) {
data.trim();
list.add(data);
// System.out.println(data); // 入库的数据
}
}
br.close();
return list;
}

}

至于定时读取 将其配置到一个Quartz中就行了。