oracle数据库读取excel,读取Excel数据、批量导入到Oracle数据库

/**

* @Description: 得到Excel文档，把文档中的数据批量导入到数据库中

* 1、找到上传的数据，2、把数据放到List集合中，3、把List集合中的数据更新到数据库

* @return void

* @throws

*/

public String cmdImpQxsj() {

String sysGuid = getWorkDTO().getAsString("sysGuid");

String webPath = WebConfig.getInstance().getContext_path();

String filePath = this.getFilePath(sysGuid);

String longPath = webPath+filePath;

HSSFWorkbook workbook = POIExcelUtil.getExistHSSFWorkbook(new File(longPath));

List> list = new ArrayList>();

if (workbook != null) {

HSSFSheet sheet = workbook.getSheetAt(0);

if (sheet != null) {

int rownum = sheet.getLastRowNum();

int columnnum = sheet.getRow(0).getLastCellNum();

for(int i=3;i

List row = new ArrayList();

Object value = "";

for (int j = 1; j < columnnum-1; j++) {

Cell cell = sheet.getRow(i).getCell(j);

if (cell == null) {

row.add("");

} else if (j==2 || j==3 || j == 5

|| j==6 || j==7 || j == 9 || j==10

|| j==11 || j == 12 || j==13 || j == 15

|| j==16 || j==18 || j == 19 || j==20) {

if(cell.getStringCellValue() != null || !"".equals(cell.getStringCellValue())){

value = cell.getStringCellValue();

row.add(value);

}

}else if(j == 1){

if(cell.getCellT