📄 suject.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<!--#include file = "../inc/conn.asp" -->
<!--#include file = "../CheckLogin.asp" -->
<!--#include file = "../inc/zhuru.asp" -->
<%
Dim strSsql
If Session("UserType") = "学生" Then
strSsql = "WHERE ClassID IN (SELECT ClassID FROM Student WHERE name = '"& Session("UserName") &"')"
ElseIf Session("UserType") = "教师" Then
strSsql = "WHERE TeacherID IN (SELECT ID FROM Teacher WHERE name = '"& Session("UserName") &"')"
End If
%>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
body {
background-color: #B1DB99;
}
.STYLE1 {
font-size: 14px;
color: #FF0000;
}
-->
</style></head>
<%
Dim rs ,strSql ,Num ,pageNum ,page ,loopNum
strSql = "SELECT * FROM TeachingSuject " & strSsql
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql,conn,1,1
%>
<body topmargin="0" leftmargin="5">
<%
If rs.recordcount > 0 Then
rs.pagesize = 14
Num = rs.recordcount
pageNum = rs.pagecount
page = Request.QueryString("page")
If page <> "" Then
page = Cint(page)
ElseIf page < 1 Then
page = 1
Else
page =1
End If
If page < 1 then
page =1
End If
If page*rs.pagesize >Num and Not ((page-1)*rs.pagesize <Num) Then
page = 1
End If
rs.absolutepage = page
If page <> pageNum Then
LoopNum = rs.pagesize
Else
LoopNum = Num - (page-1)*rs.pagesize
End If
%>
<table width="500">
<tr bgcolor="#66FF99">
<td colspan="9" background="../images/liebiao.gif" bgcolor="#00CC00"><div align="center"><span class="STYLE1">请选择课程进入在线自测区</span></div></td>
</tr>
<tr bgcolor="#66FF99">
<td colspan="9" background="../images/Down_bg.gif" bgcolor="#00CC00"><div align="center">总共找到<%=Num%>条记录 <a href="Suject.asp?page=1">首页</a> <a href="Suject.asp?page=<%=page-1%>">上一页</a> <a href="Suject.asp?page=<%=page+1%>">下一页</a> <a href="Suject.asp?page=<%=pageNum%>">尾页</a> 页次:<%=page%>/<%=pagenum%> 共<%=pageNum%>页</div></td>
</tr>
<tr bgcolor="#009933">
<td width="55"> </td>
<td width="144">课程名</td>
<td width="79">教师</td>
<td width="111">开课班级</td>
<td width="73">学年</td>
<td width="42">学期</td>
</tr>
<% For i = 1 to LoopNum %>
<tr bgcolor="#FFFFFF" onMouseOver="this.style.backgroundColor='#FFFFCC'" onMouseOut="this.style.backgroundColor='#FFFFFF'">
<td align="center"><img src="images/dot2.gif" width="10" height="8" /></td>
<%
Dim rs1 ,strSql1 ,strSujectName
If rs("SujectID") <> "" Then
Set rs1 = Server.CreateObject("ADODB.RecordSet")
strSql1 = "SELECT * FROM Suject WHERE ID = " & rs("SujectID")
rs1.open strSql1,conn,1,1
If Not rs1.EOF Then
strSujectName = rs1("Name").value
Else
strSujectName = ""
End If
rs1.close
Set rs1 = Nothing
Else
strSujectName = ""
End If
%>
<td><a href="admin.asp?TeachingSujectID=<%=rs("ID")%>&TeacherID=<%=rs("TeacherID")%>&SujectID=<%=rs("SujectID")%>"><%=strSujectName%></a></td>
<%
Dim strTeacherName
If rs("TeacherID") <> "" Then
Set rs1 = Server.CreateObject("ADODB.RecordSet")
strSql1 = "SELECT * FROM Teacher WHERE ID = " & rs("TeacherID")
rs1.open strSql1,conn,1,1
If Not rs1.EOF Then
strTeacherName = rs1("Name").value
Else
strTeacherName = ""
End If
rs1.close
Set rs1 = Nothing
Else
strTeacherName = ""
End If
%>
<td><a href="DetailTeacher.asp?ID=<%=rs("TeacherID").value%>"><%=strTeacherName%></a></td>
<%
Dim rs2 ,strSql2 ,strClassName
If rs("ClassID") <> "" Then
Set rs2 = Server.CreateObject("ADODB.RecordSet")
strSql1 = "SELECT * FROM Class WHERE ID = " & rs("ClassID")
rs2.open strSql1,conn,1,1
If Not rs2.EOF Then
strClassName = rs2("Name").value
Else
strClassName = ""
End If
rs2.close
Set rs2 = Nothing
Else
strClassName = ""
End If
%>
<td><%=strClassName%></td>
<td><%=rs("TeachingYear").value%></td>
<td><%=rs("Semester").value%></td>
</tr>
<% rs.movenext
Next %>
<tr>
<td colspan="9" background="images/Down_bg.gif" bgcolor="#00CC00"><div align="center">总共找到<%=Num%>条记录 <a href="Suject.asp?page=1">首页</a> <a href="Suject.asp?page=<%=page-1%>">上一页</a> <a href="Suject.asp?page=<%=page+1%>">下一页</a> <a href="Suject.asp?page=<%=pageNum%>">尾页</a> 页次:<%=page%>/<%=pagenum%> 共<%=pageNum%>页</div></td>
</tr>
</table>
<%
Else
%>
<table width="500">
<tr bgcolor="#009933">
<td colspan="6" background="images/Down_bg.gif" bgcolor="#009933"> </td>
</tr>
<tr bgcolor="#009933">
<td width="62"> </td>
<td width="128">课程名</td>
<td width="75">教师</td>
<td width="136">开课班级</td>
<td width="81">学年</td>
<td width="72">学期</td>
</tr>
<tr>
<td colspan="6" bgcolor="#FFFFFF">没有相关记录！</td>
</tr>
</table>
<%
End If
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -