基于SSM完成EXCEL表格数据导入到MySQL数据库

基于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";
  }

service