龍子 发表于 2017-12-25 10:34:49

Apache POI 一键上传(导入excel文件到数据库)

  @Action("areaAction_uploadFile")
  public String areaAction_uploadFile() throws Exception {
  List<Area> list = new ArrayList<>();
  //使用POI技术解析excel文件
  HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(xlsFile));
  HSSFSheet sheet = workbook.getSheet("Sheet1");
  for (Row row : sheet) {
  if(row.getRowNum()==0){
  continue;
  }

  String>  String province = row.getCell(1).getStringCellValue();
  String city = row.getCell(2).getStringCellValue();
  String district = row.getCell(3).getStringCellValue();
  String postcode = row.getCell(4).getStringCellValue();
  Area area = new Area(id, province, city, district, postcode, null, null);
  province = province.substring(0, province.length()-1);
  city = city.substring(0, city.length()-1);
  district = district.substring(0, district.length()-1);
  String info = province+city+district;
  System.out.println(info);
  
//            简码: HBSJZQX
  String[] headByString = PinYin4jUtils.getHeadByString(info);
  String shortcode = StringUtils.join(headByString, "");
  area.setShortcode(shortcode);
  
//            城市编码:shijiazhuang
  String citycode = PinYin4jUtils.hanziToPinyin(city, "");
  area.setCitycode(citycode);
  list.add(area);
  }
  areaService.save(list);
  return NONE;
  }
页: [1]
查看完整版本: Apache POI 一键上传(导入excel文件到数据库)