📄 do_uploadmodify.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="2";
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 modifycourse_id=su.getRequest().getParameter("select_modifyid");
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 || modifycourse_id == null)
{ out.println("用户名或课程ID为空.");
out.println("用户名："+user_id);
out.println("课程ID："+modifycourse_id);}
else{
int count = su.save("/netteach/teacher_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+"','"+modifycourse_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>"+ modifycourse_id + "</TD></TR>");
out.println("</TABLE><BR>");
}
%>
<a href="teacher_uploadmodify.jsp">确定</a>
</div>
<% }
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -