删除导入失败文件(Excel)

来源：互联网发布：七星彩统计软件编辑：程序博客网时间：2024/06/05 17:02

删除导入失败文件（EXCEL）

环境：springMVC+Mybatis

//删除导入失败文件

@RequestMapping("/deleteExl")public String deleteExl(HttpServletRequest request){try {String id1=request.getParameter("id");int id=Integer.parseInt(id1);//根据ID去查询文件的名称和路径Map<String, Object> exlMap=batchService.selectExlId(id);//根据ID去删除数据库中的数据int count=batchService.deleteExl(id);//删除文件String time=(String)exlMap.get("exl_record_name");time=time.substring(0,time.indexOf("."));String srcPath =request.getSession().getServletContext().getRealPath("/../../../apache-tomcat-7.0.54/webapps/HSOAFILE/record/")+"/"+time+"/";delFolder(srcPath);} catch (Exception e) {e.printStackTrace();ByteArrayOutputStream baos = new ByteArrayOutputStream();              e.printStackTrace(new PrintStream(baos));            log.info("删除导入失败文件异常");log.info(baos.toString());}return "redirect:findExl.do";}

//删除文件夹
//param folderPath 文件夹完整绝对路径

public static void delFolder(String folderPath) {     try {        delAllFile(folderPath); //删除完里面所有内容        String filePath = folderPath;        filePath = filePath.toString();        java.io.File myFilePath = new java.io.File(filePath);        myFilePath.delete(); //删除空文件夹     } catch (Exception e) {       e.printStackTrace();      }}

//删除指定文件夹下所有文件
//param path 文件夹完整绝对路径

 public static boolean delAllFile(String path) {       boolean flag = false;       File file = new File(path);       if (!file.exists()) {         return flag;       }       if (!file.isDirectory()) {         return flag;       }       String[] tempList = file.list();       File temp = null;       for (int i = 0; i < tempList.length; i++) {          if (path.endsWith(File.separator)) {             temp = new File(path + tempList[i]);          } else {              temp = new File(path + File.separator + tempList[i]);          }          if (temp.isFile()) {             temp.delete();          }          if (temp.isDirectory()) {             delAllFile(path + "/" + tempList[i]);//先删除文件夹里面的文件             delFolder(path + "/" + tempList[i]);//再删除空文件夹             flag = true;          }       }       return flag;     }

0 0