本文主要是介绍excle表格内容填充到数据库表,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
读取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);
}
这篇关于excle表格内容填充到数据库表的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!