主页 / 网络编程 /

Jsp+Servlet实现文件上传下载 删除上传文件（三）

网络编程 2021-07-05 11:23www.168986.cn编程入门
这篇文章主要为大家详细介绍了Jsp+Servlet实现文件上传下载功能的第三部分删除上传文件，具有一定的参考价值，感兴趣的小伙伴们可以参考一下

接着上一篇讲

本章来实现一下删除已上传文件，优化了一下第一章中的代码。

废话少说，上代码得意

1.调整列表页面list.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %> 
<%@ taglib prefix="c" uri="http://java.sun./jsp/jstl/core" %> 
<html> 
<head> 
 <title>上传文件列表</title> 
</head> 
<body> 
 
<h3>文件列表</h3> 
<table class="alist_tab" border="1" bordercolor="#000000" cellspacing="0" cellpadding="2" style="border-collapse:collapse;"> 
 <tr> 
  <th>文件名</th> 
  <th>文件大小（KB）</th> 
  <th>操作</th> 
 </tr> 
 <c:if test="${not empty aessoryList}"> 
  <c:forEach items="${aessoryList}" var="a"> 
   <tr> 
    <td>${a.fileName}</td> 
    <td>${a.fileSize}</td> 
    <td><a href="<%=request.getContextPath()%>/removeUploadedFile?id=${a.id}" rel="external nofollow" >删除</a></td> 
   </tr> 
  </c:forEach> 
 </c:if> 
</table> 
</body> 
</html>

2.新增FileUtils工具类

package util; 
 
import java.io.File; 
 
/ 
  文件操作工具类 
  
  @author xusucheng 
  @create 2017-12-30 
 / 
public class FileUtils { 
 public static boolean delete(String path){ 
  File file = new File(path); 
  if(!file.isFile()){ 
   System.out.println("删除失败，文件"+path+"不存在！"); 
   return false; 
  } 
 
  file.delete(); 
 
  return true; 
 } 
}

3.调整附件实体DAO，新增load方法

package dao.upload; 
 
import entity.upload.EntityAessory; 
import util.DBUtil; 
 
import java.math.BigDecimal; 
import java.sql.Connection; 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.List; 
 
/ 
  附件上传DAO 
  
  @author xusucheng 
  @create 2017-12-29 
 / 
public class AessoryDao { 
 public static void add(EntityAessory entity) { 
  Connection conn = DBUtil.getConnection(); 
  String sql = "insert into tbl_aessory(file_name,file_size,file_ext_name,file_path) values(?,?,?,?)"; 
  try { 
   PreparedStatement ps = conn.prepareStatement(sql); 
   ps.setString(1, entity.getFileName()); 
   ps.setDouble(2, entity.getFileSize()); 
   ps.setString(3, entity.getFile_ext_name()); 
   ps.setString(4, entity.getFilePath()); 
   ps.execute(); 
   //conn.mit(); 
 
   DBUtil.close(null, ps, conn); 
  } catch (SQLException e) { 
   e.printStackTrace(); 
  } 
 } 
 
 public static List<EntityAessory> list() { 
  Connection conn = DBUtil.getConnection(); 
  String sql = "select id,file_name,file_size,file_ext_name,file_path from tbl_aessory"; 
  List<EntityAessory> aessoryList = new ArrayList<>(); 
  try { 
   PreparedStatement ps = conn.prepareStatement(sql); 
   ResultSet rs = ps.executeQuery(); 
 
   while (rs.next()) { 
    EntityAessory entity = new EntityAessory(); 
    entity.setId(rs.getInt("id")); 
    entity.setFileName(rs.getString("file_name")); 
    entity.setFileSize(new BigDecimal(rs.getDouble("file_size") / 1024).setScale(2, BigDecimal.ROUND_HALF_UP).doubleValue()); 
    entity.setFile_ext_name(rs.getString("file_ext_name")); 
    entity.setFilePath(rs.getString("file_path")); 
    aessoryList.add(entity); 
   } 
 
   DBUtil.close(rs, ps, conn); 
  } catch (SQLException e) { 
   e.printStackTrace(); 
  } 
 
  return aessoryList; 
 
 } 
 
 public static EntityAessory load(int id){ 
  Connection conn = DBUtil.getConnection(); 
  PreparedStatement ps=null; 
  ResultSet rs=null; 
  EntityAessory entity = new EntityAessory(); 
  String sql = "select id, file_name,file_size,file_ext_name,file_path from tbl_aessory where id=?"; 
  try { 
   ps = conn.prepareStatement(sql); 
   ps.setInt(1,id); 
   rs = ps.executeQuery(); 
   while (rs.next()){ 
    entity.setId(rs.getInt("id")); 
    entity.setFileName(rs.getString("file_name")); 
    entity.setFileSize(rs.getDouble("file_size")); 
    entity.setFile_ext_name(rs.getString("file_ext_name")); 
    entity.setFilePath(rs.getString("file_path")); 
   } 
  } catch (SQLException e) { 
   e.printStackTrace(); 
  }finally { 
   DBUtil.close(rs,ps,conn); 
  } 
 
  return entity; 
 } 
 
 public static void remove(int id) { 
  Connection conn = DBUtil.getConnection(); 
  String sql = "delete from tbl_aessory where id=?"; 
  try { 
   PreparedStatement ps = conn.prepareStatement(sql); 
   ps.setInt(1,id); 
   ps.execute(); 
   //conn.mit(); mysql默认开启了automit 
 
   DBUtil.close(null,ps,conn); 
  } catch (SQLException e) { 
   e.printStackTrace(); 
  } 
 } 
}

4.新增删除文件处理器，removeUploadedFileServlet

package servlet.upload; 
 
import dao.upload.AessoryDao; 
import entity.upload.EntityAessory; 
import util.FileUtils; 
 
import javax.servlet.ServletException; 
import javax.servlet.annotation.WebServlet; 
import javax.servlet.http.HttpServlet; 
import javax.servlet.http.HttpServletRequest; 
import javax.servlet.http.HttpServletResponse; 
import java.io.IOException; 
 
/ 
  删除已上传文件 
  
  @author xusucheng 
  @create 2017-12-30 
 / 
@WebServlet("/removeUploadedFile") 
public class removeUploadedFileServlet extends HttpServlet { 
 @Override 
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
  //String filePath = request.getParameter("filePath"); 
  int fileId = Integer.valueOf(request.getParameter("id")); 
  EntityAessory entity = AessoryDao.load(fileId); 
  //删除文件 
  FileUtils.delete(entity.getFilePath()); 
  //删除数据库记录 
  AessoryDao.remove(fileId); 
 
  //跳回到文件列表页 
  //request.getRequestDispatcher("listUploadedFiles").forward(request, response); 
  response.sendRedirect("listUploadedFiles"); 
 } 
 
 @Override 
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 
  doPost(request, response); 
 } 
 
 
}

5.测试效果截图

删除前

删除后

6.下集预告

实现文件下载功能

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持狼蚁SEO。

上一篇：JSP实现客户信息管理系统 下一篇：Jsp+Servlet实现文件上传下载 文件列表展示（二）

编程语言

Copyright © 2016-2025 www.168986.cn 狼蚁网络 版权所有 Power by