📄 teacher_homeworklist.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="teacher_homeworklist.jsp">
课程ID：<select name="select_courseid" value="select_courseid">
<%
String user_id=(String)session.getAttribute("user_id");
if(user_id == null)
{ }
else{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String driven = "jdbc:odbc:netteach";
//如果是采用windwos验证方式，则采用下面的语句连接
Connection conn = DriverManager.getConnection(driven);
//创建一个jdbc声明
Statement stmtt=conn.createStatement();
String sql="select * from n_course where user_id='"+user_id+"'";
//rs为返回结果的ResultSet对象
ResultSet rss=stmtt.executeQuery(sql);
while(rss.next())
{
String courseid=rss.getString("course_id");
%>
<option value="<%=courseid%>"><%=courseid%></option>
<% }
%>
</select>
<input type=submit name=submit value="查询" >
</td></tr>
</form>
</table>
<p> </p>
<p align="center" class="STYLE1">学生上传作业列表</p>
<%
try{
String sqlStr;
String courseid;
if(request.getParameter("select_courseid")==null || request.getParameter("select_courseid").trim()=="")
sqlStr="select * from n_file where type='1'order by uploadtime desc";
else
{
courseid=request.getParameter("select_courseid");
sqlStr="select * from n_file where course_id like '%"+courseid+"%' and type='1' 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="200" height="34" class="STYLE3"><div align="center">作业名称</div></td>
<td width="187" height="34" class="STYLE3"><div align="center">课程ID</div></td>
<td width="167" height="34" class="STYLE3"><div align="center">上传者</div></td>
<td width="160" height="34" class="STYLE3"><div align="center">上传时间</div></td>
<td width="250" height="34" class="STYLE3"><div align="center">描述</div></td>
</tr>
<% while(rs.next())
{
String dfilename=rs.getString("filename");
String uploadtime=rs.getString("uploadtime");
String description=rs.getString("description");
String student_id=rs.getString("user_id");
String course_id=rs.getString("course_id");
%>
<tr>
<td width="250" height="34" valign="middle" class="STYLE3"><div align="center"><a href="do_download.jsp?dfilename=<%=dfilename%>"><%=dfilename%></a></div>
</td>
<td width="187" height="34" class="STYLE3"><div align="center"><%=course_id%></div></td>
<td width="167" height="34" class="STYLE3"><div align="center"><%=student_id%></div></td>
<td width="160" height="34" class="STYLE3"><div align="center"><%=uploadtime%></div></td>
<td width="250" height="34" class="STYLE3"><div align="center"><%=description%></div></td>
</tr>
<%
}rs.close();
}
catch(Exception e){
out.println(e);
}
rss.close();
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -