1.表格展示:
2.读取表格数据:
private File regionFile ;
public File getRegionFile() {
return regionFile;
}
public void setRegionFile(File regionFile) {
this.regionFile = regionFile;
}@Autowired
private IRegionService regionService ;
/**
* 导入数据表格
* @return
* @throws Exception
*/
public String importXls() throws Exception {
List<Region> regionList = new ArrayList<>() ;//包装一个Excel文件对象
HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(regionFile));
//读取文件中第一个Sheet标签页
HSSFSheet hssfSheet = workbook.getSheetAt(0);
//遍历标签页中所有的行
for (Row row : hssfSheet) {
int rowNum = row.getRowNum();
if(rowNum == 0) {
continue ;
}
String id = row.getCell(0).getStringCellValue();
String province = row.getCell(1).getStringCellValue();
String city = row.getCell(2).getStringCellValue();
String district = row.getCell(3).getStringCellValue();
String postcode = row.getCell(4).getStringCellValue();
//包装一个区域对对象
Region region = new Region(id, province, city, district, postcode, null, null, null);
//设置shortcode citycode
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 ;
//获取HBSJZQX
String[] headByString = PinYin4jUtils.getHeadByString(info);
String shortcode = StringUtils.join(headByString);
//获取城市编码---->>shijiazhuang
String citycode = PinYin4jUtils.hanziToPinyin(city, "");
region.setShortcode(shortcode);
region.setCitycode(citycode);
regionList.add(region);
}
regionService.saveBatch(regionList);
return NONE;
}
3.保存:
/**
* 批量保存区域数据(从xsl中导入)
*/
@Override
public void saveBatch(List<Region> regionList) {
for (Region region : regionList) {
regionDao.saveOrUpdate(region);
}}
推荐一篇:https://blog.csdn.net/shenju2011/article/details/79119224