index.asp

晴和教务管理系统

<!--#include file="../inc/top.asp"-->
<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"> 

</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> >>  >> 公开课表</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="27" height="20"><p class="table-xia">
序号</p></td>
<td class="table-you" align="center" width="61" height="20"><p class="table-xia">
教师</p></td>
<td class="table-you" align="center" width="88" height="20"><p class="table-xia">
科目</p></td>
<td class="table-you" align="center" width="72" height="20"><p class="table-xia">
学生</p></td>
<td class="table-you" align="center" width="176" 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="89" height="20"><p class="table-xia">
时间</p></td>
<td align="center" width="5" height="20">　</td>
</tr>
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_openclass where sh = 1 and rq>=date() order by adddate desc",conn,1,3
xu=1
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="27" height="20"><p class="table-xia"><% =xu%></p></td>
<td class="table-you" align="center" width="61" height="20"><p class="table-xia"><% =rs("teachername")%></p></td>
<td class="table-you" align="center" width="88" height="20"><p class="table-xia"><% =rs("kcmc")%></p></td>
<td class="table-you" align="center" width="72" height="20"><p class="table-xia"><% =rs("student")%></p></td>
<td class="table-you" align="center" width="176" height="20"><p class="table-xia"><% =rs("cjdx")%></p></td>
<td class="table-you" align="center" width="46" height="20"><p class="table-xia"><% =rs("classroom")%></p></td>
<td class="table-you" align="center" width="89" height="20"><p class="table-xia"><%=month(rs("rq"))&"月"&day(rs("rq"))&"日"&rs("js")%></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>
<!--#include file="../inc/end.asp"-->