处理重复导入的方法之一
这是一个很简单的处理重复导入的方法，但是速度比较慢，我想除了这个方法之外应该也可以用sql语句来对他进行处理吧！
我这里是对导入数据库的每一条记录和数据库里面相关的所有记录进行比较，只要存在相同的记录就不导入，如果没有相同的就插入新的记录！
以下是我的代码：
//导入数据库 public String intoDB() throws IOException{ HttpServletRequest request = ServletActionContext.getRequest(); HttpSession session = request.getSession(); String path = ServletActionContext.getServletContext().getRealPath( "/general"); String fileName = null; while(fileName == null){ fileName = (String) session.getAttribute("fileName"); } File f = new File(path + "/" + fileName); try { //用jxl解析excel2003 if(this.getFileFileName()!=null && this.getFileFileName().indexOf(".xlsx")==-1){ Workbook book = Workbook.getWorkbook(f);// Sheet sheet = book.getSheet(0); // 获得第一个工作表对象 for (int i = 1; i < sheet.getRows(); i++) { BoatTable boat = new BoatTable(); boat.setBenglishname(sheet.getCell(0, i).getContents()); boat.setBchinesename(sheet.getCell(1, i).getContents()); boat.setBregist(sheet.getCell(2, i).getContents()); boat.setBboat(sheet.getCell(3, i).getContents()); boat.setBrecongnize(sheet.getCell(4, i).getContents()); boat.setBmaterial(sheet.getCell(5, i).getContents()); boat.setBlength(Double.parseDouble(sheet.getCell(6, i).getContents())); boat.setBwidth(Double.parseDouble(sheet.getCell(7, i).getContents())); boat.setBdeep(Double.parseDouble(sheet.getCell(8, i).getContents())); boat.setBsum(Integer.parseInt(sheet.getCell(9, i).getContents())); boat.setBsulttle(Integer.parseInt(sheet.getCell(10, i).getContents())); boat.setBgross(Integer.parseInt(sheet.getCell(11, i).getContents())); boat.setBpower(Integer.parseInt(sheet.getCell(12, i).getContents())); boat.setBlog(sheet.getCell(13, i).getContents()); boat.setBremark(sheet.getCell(14, i).getContents()); boat.setBcheck(sheet.getCell(15, i).getContents()); boat.setBwater(sheet.getCell(16, i).getContents()); boat.setBoperat(sheet.getCell(17, i).getContents()); boat.setBrange(sheet.getCell(18, i).getContents()); boat.setBkind(sheet.getCell(19, i).getContents()); boat.setBowner(sheet.getCell(20, i).getContents()); //添加到数据库,处理重复提交 List<BoatTable> bList=boatService.propertyBoat("bchinesename", boat.getBchinesename()); boolean flag = false; for (BoatTable blist : bList) { if(!blist.getBboat().equals(boat.getBboat()) || !blist.getBcheck().equals(boat.getBcheck()) || !blist.getBchinesename().equals(boat.getBchinesename()) || !blist.getBdeep().equals(boat.getBdeep()) || !blist.getBenglishname().equals(boat.getBenglishname()) || !blist.getBgross().equals(boat.getBgross()) || !blist.getBkind().equals(boat.getBkind()) || !blist.getBlength().equals(boat.getBlength()) || !blist.getBlog().equals(boat.getBlog()) || !blist.getBmaterial().equals(boat.getBmaterial()) || !blist.getBoperat().equals(boat.getBoperat()) || !blist.getBowner().equals(boat.getBowner()) || !blist.getBpower().equals(boat.getBpower()) || !blist.getBrange().equals(boat.getBrange()) || !blist.getBrecongnize().equals(boat.getBrecongnize()) || !blist.getBregist().equals(boat.getBregist()) || !blist.getBremark().equals(boat.getBremark()) || !blist.getBsulttle().equals(boat.getBsulttle()) || !blist.getBsum().equals(boat.getBsum()) || !blist.getBwater().equals(boat.getBwater()) || !blist.getBwidth().equals(boat.getBwidth())){ flag = false; }else{ flag = true; break; } } if(!flag){ boatService.addOneBoat(boat); } } }else{ //用poi解析excel2007 // 构建1个工作簿对象 XSSFWorkbook xwb = null; try { xwb = new XSSFWorkbook(new FileInputStream(f.getPath())); } catch (Exception e) { e.printStackTrace(); } //得到第一张工作表 XSSFSheet xSheet = xwb.getSheetAt(0); //循环工作表的每一行 for (int rowNum = 1; rowNum <= xSheet.getLastRowNum(); rowNum++) { XSSFRow xRow = xSheet.getRow(rowNum); if (xRow == null) { continue; } BoatTable boat = new BoatTable(); boat.setBenglishname(xRow.getCell(0).getStringCellValue()); boat.setBchinesename(xRow.getCell(1).getStringCellValue()); boat.setBregist(xRow.getCell(2).getStringCellValue()); if(xRow.getCell(3).getCellType() == XSSFCell.CELL_TYPE_NUMERIC){ boat.setBboat(Double.valueOf(xRow.getCell(3).getNumericCellValue()).toString()); }else{ boat.setBboat(xRow.getCell(3).getStringCellValue()); } boat.setBrecongnize(xRow.getCell(4).getStringCellValue()); boat.setBmaterial(xRow.getCell(5).getStringCellValue()); boat.setBlength(xRow.getCell(6).getNumericCellValue()); boat.setBwidth(xRow.getCell(7).getNumericCellValue()); boat.setBdeep(xRow.getCell(8).getNumericCellValue()); boat.setBsum((int)xRow.getCell(9).getNumericCellValue()); boat.setBsulttle((int)xRow.getCell(10).getNumericCellValue()); boat.setBgross((int)xRow.getCell(11).getNumericCellValue()); boat.setBpower((int)xRow.getCell(12).getNumericCellValue()); boat.setBlog(xRow.getCell(13).getStringCellValue()); boat.setBremark(xRow.getCell(14).getStringCellValue()); //如果单元格里面为数字，用String取得话会报异常，故有可能为数字的都要判断一下 if(xRow.getCell(15).getCellType() == XSSFCell.CELL_TYPE_NUMERIC){ boat.setBcheck(Double.valueOf(xRow.getCell(15).getNumericCellValue()).toString()); }else{ boat.setBcheck(xRow.getCell(15).getStringCellValue()); } if(xRow.getCell(16).getCellType() == XSSFCell.CELL_TYPE_NUMERIC){ boat.setBwater(Double.valueOf(xRow.getCell(16).getNumericCellValue()).toString()); }else{ boat.setBwater(xRow.getCell(16).getStringCellValue()); } if(xRow.getCell(17).getCellType() == XSSFCell.CELL_TYPE_NUMERIC){ boat.setBoperat(Double.valueOf(xRow.getCell(17).getNumericCellValue()).toString()); }else{ boat.setBoperat(xRow.getCell(17).getStringCellValue()); } boat.setBrange(xRow.getCell(18).getStringCellValue()); boat.setBkind(xRow.getCell(19).getStringCellValue()); boat.setBowner(xRow.getCell(20).getStringCellValue()); //添加到数据库 List<BoatTable> bList=boatService.propertyBoat("bchinesename", boat.getBchinesename()); boolean flag = false; for (BoatTable blist : bList) { if(!blist.getBboat().equals(boat.getBboat()) || !blist.getBcheck().equals(boat.getBcheck()) || !blist.getBchinesename().equals(boat.getBchinesename()) || !blist.getBdeep().equals(boat.getBdeep()) || !blist.getBenglishname().equals(boat.getBenglishname()) || !blist.getBgross().equals(boat.getBgross()) || !blist.getBkind().equals(boat.getBkind()) || !blist.getBlength().equals(boat.getBlength()) || !blist.getBlog().equals(boat.getBlog()) || !blist.getBmaterial().equals(boat.getBmaterial()) || !blist.getBoperat().equals(boat.getBoperat()) || !blist.getBowner().equals(boat.getBowner()) || !blist.getBpower().equals(boat.getBpower()) || !blist.getBrange().equals(boat.getBrange()) || !blist.getBrecongnize().equals(boat.getBrecongnize()) || !blist.getBregist().equals(boat.getBregist()) || !blist.getBremark().equals(boat.getBremark()) || !blist.getBsulttle().equals(boat.getBsulttle()) || !blist.getBsum().equals(boat.getBsum()) || !blist.getBwater().equals(boat.getBwater()) || !blist.getBwidth().equals(boat.getBwidth())){ flag = false; }else{ flag = true; break; } } if(!flag){ boatService.addOneBoat(boat); } } } } catch (BiffException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } f.delete(); session.removeAttribute("fileName"); return null; }
