虽说很简单,但俺刚开始思路绕了,以此记之
至于定时读取,用Quartz很简单的 0_0
package com.bj.save;
import java.io.File;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import java.util.Map.Entry;
import com.bj.util.DBUtil;
public class BackupData {
/**
* 将读取出来的数据插入到数据库
*
* @throws SQLException
*/
public void saveData(String localdir) throws SQLException {
double begin = System.currentTimeMillis();
Connection conn = null;
PreparedStatement ps = null;
try {
conn = DBUtil.getConnection();
DBUtil.setAutoCommit(conn, false);// 设置自动提交
File file = new File(localdir);
if (file.isDirectory()) {
System.out.println("读取文件夹中文件信息");
int m = 0;
File[] listFiles = file.listFiles();
Map<String, File> latHashMap = new HashMap<String, File>();
Map<String, File> t2HashMap = new HashMap<String, File>();
Map<String, File> lonHashMap = new HashMap<String, File>();
for (File file2 : listFiles) {
// 把文件夹中所有的文件按日期分类
String name = file2.getName();
if (name.contains("lat")) {
String substring = name.substring(3, name.length() - 4);
/**
* StringBuffer s = new StringBuffer( substring);
* //文件名里面包含有小时s.insert(10, ": ");
*/
latHashMap.put(substring, file2);
} else if (name.contains("t2")) {
String substring = name.substring(2, name.length() - 4);
t2HashMap.put(substring, file2);
} else if (name.contains("lon")) {
String substring = name.substring(3, name.length() - 4);
lonHashMap.put(substring, file2);
}
}
// 操作文件,把同日期的不同文件内容填入到对应的数据库表的字段中
Set<Entry<String, File>> latEntrySet = latHashMap.entrySet();
System.out.println("开始存入数据库");
String dataKey = null;
for (Entry<String, File> entry : latEntrySet) {
dataKey = entry.getKey();
File latFile = entry.getValue();
File t2File = t2HashMap.get(dataKey);
File lonFile = lonHashMap.get(dataKey);
List<String> Xlist = ReadFile.getData(latFile.getPath());
List<String> Ylist = ReadFile.getData(lonFile.getPath());
List<String> WDlist = ReadFile.getData(t2File.getPath());
for (int i = 0; i < (Xlist.size()); i++) {
m++;
ps = conn
.prepareStatement("insert into Test(id,sb,x,y,wd) values"
+ "(Test_ID.nextval,?,?,?,?)");
ps.setString(1, dataKey);
ps.setObject(2, Xlist.get(i));
ps.setObject(3, Ylist.get(i));
ps.setObject(4, WDlist.get(i));
ps.addBatch();
ps.executeBatch();
if (i % 500 == 0 || i == Xlist.size() - 1) {
conn.commit();
ps.clearBatch();
}
}
ps.close();
}
double end = System.currentTimeMillis();
System.out.println("导入日常预测数据表" + m + "条记录用时" + (end - begin)
+ "毫秒,平均存入每条记录用时" + ((end - begin) / m) + "毫秒");
}
} catch (Exception e) {
conn.rollback();
e.printStackTrace();
} finally {
conn.close();
}
}
}
// 读取文件并获得文件中数据(我这里是netCDF格式数据集文件)
public static List<String> getData(String readPath) throws IOException {
File file = new File(readPath);
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);
}
}
}
}
br.close();
return list;
}
至于定时读取,用Quartz很简单的 0_0