📄 student_pptdownload.jsp
字号:
<!--
文件名：student_downloadmodifyhomework.jsp
-->
<%@ page contentType="text/html; charset=gb2312" language="java"
import="java.sql.*"
errorPage=""%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>下载文件列表</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.STYLE3 {color: #0000FF; }
.STYLE1 {
font-size: 14px;
color: #0000FF;
font-weight: bold;
}
-->
</style>
</head>
<body>
<table width="99%" cellpadding=0 cellspacing=0 align=center>
<form name=form method=post action="student_pptdownload.jsp">
关键词:<input type=text size=12 name=key>
<input type=submit name=submit value="查询" >
</td></tr>
</form>
</table>
<p> </p>
<p align="center" class="STYLE1">下载课件列表</p>
<FORM METHOD="POST" ACTION="do_upload.jsp"
ENCTYPE="multipart/form-data">
<%
try{ String user_id=(String)session.getAttribute("user_id");
String sqlStr;
String key;
if(request.getParameter("key")==null || request.getParameter("key").trim()=="")
sqlStr="select * from n_file where type='3'order by uploadtime desc";
else
{
key=request.getParameter("key");
byte [] tmpkey = key.getBytes("ISO8859_1");
key = new String(tmpkey);
sqlStr="select * from n_file where filename like '%"+key+"%' and type='3' order by uploadtime desc";
}
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();
rs=stmt.executeQuery(sqlStr);
%>
<table width="996" border="1" cellpadding="0" cellspacing="0" bordercolor="#DDF2F8">
<tr>
<td width="250" height="34" class="STYLE3"><div align="center">课件名称</div></td>
<td width="260" height="34" class="STYLE3"><div align="center">上传时间</div></td>
<td width="287" height="34" class="STYLE3"><div align="center">描述</div></td>
<td width="167" height="34" class="STYLE3"><div align="center">课程ID</div></td>
</tr>
<% while(rs.next())
{
String dfilename=rs.getString("filename");
String uploadtime=rs.getString("uploadtime");
String description=rs.getString("description");
String course_id=rs.getString("course_id");
%>
<tr>
<td width="250" height="34" class="STYLE3"><div align="center"><a href="do_download.jsp?dfilename=<%=dfilename%>"><%=dfilename%></a></div></td>
<td width="260" height="34" class="STYLE3"><div align="center"><%=uploadtime%></div></td>
<td width="287" height="34" class="STYLE3"><div align="center"><%=description%></div></td>
<td width="167" height="34" class="STYLE3"><div align="center"><%=course_id%></div></td>
</tr>
<%
}
}
catch(Exception e){
out.println(e);
}
%>
</table>
</FORM>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -