62,621
社区成员
发帖
与我相关
我的任务
分享
public static void main(String[] args) {
File file[] = new File("D:/jhxx").listFiles();
Calendar calendar = Calendar.getInstance();
SimpleDateFormat smp = new SimpleDateFormat("yyyyMMdd");
Date d = calendar.getTime();
String day = smp.format(d);
for (int i = 0; i < file.length; i++) {
if ((file[i].getName().substring(0, 4).equals("jhxx"))
&& (file[i].getName().substring(16, 24).equals(day))) {
try {
Statement state = Util.getConnection().createStatement();
Workbook workbook = null;
try {
workbook = Workbook.getWorkbook(new File(file[i]
.getPath()));
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
String sql = null;
Sheet sheet = workbook.getSheet(0);
int rows = sheet.getRows();
for (int j = 1; j < rows; j++) {
String name = sheet.getCell(0, j).getContents();
String num = sheet.getCell(1, j).getContents();
String pay = sheet.getCell(2, j).getContents();
sql = "insert into jhxx values('" + name + "','" + num
+ "','" + pay + "')";
state.executeUpdate(sql);
}
} catch (SQLException e) {
}
}
}
}
http://www.blogjava.net/javapro/archive/2009/03/24/JavaAppSetup.html