?? keupdatez.asp
字號(hào):
<!--#include file="conn.asp"-->
<%
zhuanye=request.form("zhuanye")
exec="select * from 課程 where zhuanye='"+zhuanye+"'"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
if rs.eof then
response.write "請(qǐng)寫(xiě)明確到底是哪個(gè)專(zhuān)業(yè)，OK？！"
response.end
end if
rs.PageSize=10 '##設(shè)置一個(gè)頁(yè)碼里面顯示的記錄數(shù)
pagecount=rs.PageCount '##pagecount是記錄的個(gè)數(shù)
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then '##當(dāng)前頁(yè)為 page頁(yè)
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("你確信要?jiǎng)h除嗎？"))
{
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刪除已經(jīng)存在課表</font></strong></font></p>
<table width="758" border="1" height="75" cellpadding="1" cellspacing="0" bordercolor="#666633">
<tr background="imags/032.gif">
<td height="28" width="49">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">星期</font></div>
</td>
<td height="28" width="49">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">節(jié)次</font></div>
</td>
<td height="28" width="110">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">課程名</font></div>
</td>
<td height="28" width="51">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">教師</font></div>
</td>
<td height="28" width="96">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">專(zhuān)業(yè)</font></div>
</td>
<td height="28" width="49">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">年績(jī)</font></div>
</td>
<td height="28" width="56">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">班級(jí)</font></div>
</td>
<td height="28" width="51">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">教室</font></div>
</td>
<td height="28" width="54">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">周次</font></div>
</td>
<td height="28" width="64">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">課程性質(zhì)</font></div>
</td>
<td height="28" width="83">
<div align="center"><font color="#000000" size="5" face="隸書(shū)">更新</font></div>
</td>
</tr>
<%
do while not rs.eof
%>
<tr>
<td width="49" height="35"><%=rs("week")%>
<div align="left"></div>
</td>
<td width="49" height="35"><%=rs("jieci")%>
<div align="left"></div>
</td>
<td width="110" height="35"><%=rs("lessonname")%>
<div align="left"></div>
</td>
<td width="51" height="35"><%=rs("teachername")%>
<div align="left"></div>
</td>
<td width="96" height="35"><%=rs("zhuanye")%>
<div align="left"></div>
</td>
<td width="49" height="35"><%=rs("jino")%>
<div align="left"></div>
</td>
<td width="56" height="35"><%=rs("banno")%>
<div align="left"></div>
</td>
<td width="51" height="35"><%=rs("room")%>
<div align="left"></div>
</td>
<td width="54" height="35"><%=rs("weekname")%>
<div align="left"></div>
</td>
<div align="left"></div>
</td>
<td width="83" 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('kedeletez.asp?zhuanye=<%=rs("zhuanye")%>')">刪除</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>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -