基于SSM完成EXCEL表格数据导入到MySQL数据库,采用poi实现
jar
poi-3.16.jar
poi-examples-3.16.jar
poi-ooxml-3.16.jar
poi-ooxml-schemas-3.16.jar
commons-fileupload-1.3.3.jar
jsp
<form method="post" enctype="multipart/form-data"action="importexcel">
文件: <input type="file" name="file"/>
<input type="submit" value="submit">
</form>
controller
//导入excel
@RequestMapping("importexcel")
public String admin_importmembers(HttpServletResponse response,HttpServletRequest request) throws Exception {
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
List<List<Object>> listob = null;
MultipartFile file = multipartRequest.getFile("file");
// employeeMapper.impExcel(file);
System.out.println((POIservice==null)+"--------");
POIservice.impExcel(file);
System.out.println("............");
return "redirect:/emps";
}
public String admin_importmembers(HttpServletResponse response,HttpServletRequest request) throws Exception {
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
List<List<Object>> listob = null;
MultipartFile file = multipartRequest.getFile("file");
// employeeMapper.impExcel(file);
System.out.println((POIservice==null)+"--------");
POIservice.impExcel(file);
System.out.println("............");
return "redirect:/emps";
}
service