📄 keupdate.asp
字号:
<!--#include file="conn.asp"-->
<%
'exec="select * from 课程 order by teachername desc"
'set rs=server.createobject("adodb.recordset")
'rs.open exec,conn,1,1
teachername=request.form("teachername")
exec="select * from 课程 where teachername='"+teachername+"'"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
if rs.eof then
response.write "无此教师授课情况！"
response.end
end if
rs.PageSize=10 '##设置一个页码里面显示的记录数
pagecount=rs.PageCount '##pagecount是记录的个数
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then '##当前页为 page页
page=1
end if
rs.AbsolutePage=page
%>
<html>
<head>
<title>课程表更新2</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function onlist(myid)
{
if (confirm("你确信要删除吗？"))
{
document.location=myid;
return true;
}
return true;
}
</script>
</head>
<body background="imags/kabg.gif">
<table width="100%" border="0" cellpadding="1" cellspacing="1" bordercolor="#333333" >
<tr>
<td>
<p> </p>
<p align="center"><font color="#CC3399" size="5"><strong>课程表更新-<font size="3">选择性修改OR删除已经存在课表</font></strong></font></p>
<table width="744" border="1" height="59" cellpadding="1" cellspacing="0" bordercolor="#666633">
<tr background="imags/032.gif">
<td height="36" width="48">
<div align="center"><font color="#000000" size="5" face="隶书">星期</font></div>
</td>
<td height="36" width="51">
<div align="center"><font color="#000000" size="5" face="隶书">节次</font></div>
</td>
<td height="36" width="94">
<div align="center"><font color="#000000" size="5" face="隶书">课程名</font></div>
</td>
<td height="36" width="49">
<div align="center"><font color="#000000" size="5" face="隶书">教师</font></div>
</td>
<td height="36" width="117" background="imags/032.gif">
<div align="center"><font color="#000000" size="5" face="隶书">专业</font></div>
</td>
<td height="36" width="49">
<div align="center"><font color="#000000" size="5" face="隶书">年绩</font></div>
</td>
<td height="36" width="52">
<div align="center"><font color="#000000" size="5" face="隶书">班级</font></div>
</td>
<td height="36" width="57">
<div align="center"><font color="#000000" size="5" face="隶书">教室</font></div>
</td>
<td height="36" width="51">
<div align="center"><font color="#000000" size="5" face="隶书">周次</font></div>
</td>
<td height="36" width="63">
<div align="center"><font color="#000000" size="5" face="隶书">课程性质</font></div>
</td>
<td height="36" width="67">
<div align="center"><font color="#000000" size="5" face="隶书">更新</font></div>
</td>
</tr>
<%
do while not rs.eof
%>
<tr>
<td width="48" height="35"><%=rs("week")%>
<div align="left"></div>
</td>
<td width="51" height="35"><%=rs("jieci")%>
<div align="left"></div>
</td>
<td width="94" height="35"><%=rs("lessonname")%>
<div align="left"></div>
</td>
<td width="49" height="35"><%=rs("teachername")%>
<div align="left"></div>
</td>
<td width="117" height="35"><%=rs("zhuanye")%>
<div align="left"></div>
</td>
<td width="49" height="35"><%=rs("jino")%>
<div align="left"></div>
</td>
<td width="52" height="35"><%=rs("banno")%>
<div align="left"></div>
</td>
<td width="57" height="35"><%=rs("room")%>
<div align="left"></div>
</td>
<td width="51" height="35"><%=rs("weekname")%>
<div align="left"></div>
</td>
<td width="63" height="35"><%=rs("pro")%>
<div align="left"></div>
</td>
<td width="67" height="35" bgcolor="#FFCCFF">
<div align="left"><a href="kenew.asp?teachername=<%=rs("teachername")%>"><font size="2">修改
</font></a><font size="2"><a href="javascript:onlist('kedelete.asp?teachername=<%=rs("teachername")%>')">删除</a></font></div>
</td>
</tr>
<%
rs.movenext
loop
%>
</table>
<p> </p>
<div align="center"><font color="#330000"><a href="keupdatecha.asp"><img src="imags/0000005.gif" width="137" height="30" border="0"></a></font><br>
</div>
</td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -