classes.asp

晴和教务管理系统

<% if request.Cookies("jiaowu")("Lx") <> "学生" then response.redirect "/jw/index.asp"%>
<!--#include file="../inc/top.asp"-->
<%
dim action
action=request.QueryString("action")
select case action
case ""
%>
<div align="center">
<table width="760" align="center" border="0" cellspacing="0" cellpadding="0" class="table-zuoyou" bordercolor="#CCCCCC">
<tr> 
<td width="180" valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF" class="table-you">
<!--#include file="../loginout.asp"-->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="35" bgcolor="f1f1f1" background="/jw/images/menu_02.gif" valign="bottom">
<p align="right">快 速 查 询 通 道&nbsp;&nbsp;&nbsp;</td>
</tr>
<tr> 
<td> 
<table width="100%" border="0" cellpadding="0" cellspacing="0" align="center" height="70">
<tr> 
<td height="20"> 
　您的购物车有<font color=red>0</font>件商品<br>
　总金额：<font color=red>0</font>元
</td>
</tr>
<tr> 
<td height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width="580" valign="top" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> 
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<TR><td class="table-shangxia" bgcolor="#ffffff" height="35"><img src="/jw/images/menu_06.gif" width="41" height="33" align="absmiddle"> <a href="/jw/index.asp">教学系统</a> 
	&gt;&gt; &gt;&gt; <a href="index.asp">学生事务</a> &gt;&gt; &gt;&gt; 本学期修读课程</td></tr>
</table>
<table width="580" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td align="center" width="6" height="27">　</td>
<td class="table-xia" align="center" height="27"><font color="#008000">本学期修读课程列表</font></td>
<td align="center" width="5" height="27">　</td>
</tr>
</table>
<table width="580" border="0" cellspacing="0" cellpadding="0" align="center">
<TR>
<td class="table-you" align="center" width="5" height="20"><p>　</p></td>
<td class="table-you" align="center" width="10%" height="20"><p class="table-xia">课程代码</p></td>
<td class="table-you" align="center" width="55" height="20"><p class="table-xia">任课教师</p></td>
<td class="table-you" align="center" width="97" height="20"><p class="table-xia">课程名称</p></td>
<td class="table-you" align="center" width="46" height="20"><p class="table-xia">教室</p></td>
<td class="table-you" align="center" width="275" height="20"><p class="table-xia">时间</p></td>
<td class="table-you" align="center" width="38" height="20"><p class="table-xia">
　</p></td>
<td align="center" width="5" height="20">　</td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select Jw_teaclass.*,Jw_stuclass.* from Jw_stuclass,Jw_teaclass where Jw_stuclass.studentNum = '" & request.Cookies("jiaowu")("Num") & "' and Jw_teaclass.ID = Jw_stuclass.teacherclassID"
rs.open sql,conn,1,3
do while not rs.eof
%>
<TR>
<td class="table-you" align="center" width="5" height="20"><p>　</p></td>
<td class="table-you" align="center" width="10%" height="20"><p class="table-xia"><% =rs(1)%></p></td>
<td class="table-you" align="center" width="55" height="20"><p class="table-xia"><% =rs(4)%></p></td>
<td class="table-you" align="center" width="97" height="20"><p class="table-xia"><% =rs(3)%></p></td>
<td class="table-you" align="center" width="46" height="20"><p class="table-xia"><% =rs(8)%></p></td>
<td class="table-you" align="center" width="275" height="20"><p class="table-xia"><% =rs(9)%></p></td>
<td class="table-you" align="center" width="38" height="20"><p class="table-xia"><% if rs("xuanxiuke")=1 then response.write "<a href='classes.asp?action=del&ID="& rs(17)&"'>删除</a>" else response.write "　"%></p></td>
<td align="center" width="5" height="20">　</td>
</tr>
<%
xu=xu+1
rs.movenext
loop
rs.close
set rs=nothing
%>
</table>
</td>
</tr>
</table>
</div>
<%
case "del"
id=request("ID")
conn.execute "delete from Jw_stuclass where classID="&id
conn.close
set conn=nothing
response.write "<br><br><center><font color=red>删除选修课成功！</font></center><br><br>"

end select
%><!--#include file="../inc/end.asp"-->