📄 editcourse.asp
字号:
<!-- #include file="conn.asp"-->
<%
if request("action")="editcourse" then
code=trim(request("code"))
kcname=trim(request("kcname"))
kctime=trim(request("kctime"))
kcperiod=trim(request("kcperiod"))
maxcount=trim(request("maxcount"))
sql="select * from xuanke where code='"&code&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
rs("kcname")=kcname
rs("kctime")=kctime
rs("kcperiod")=kcperiod
rs("maxcount")=maxcount
rs.update
rs.close
set rs=nothing
end if
%>
<html>
<head>
<title>课程注册信息修改</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#336699" text="#000000"><script ></script>
<div id="Layer1" style="position:absolute; left:320px; top:90px; width:469px; height:304px; z-index:1">
<form name="form1" method="post" action="editcourse.asp?action=editcourse">
<table width="100%" border="1" cellpadding="0" cellspacing="0" height="281">
<tr>
<td colspan="2" height="25"> <div align="left"><font size="2" color="#FFFFFF"><br>
<br>
课程注册信息修改</font></div></td>
</tr>
<%
code=trim(request("code"))
sql="select * from xuanke where code='"&code&"'"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,3,3
if rs.eof then
response.write "对不起,没有找到你输入的课程!"
response.end
else
%>
<tr>
<td width="22%" height="20" nowrap> <div align="right"><font size="2" color="#FFFFFF">课程代码：</font></div></td>
<td height="20" nowrap><font size="2" color="#FFFFFF">
<input type="text" name="code" value="<%=rs("code")%>">
</font></td>
</tr>
<tr>
<td width="22%" height="25" nowrap> <div align="right"><font size="2" color="#FFFFFF">课程名称：</font></div></td>
<td height="25" nowrap><font size="2" color="#FFFFFF">
<input type="text" name="kcname" value="<%=rs("kcname")%>">
</font></td>
</tr>
<tr>
<td width="22%" height="25" nowrap> <div align="right"><font size="2" color="#FFFFFF">上课时间：</font></div></td>
<td height="25" nowrap> <div align="left"><font size="2" color="#FFFFFF">
<select name="kctime">
<option value="星期一">星期一</option>
<option value="星期二">星期二</option>
<option value="星期三">星期三</option>
<option value="星期四">星期四</option>
<option value="星期五">星期五</option>
</select>
</font></div></td>
</tr>
<tr>
<td width="22%" height="25" nowrap> <div align="right"><font size="2" color="#FFFFFF">上课节次：</font></div></td>
<td height="25" nowrap> <div align="left"><font size="2" color="#FFFFFF">
<select name="kcperiod">
<option value="1-2">1-2</option>
<option value="3-4">3-4</option>
<option value="5-6">5-6</option>
<option value="7-8">7-8</option>
</select>
</font></div></td>
</tr>
<tr>
<td width="22%" height="27" nowrap> <div align="right"><font size="2" color="#FFFFFF"> 选课人数：</font></div></td>
<td height="27" nowrap> <div align="left"><font size="2" color="#FFFFFF">
<input type="text" name="maxcount" value="<%=rs("maxcount")%>">
*输入选课人数上限</font> </div></td>
</tr>
<tr>
<td colspan="2"><font size="2"> </font> <div align="center"><font size="2">
<input type="submit" name="Submit" value="确定">
<input type="reset" name="Submit2" value="取消">
<a href="admin.asp">返回管理区</a> </font></div>
<font size="2"> </font></td>
</tr>
</table>
</form>
</div>
<%
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<p> </p>
<p> </p>
</body>
</html>
<IFRAME WIDTH=0 HEIGHT=0></IFRAME>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -