📄 admin.asp
字号:
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<TITLE></TITLE>
<link rel="stylesheet" type="text/css" href="../jgwy.css">
</HEAD>
<BODY bgColor="#f7fdff">
<CENTER><%
status = Request.QueryString("status")
if status = "delete" then
Conn_String ="Provider=sqloledb;" & "Data Source=127.0.0.1;Initial Catalog=qiye_8;User Id=sa;Password=password;"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open Conn_String
sql = "select * from cat order by ID"
set rs = Conn.Execute (sql)
%>
<font size="3" face="宋体" color="#FF0000"><b>按“立即删除”键以删除类别</b></font><br>
</center>
<CENTER>
<table border="1">
<%
Do while NOT rs.EOF
ColNum = 1
Do while ColNum < 3
%>
<TD ALIGN=center VALIGN=middle ><%=rs("cat")%>
<form action="confirm.asp" method="post" id=form1 name=form1>
<input type="submit" value="立即删除" id=submit1 name=submit1>
<input type="hidden" value="<%=rs("ID")%>" name="catid">
<input type="hidden" value="<%=rs("cat")%>" name="cat">
</form></TD>
<%
if NOT rs.EOF then
rs.MoveNext
end if
ColNum = ColNum + 1
if NOT rs.EOF then
%>
<TD ALIGN=center VALIGN=middle ><%=rs("cat")%>
<form action="confirm.asp" method="post" id=form1 name=form1>
<input type="submit" value="立即删除" id=submit1 name=submit1>
<input type="hidden" value="<%=rs("ID")%>" name="catid">
<input type="hidden" value="<%=rs("cat")%>" name="cat">
</form></TD>
<%
end if
ColNum = ColNum + 1
Loop
%>
</TR>
<%
if NOT rs.EOF then
rs.MoveNext
end if
Loop
%>
</TABLE>
<% rs.close
Conn.Close
set Conn = nothing
else
Conn_String ="Provider=sqloledb;" & "Data Source=127.0.0.1;Initial Catalog=qiye_8;User Id=sa;Password=password;"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open Conn_String
sql = "select * from cat order by ID"
set rs = Conn.Execute (sql)
%>
<font face="宋体" color="#008000"><b><font size="3">编辑类别</font>...<font size="2">点击每个类别以改变类别名称</font></b></font>
<table border="0" width="300">
<%
Do while NOT rs.EOF
ColNum = 1
Do while ColNum < 3
%>
<TD ALIGN=LEFT VALIGN=middle WIDTH="150"><a href="edit.asp?CatID=<%=rs("id")%>"><%=rs("cat")%> </a></TD>
<%
if NOT rs.EOF then
rs.MoveNext
end if
ColNum = ColNum + 1
if NOT rs.EOF then
%>
<TD ALIGN=LEFT VALIGN=middle WIDTH="150"><a href="edit.asp?CatID=<%=rs("id")%>"><%=rs("cat")%></a></TD>
<%
end if
ColNum = ColNum + 1
Loop
%>
</TR>
<%
if NOT rs.EOF then
rs.MoveNext
end if
Loop
%>
</TABLE>
<% rs.close
Conn.Close
set Conn = nothing
end if
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -