黄色电影一区二区,韩国少妇自慰A片免费看,精品人妻少妇一级毛片免费蜜桃AV按摩师 ,超碰 香蕉

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; 
 } 
} 

package util; 
 
import java.sql.*; 
import java.io.inputstream; 
import java.util.properties; 
 
/** 
 * 數(shù)據(jù)庫工具類 
 * 
 * @author xusucheng 
 * @create 2017-11-18 
 **/ 
public class dbutil { 
 //定義鏈接所需要的變量 
 private static connection con = null; 
 private static preparedstatement ps = null; 
 private static resultset rs = null; 
 
 //定義鏈接數(shù)據(jù)庫所需要的參數(shù) 
 private static string url = ""; 
 private static string username = ""; 
 private static string driver=""; 
 private static string password=""; 
 
 //定義讀取配置文件所需要的變量 
 private static properties pp = null; 
 private static inputstream fis = null; 
 
 /** 
  * 加載驅(qū)動 
  */ 
 static { 
  try { 
   //從dbinfo.properties配置文件中讀取配置信息 
   pp = new properties(); 
   fis = dbutil.class.getclassloader().getresourceasstream("db.properties"); 
 
   pp.load(fis); 
   url = pp.getproperty("url"); 
   username = pp.getproperty("username"); 
   driver=pp.getproperty("driver"); 
   password=pp.getproperty("password"); 
 
   //加載驅(qū)動 
   class.forname(driver); 
 
  } catch (exception e) { 
   system.out.println("驅(qū)動加載失??！"); 
   e.printstacktrace(); 
  } finally { 
   try { 
    fis.close(); 
   } catch (exception e) { 
    e.printstacktrace(); 
   } 
 
   fis = null; //垃圾回收自動處理 
  } 
 
 } 
 
 /** 
  * 得到connection鏈接 
  * @return connection 
  */ 
 public static connection getconnection() { 
 
  try { 
   //建立連接 
   con = drivermanager.getconnection(url, username, password); 
 
  } catch (exception e) { 
   system.out.println("數(shù)據(jù)庫鏈接失敗！"); 
   e.printstacktrace(); 
  } 
 
  return con; 
 } 
 
 /*public dbutil(string sql){ 
  try { 
   ps = getconnection().preparestatement(sql);//準(zhǔn)備執(zhí)行語句 
  } catch (exception e) { 
   e.printstacktrace(); 
  } 
 } 
 
 public void close() { 
  try { 
   con.close(); 
   ps.close(); 
  } catch (sqlexception e) { 
   e.printstacktrace(); 
  } 
 }*/ 
 
 /** 
  * 統(tǒng)一的資源關(guān)閉函數(shù) 
  * @param rs 
  * @param ps 
  * @param con 
  */ 
 public static void close(resultset rs,statement ps, connection con){ 
 
  if(rs != null) { 
   try { 
    rs.close(); 
   } catch (exception e) { 
    e.printstacktrace(); 
   } 
  } 
  if(ps != null) { 
   try { 
    ps.close(); 
   } catch (exception e) { 
    e.printstacktrace(); 
   } 
  } 
  if(con != null) { 
   try { 
    con.close(); 
   } catch (exception e) { 
    e.printstacktrace(); 
   } 
  } 
 } 
 
} 

package dao.upload; 
 
import entity.upload.entityaccessory; 
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 accessorydao { 
 public static void add(entityaccessory entity) { 
  connection conn = dbutil.getconnection(); 
  string sql = "insert into tbl_accessory(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.commit(); 
 
   dbutil.close(null, ps, conn); 
  } catch (sqlexception e) { 
   e.printstacktrace(); 
  } 
 } 
 
 public static list<entityaccessory> list() { 
  connection conn = dbutil.getconnection(); 
  string sql = "select id,file_name,file_size,file_ext_name,file_path from tbl_accessory"; 
  list<entityaccessory> accessorylist = new arraylist<>(); 
  try { 
   preparedstatement ps = conn.preparestatement(sql); 
   resultset rs = ps.executequery(); 
 
   while (rs.next()) { 
    entityaccessory entity = new entityaccessory(); 
    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")); 
    accessorylist.add(entity); 
   } 
 
   dbutil.close(rs, ps, conn); 
  } catch (sqlexception e) { 
   e.printstacktrace(); 
  } 
 
  return accessorylist; 
 
 } 
 
 public static void remove(int id) { 
  connection conn = dbutil.getconnection(); 
  string sql = "delete from tbl_accessory where id=?"; 
  try { 
   preparedstatement ps = conn.preparestatement(sql); 
   ps.setint(1,id); 
   ps.execute(); 
   //conn.commit(); mysql默認(rèn)開啟了autocommit 
 
   dbutil.close(null,ps,conn); 
  } catch (sqlexception e) { 
   e.printstacktrace(); 
  } 
 } 
} 

