?? addclass2.asp
字號:
<%@ Language=VBScript %>
<% If Session("count")<10 Then %>
<!--#INCLUDE FILE="connect.asp" -->
<!--#INCLUDE FILE="inc_Function.asp" -->
<%
Dim strClass,strClassName,strSql,strErr,strMsg
If Request.QueryString("active")="DoIt" Then
strClass=chkf(Request.form("Class"))
strClassName=chkf(Request.form("AddClass"))
If strClass=0 and strClassName<>"" Then
strSql="Insert into Class(classname)"
strSql=strSql & "Values("
strSql=strSql & "'" & strClassName & "')"
strMsg="類別添加成功"
ElseIf strClass<>0 and strClassName="" Then
strSql="Delete from Class where classid=" & strClass
strMsg="類別刪除成功"
ElseIf strClass<>0 and strClassName<>"" Then
strSql="Update Class set classname=" & "'" & strClassName & "'"
strSql=strSql & "where classid=" & strClass
strMsg="類別修改成功"
Else
strSql=""
strMsg="您選擇的組合是什么也不做"
End If
If strSql<>"" Then conn.execute(strSql)
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="VI60_defaultClientScript" content="JavaScript">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>AddClass2</title>
</head>
<body bgcolor="#D6D3CE">
<%
If conn.errors.count=0 Then
%>
<div align="center">
<center>
<table border="1" width="75%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%"><%=strMsg%></td>
</tr>
<tr>
<%
Dim strRs
strRs="select * from Class"
set rs=conn.execute(strRs)
%>
<td width="100%">
<p align="center">現(xiàn)有類別:
<% Do While not rs.eof %>
<%=rs("classname")%>
<% rs.movenext %>
<% Loop %>
</td>
<%
rs.close
set rs=nothing
%>
</tr>
</center>
<tr>
<td width="100%">
<p align="center"><a href="typemanagement.asp">返回類別管理</a></td>
</tr>
</table>
</div>
<%
End If
%>
</body>
</html>
<%
conn.close
set conn=nothing
%>
<% Else %>
<% End If %>
<%
Else
Response.redirect "index.htm"
End If
%>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -