Jsp+Servlet实现文件上传下载 文件列表展示（二）(1/3)

接着上一篇讲：
Jsp+Servlet实现文件上传下载（一）--文件上传

本章来实现一下上传文件列表展示，同时优化了一下第一章中的代码。

废话少说，上代码

mysql创建附件表

DROP TABLE tbl_accessory; 

CREATE TABLE tbl_accessory 
( 
 id INT AUTO_INCREMENT PRIMARY KEY, 
 file_name VARCHAR(500), 
 file_size DOUBLE(10,2), 
 file_ext_name VARCHAR(100), 
 file_path VARCHAR(2000) 
) 
; 

SELECT * FROM tbl_accessory; 

DELETE FROM tbl_accessory; 

创建附件实体类

package entity.upload; 

/** 
 * 附件实体类 
 * 
 * @author xusucheng 
 * @create 2017-12-29 
 **/ 
public class EntityAccessory { 
 private int id; 
 private String fileName; 
 private double fileSize; 
 private String file_ext_name; 
 private String filePath; 

 public int getId() { 
  return id; 
 } 

 public void setId(int id) { 
  this.id = id; 
 } 

 public String getFileName() { 
  return fileName; 
 } 

 public void setFileName(String fileName) { 
  this.fileName = fileName; 
 } 

 public double getFileSize() { 
  return fileSize; 
 } 

 public void setFileSize(double fileSize) { 
  this.fileSize = fileSize; 
 } 

 public String getFile_ext_name() { 
  return file_ext_name; 
 } 

 public void setFile_ext_name(String file_ext_name) { 
  this.file_ext_name = file_ext_name; 
 } 

 public String getFilePath() { 
  return filePath; 
 } 

 public void setFilePath(String filePath) { 
  this.filePath = filePath; 
 } 
} 

创建DBUtil工具类