读取excle表格内容填充到数据库表
public void spUp(){
paraMap=getParameter();
List<Map<String, Object>> spexclelist=new ArrayList<Map<String, Object>>();
try {
POIFSFileSystem pfs = new POIFSFileSystem(new FileInputStream(getSpuploadFile()));
//如果是xls,使用HSSFWorkbook;如果是xlsx,使用XSSFWorkbook
HSSFWorkbook hwb = new HSSFWorkbook(pfs);
HSSFSheet sheet0 = hwb.getSheetAt(0);
int rowLen = sheet0.getPhysicalNumberOfRows();
for (int rownum = 2; rownum < rowLen; rownum++) {
Map<String, Object> map = new HashMap<String, Object>();
HSSFRow row = sheet0.getRow(rownum);
String SPID = (row.getCell(0)==null)?"":row.getCell(0).toString();
String SPNAME = (row.getCell(1)==null)?"":row.getCell(1).toString();
String SPPRICE = (row.getCell(2)==null)?"":row.getCell(2).toString();
String SPLX = (row.getCell(3)==null)?"":row.getCell(3).toString();
map.put("spid", SPID.trim());
map.put("spname", SPNAME.trim());
map.put("spprice", Integer.valueOf(SPPRICE.trim()) );
map.put("splx", SPLX);
spexclelist.add(map);
}
spscService.insertsp(spexclelist);
br.setSuccess(true);
br.setMessage("数据导入成功");
}catch(Exception e){
br.setSuccess(false);
br.setMessage("导入失败!"+ e.getMessage());
e.printStackTrace();
}
outJson(br);
}
paraMap=getParameter();
List<Map<String, Object>> spexclelist=new ArrayList<Map<String, Object>>();
try {
POIFSFileSystem pfs = new POIFSFileSystem(new FileInputStream(getSpuploadFile()));
//如果是xls,使用HSSFWorkbook;如果是xlsx,使用XSSFWorkbook
HSSFWorkbook hwb = new HSSFWorkbook(pfs);
HSSFSheet sheet0 = hwb.getSheetAt(0);
int rowLen = sheet0.getPhysicalNumberOfRows();
for (int rownum = 2; rownum < rowLen; rownum++) {
Map<String, Object> map = new HashMap<String, Object>();
HSSFRow row = sheet0.getRow(rownum);
String SPID = (row.getCell(0)==null)?"":row.getCell(0).toString();
String SPNAME = (row.getCell(1)==null)?"":row.getCell(1).toString();
String SPPRICE = (row.getCell(2)==null)?"":row.getCell(2).toString();
String SPLX = (row.getCell(3)==null)?"":row.getCell(3).toString();
map.put("spid", SPID.trim());
map.put("spname", SPNAME.trim());
map.put("spprice", Integer.valueOf(SPPRICE.trim()) );
map.put("splx", SPLX);
spexclelist.add(map);
}
spscService.insertsp(spexclelist);
br.setSuccess(true);
br.setMessage("数据导入成功");
}catch(Exception e){
br.setSuccess(false);
br.setMessage("导入失败!"+ e.getMessage());
e.printStackTrace();
}
outJson(br);
}