modifysmallclass1.asp

来自「这是一个学生毕业时做的教务系统」· ASP 代码 · 共 97 行

ASP
97
字号
<!--#include file=conn.asp -->
<%
IF Session("KEY")<>"super"  THEN
response.redirect "index_face.asp"
response.end
END IF

set rs=server.CreateObject ("ADODB.RecordSet")
rs.Source="select * from BigClass"
rs.Open rs.source,conn,1,1

set rs2=server.CreateObject ("adodb.recordset")
rs2.Source ="select * from SmallClass order by SmallClassID"
rs2.Open rs2.Source,conn,1,1

set rs3=server.CreateObject("Adodb.RecordSet")
%>
<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href=site.css rel=stylesheet>
</head>

<body>

<p> </p>
<form method="POST" action="ModifySmallClass2_submit.asp">
<table border="0" width="450" align=center>
<tr>
<td width="100%"><b>修改新闻小类</b></td>
</tr>
<tr>
<td width="100%">
<hr size="1">
</td>
</tr>
<tr>
<td width="100%">请选择您需要修改的新闻小类:</td>
</tr>
<tr>
<td width="100%">
<select size="<%=rs2.RecordCount %>" name="SmallClassID" style="font-size: 9pt">
<%if rs2.EOF then %>
<option>暂无任何新闻小类</option>
<%else
while not rs2.EOF
rs3.Source="select * from BigClass where BigClassID=" & rs2("BigClassID")
rs3.Open rs3.Source,conn,1,1
%>
<option value=<%=rs2("SmallClassID")%>><%=trim(rs2("SmallClassName"))%>&nbsp;&nbsp;(<%=trim(rs3("BigClassName"))%>)</option>
<%      rs3.close
rs2.MoveNext
wend
end if
%>
</select>
</td>
</tr>
<tr>
<td width="100%">&nbsp;&nbsp;&nbsp;</td>
</tr>
<tr>
<td width="100%">请在下面输入该小类的新名称:</td>
</tr>
<tr>
<td width="100%"><input type="text" name="NewSmallClassName" size="26" style="font-size: 9pt"><input type="submit" value="  修改>  " name="B1" style="font-size: 9pt">

</td>
</tr>
<tr>
<td width="100%">   </td>
</tr>
<tr>
<td width="100%"></td>
</tr>
<tr>
<td width="100%"> </td>
</tr>
</table>
<%
rs.Close
set rs=nothing

rs2.Close
set rs2=nothing

set rs3=nothing

conn.close
set conn=nothing
%>
</form>
</body>

</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?