<html> 
<head> 
 <title>上傳文件列表</title> 
</head> 
<body> 
 
<h3>文件列表</h3> 
<table class="acclist_tab" border="1" bordercolor="#000000" cellspacing="0" cellpadding="2" style="border-collapse:collapse;"> 
 <tr> 
  <th>文件名</th> 
  <th>文件大?。╧b）</th> 
  <th>操作</th> 
 </tr> 
 <c:if test="${not empty accessorylist}"> 
  <c:foreach items="${accessorylist}" var="acc"> 
   <tr> 
    <td>${acc.filename}</td> 
    <td>${acc.filesize}</td> 
    <td><a href="">刪除</a></td> 
   </tr> 
  </c:foreach> 
 </c:if> 
</table> 
</body> 
</html> 

package servlet.upload; 
 
import dao.upload.accessorydao; 
import entity.upload.entityaccessory; 
 
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; 
import java.util.list; 
 
/** 
 * 返回已上傳文件列表 
 * 
 * @author xusucheng 
 * @create 2017-12-29 
 **/ 
 
@webservlet("/listuploadedfiles") 
public class listuploadedfilesservlet extends httpservlet { 
 @override 
 protected void dopost(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { 
  //獲取文件列表 
  list<entityaccessory> accessorylist = accessorydao.list(); 
  request.setattribute("accessorylist", accessorylist); 
 
  request.getrequestdispatcher("pages/upload/list.jsp").forward(request, response); 
 } 
 
 @override 
 protected void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { 
  dopost(request, response); 
 } 
} 

<%@ page contenttype="text/html;charset=utf-8" language="java" %> 
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> 
<html> 
<head> 
 <title>上傳錯誤頁面</title> 
</head> 
<body> 
 
<h3>上傳失敗：</h3> 
<c:if test="${not empty errormessage}"> 
 <%--<input type="text" id="errormessage" value="${errormessage}" style="color:red;" disabled="disabled">--%> 
 <h4 style="color: red;">${errormessage}</h4> 
</c:if> 
 
 
</body> 
</html> 

package servlet.upload; 
 
import dao.upload.accessorydao; 
import entity.upload.entityaccessory; 
import org.apache.commons.fileupload.fileitem; 
import org.apache.commons.fileupload.fileuploadbase; 
import org.apache.commons.fileupload.fileuploadexception; 
import org.apache.commons.fileupload.progresslistener; 
import org.apache.commons.fileupload.disk.diskfileitemfactory; 
import org.apache.commons.fileupload.servlet.servletfileupload; 
 
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.file; 
import java.io.fileoutputstream; 
import java.io.ioexception; 
import java.io.inputstream; 
import java.util.calendar; 
import java.util.iterator; 
import java.util.list; 
import java.util.uuid; 
 
/** 
 * 處理文件上傳 
 * 
 * @author xusucheng 
 * @create 2017-12-27 
 **/ 
@webservlet("/uploadservlet") 
public class uploadservlet extends httpservlet { 
 @override 
 protected void doget(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { 
  //設(shè)置文件上傳基本路徑 
  string savepath = this.getservletcontext().getrealpath("/web-inf/uploadfiles"); 
  //設(shè)置臨時文件路徑 
  string temppath = this.getservletcontext().getrealpath("/web-inf/tempfiles"); 
  file tempfile = new file(temppath); 
  if (!tempfile.exists()) { 
   tempfile.mkdir(); 
  } 
 
  //定義異常消息 
  string errormessage = ""; 
  //創(chuàng)建file items工廠 
  diskfileitemfactory factory = new diskfileitemfactory(); 
  //設(shè)置緩沖區(qū)大小 
  factory.setsizethreshold(1024 * 100); 
  //設(shè)置臨時文件路徑 
  factory.setrepository(tempfile); 
  //創(chuàng)建文件上傳處理器 
  servletfileupload upload = new servletfileupload(factory); 
  //監(jiān)聽文件上傳進(jìn)度 
  progresslistener progresslistener = new progresslistener() { 
   public void update(long pbytesread, long pcontentlength, int pitems) { 
    system.out.println("正在讀取文件： " + pitems); 
    if (pcontentlength == -1) { 
     system.out.println("已讀?。?" + pbytesread + " 剩余0"); 
    } else { 
     system.out.println("文件總大?。? + pcontentlength + " 已讀?。? + pbytesread); 
    } 
   } 
  }; 
  upload.setprogresslistener(progresslistener); 
 
  //解決上傳文件名的中文亂碼 
  upload.setheaderencoding("utf-8"); 
  //判斷提交上來的數(shù)據(jù)是否是上傳表單的數(shù)據(jù) 
  if (!servletfileupload.ismultipartcontent(request)) { 
   //按照傳統(tǒng)方式獲取數(shù)據(jù) 
   return; 
  } 
 
  //設(shè)置上傳單個文件的大小的最大值，目前是設(shè)置為1024*1024字節(jié)，也就是1mb 
  //upload.setfilesizemax(1024 * 1024); 
  //設(shè)置上傳文件總量的最大值，最大值=同時上傳的多個文件的大小的最大值的和，目前設(shè)置為10mb 
  upload.setsizemax(1024 * 1024 * 10); 
 
  try { 
   //使用servletfileupload解析器解析上傳數(shù)據(jù)，解析結(jié)果返回的是一個list<fileitem>集合，每一個fileitem對應(yīng)一個form表單的輸入項 
   list<fileitem> items = upload.parserequest(request); 
   iterator<fileitem> iterator = items.iterator(); 
   while (iterator.hasnext()) { 
    fileitem item = iterator.next(); 
 
    //判斷jsp提交過來的是不是文件 
    if (item.isformfield()) { 
     errormessage = "請?zhí)峤晃募?; 
     break; 
    } else { 
     //文件名 
     string filename = item.getname(); 
     if (filename == null || filename.trim() == "") { 
      system.out.println("文件名為空！"); 
     } 
     //處理不同瀏覽器提交的文件名帶路徑問題 
     filename = filename.substring(filename.lastindexof("\\") + 1); 
     //文件大小 
     long filesize = item.getsize(); 
     //文件擴(kuò)展名 
     string fileextension = filename.substring(filename.lastindexof(".") + 1); 
     //判斷擴(kuò)展名是否合法 
     if (!validextension(fileextension)) { 
      errormessage = "上傳文件非法！"; 
      item.delete(); 
      break; 
     } 
     //獲得文件輸入流 
     inputstream in = item.getinputstream(); 
     //得到保存文件的名稱 
     string savefilename = createfilename(filename); 
     //得到文件保存路徑 
     string realfilepath = createrealfilepath(savepath, savefilename); 
     //創(chuàng)建文件輸出流 
     fileoutputstream out = new fileoutputstream(realfilepath); 
     //創(chuàng)建緩沖區(qū) 
     byte buffer[] = new byte[1024]; 
     int len = 0; 
     while ((len = in.read(buffer)) > 0) { 
      //寫文件 
      out.write(buffer, 0, len); 
     } 
     //關(guān)閉輸入流 
     in.close(); 
     //關(guān)閉輸出流 
     out.close(); 
     //刪除臨時文件 
     item.delete(); 
     <span style="color:#ff0000;">//將上傳文件信息保存到附件表中 
     entityaccessory entity = new entityaccessory(); 
     entity.setfilename(filename); 
     entity.setfilesize(filesize); 
     entity.setfile_ext_name(fileextension); 
     entity.setfilepath(realfilepath); 
     accessorydao.add(entity); 
    } 
 
   } 
 
  } catch (fileuploadbase.filesizelimitexceededexception e) { 
   e.printstacktrace(); 
   errormessage = "單個文件超出最大值?。?！"; 
  } catch (fileuploadbase.sizelimitexceededexception e) { 
   e.printstacktrace(); 
   errormessage = "上傳文件的總的大小超出限制的最大值！?。?; 
  } catch (fileuploadexception e) { 
   e.printstacktrace(); 
   errormessage = "文件上傳失?。。。?; 
  } finally { 
   <span style="color:#ff0000;">if (!"".equals(errormessage)) { 
    request.setattribute("errormessage", errormessage); 
    request.getrequestdispatcher("pages/upload/error.jsp").forward(request, response); 
   } else { 
    response.sendredirect("listuploadedfiles"); 
   } 
 
  } 
 
 } 
 
 @override 
 protected void dopost(httpservletrequest request, httpservletresponse response) throws servletexception, ioexception { 
  doget(request, response); 
 } 
 
 private boolean validextension(string fileextension) { 
  string[] exts = {"jpg", "txt", "doc", "pdf"}; 
  for (int i = 0; i < exts.length; i++) { 
   if (fileextension.equals(exts[i])) { 
    return true; 
   } 
 
  } 
 
  return false; 
 } 
 
 private string createfilename(string filename) { 
  return uuid.randomuuid().tostring() + "_" + filename; 
 } 
 
 /** 
  * 根據(jù)基本路徑和文件名稱生成真實文件路徑，基本路徑\\年\\月\\filename 
  * 
  * @param basepath 
  * @param filename 
  * @return 
  */ 
 private string createrealfilepath(string basepath, string filename) { 
  calendar today = calendar.getinstance(); 
  string year = string.valueof(today.get(calendar.year)); 
  string month = string.valueof(today.get(calendar.month) + 1); 
 
 
  string uppath = basepath + file.separator + year + file.separator + month + file.separator; 
  file uploadfolder = new file(uppath); 
  if (!uploadfolder.exists()) { 
   uploadfolder.mkdirs(); 
  } 
 
  string realfilepath = uppath + filename; 
 
  return realfilepath; 
 } 
}