|
<%--
文件名：do_upload.jsp
--%>
<%@ page contentType="text/html; charset=gb2312" language="java"
import="com.jspsmart.upload.*,java.sql.*"
errorPage=""%>
<html>
<head>
<title>文件上传处理页面</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<%
Connection con;
ResultSet rs;
Statement stmt;
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost/upload";
String user="luozhe0107";
String password="petrel";
Class.forName(driver).newInstance();
con=DriverManager.getConnection(url,user,password);
stmt=con.createStatement();
/*
//数据库登录用户和密码
String user="luozhe0107";
String password="petrel";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:jspbook";
con=DriverManager.getConnection(url,user,password);
//创建一个jdbc声明
stmt=con.createStatement();
*/
System.out.println("ok");
SmartUpload su = new SmartUpload();
su.initialize(pageContext);
su.upload();
String title=su.getRequest().getParameter("title");
String Remark=su.getRequest().getParameter("Remark");
int count = su.save("/upload");
out.println(count+"个文件上传成功！<br>");
//out.println("TEST="+su.getRequest().getParameter("TEST")+"<BR><BR>");
System.out.println("2");
for (int i=0;i<su.getFiles().getCount();i++)
{
System.out.println("3");
com.jspsmart.upload.File file = su.getFiles().getFile(i);
if (file.isMissing()) continue;
String filename=file.getFileName();
int ifilelength=file.getSize();
String sfilelength=Integer.toString(ifilelength);
String filetype=file.getFileExt();
java.util.Date dt = new java.util.Date();
String suploadtime=String.valueOf(1900+dt.getYear())+"-"+String.valueOf(1+dt.getMonth())
+"-"+String.valueOf(dt.getDate())+" "+String.valueOf(dt.getHours())
+":"+String.valueOf(dt.getMinutes())+":"+String.valueOf(dt.getSeconds());
int fileid=0;
stmt.executeUpdate("insert into uploadfileinfo2(fileid,filename,title,"
+"filetype,filelength,uploadtime,description)"
+"values(+fileid+,+filename+,+title+,+filetype+,
+sfilelength+,+suploadtime+,+Remark+)");
out.println("<TABLE BORDER=1>");
out.println("<TR><TD>文件名:</TD><TD>"+ filename + "</TD></TR>");
out.println("<TR><TD>文件长度:</TD><TD>" +sfilelength + "</TD></TR>");
out.println("<TR><TD>文件类型：</TD><TD>"+ filetype + "</TD></TR>");
//out.println("<TR><TD>文件全名（FilePathName）</TD><TD>"+ file.getFilePathName() + "</TD></TR>");
out.println("</TABLE><BR>");
}
%>
</body>
</html>
|
