?? do_upload.jsp
字號:
<%--
文件名：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>
<div align="center">
<%
String user_id=(String)session.getAttribute("user_id");
//String pptcourse_id=(String)session.getAttribute("select_pptid");
String ftype="1";
Connection con;
ResultSet rs;
Statement stmt;
/* //jdbc
//數據庫登錄用戶和密碼
String user="sa";
String password="sa";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:jspbook";
con=DriverManager.getConnection(url,user,password); */
//odbc
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String drive = "jdbc:odbc:netteach";
//如果是采用windwos驗證方式，則采用下面的語句連接
con = DriverManager.getConnection(drive);
//創建一個jdbc聲明
stmt=con.createStatement();
SmartUpload su = new SmartUpload();
su.initialize(pageContext);
su.upload();
String homeworkcourse_id=su.getRequest().getParameter("select_homoworkid");
String title=su.getRequest().getParameter("title");
//byte [] tmptitle=title.getBytes("ISO8859_1");
//title=new String(tmptitle);
String Remark=su.getRequest().getParameter("Remark");
//byte [] tmpRemark=title.getBytes("ISO8859_1");
//Remark=new String(tmpRemark);
if(user_id == null || homeworkcourse_id == null)
{ out.println("用戶名或課程ID為空.");
out.println("用戶名："+user_id);
out.println("課程ID："+homeworkcourse_id);}
else{
int count = su.save("/netteach/student_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();
//byte [] tmpfilename=filename.getBytes("ISO8859_1");
//filename=new String(tmpfilename);
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());
stmt.executeUpdate("insert into n_file(filename,title,"
+"filetype,filelength,uploadtime,type,description,user_id,course_id)"
+"values('"+filename+"','"+title+"','"+filetype+"','"
+sfilelength+"','"+suploadtime+"','"+ftype+"','"+Remark+"','"+user_id+"','"+homeworkcourse_id+"')");
out.println("<TABLE BORDER=1 cellpadding=2 cellspacing=2 bordercolor=#DDF2F8>");
//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("<TR><TD>上傳時間：</TD><TD>"+ suploadtime + "</TD></TR>");
out.println("<TR><TD>課程代號：</TD><TD>"+ homeworkcourse_id + "</TD></TR>");
out.println("</TABLE><BR>");
}
%>
<a href="student_uploadhomework.jsp">確定</a>
</div>
<% }
%>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -