📄 stdcourselist.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->
<!--#include file="stdpurview.asp"-->
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title></title>
</head>
<body>
<%
dim rs,rsc,sql
dim stuno
'获得学生学号
'stuno=session("user")
'response.Write(stuno)
'set rs=server.CreateObject("adodb.recordset")
'通过学生学号获得学生所学的课程信息
'sql="SELECT Student.StuNO, choose.CourseID FROM Student INNER JOIN choose ON Student.StuID = choose.StudentID"
'rs.open sql,conn,1,1
%>
<table width="100%" border="0">
<tr>
<td colspan="5">所有课程</td>
</tr>
<tr>
<td>课程编号</td>
<td>课程名称</td>
<td>上课时间</td>
<td>任课教师</td>
<td>备注</td>
</tr>
<%
' if not rs.eof and not rs.bof then
' do while not rs.eof
set rsc=server.CreateObject("adodb.recordset")
'根据课程ID查询课程详细ID
sql="SELECT course.CourseNo, course.CourseName, course.CourseTime, Teacher.TeacherName, course.CourseRemake, course.CourseID FROM Teacher INNER JOIN course ON Teacher.TeacherID = course.teacherID "
rsc.open sql,conn,1,1
if not rsc.eof and not rsc.bof then
do while not rsc.eof
%>
<tr>
<td><%=rsc("CourseNo")%></td>
<td><%=rsc("CourseName")%></td>
<td><%=rsc("CourseTime")%></td>
<td><%=rsc("TeacherName")%></td>
<td><%=rsc("CourseRemake")%></td>
</tr>
<%
rsc.movenext
loop
end if
rsc.close
' rs.movenext
' loop
' end if
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -