excel导入到数据库中的java代码

1.
String filename = "";//request.getParameter("upfile");

DiskFileUpload fu = new DiskFileUpload();
// 设置最大文件尺寸
fu.setSizeMax(1000000);
// 设置缓冲区大小，这里是4kb
fu.setSizeThreshold(4096);
fu.setRepositoryPath(request.getRealPath("/"));

Sqlca sqlca = null;
try {
//保存文件
List fileItems = fu.parseRequest(request);
System.out.println("fileItems.size:"+fileItems.size());
Iterator itr = fileItems.iterator();
while (itr.hasNext()) {
FileItem fi = (FileItem) itr.next();
filename = fi.getName();
filename = filename.substring(filename.lastIndexOf("\\"));
File fNew = new File(request.getRealPath("\\upload"), filename);
fi.write(fNew);
System.out.println("filename:"+filename);
}

sqlca = new Sqlca(new ConnectionEx());
sqlca.setAutoCommit(false);
filename = request.getRealPath("\\upload") + "\\" + filename;

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(

filename));
HSSFWorkbook wb = new HSSFWorkbook(fs);
HSSFSheet sheet = wb.getSheetAt(0);

int sheetfirstrow = sheet.getFirstRowNum();
int sheetlastrow = sheet.getLastRowNum();

int spaceBeginRowNum = 14;
int spaceEndRowNum = 16;

//删除本月数据
deleteStatMonthData(sqlca, sheet, sheetfirstrow);

//导入数据
String result1 = importFromExlToDb1(request, response, sqlca,
sheet, sheetfirstrow, spaceBeginRowNum);
String result2 = importFromExlToDb2(request, response, sqlca,
sheet, spaceEndRowNum, sheetlastrow - 1);

if (result1.equals("TRUE") && result2.equals("TRUE")) {
result = "TRUE";
sqlca.commit();
System.out.println("数据导入成功！");
} else {
result = "FALSE";
sqlca.rollback();
}
} catch (Exception e) {
e.printStackTrace();
result = "FALSE";