添加修改都可以,就是删除不行,急呀
<!--#include file="conn.asp"-->
<html><head><title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/css.css" rel="stylesheet" type="text/css">
</head>
<body>
<%dim action,ztid
ztid=request.QueryString("id")
action=request.QueryString("action")
set rs=server.CreateObject("adodb.recordset")
select case action
'/////修改专题类别
case "ztsave"
rs.open "select * from zhuanti where ztid="&ztid,conn,1,3
rs("ztname")=trim(request("ztname"))
rs("ztorder")=request("ztorder")
rs.update
rs.close
response.write "<script language=javascript>alert('成功修改了专题类别!');history.go(-1);</script>"
response.End
'/////添加专题类别
case "ztadd"
rs.open "select * from zhuanti",conn,1,3
rs.addnew
rs("ztname")=trim(request("ztname"))
rs("ztorder")=request("ztorder")
rs.update
rs.close
response.redirect "zhuanti.asp?action=zt"
response.End
'/////删除专题类别
case "ztdel"
conn.execute "delete from zhuanti where ztid="&ztid
response.redirect "zhuanti.asp?action=zt"
response.End
'/////删除专题类别
end select
set rs=nothing
%>
<table class="tableBorder" width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td align="center" background="../images/admin_bg_1.gif"> </td>
<td align="center" background="../images/admin_bg_1.gif"> </td>
</tr>
<tr>
<td bgcolor="#E8F1FF" colspan="2">
<%select case action
case "zt"%>
<table width="500" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#183789">
<tr bgcolor="#E8F1FF">
<td width="40%" align="center" background="../images/admin_bg_1.gif">
<font color="#FFFFFF">专题类别</font></td>
<td width="20%" align="center" background="../images/admin_bg_1.gif"><font color="#ffffff">排 序</font></td>
<td width="40%" align="center" background="../images/admin_bg_1.gif"><font color="#ffffff">操 作</font></td>
</tr>
<%dim i,j
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from zhuanti order by ztorder",conn,1,1
i=rs.recordcount
do while not rs.eof%>
<tr>
<form name="form1" method="post" action="zhuanti.asp?action=ztsave&id=<%=rs("ztid")%>">
<td bgcolor="#E8F1FF" align="center">
<input name="ztname" type="text" id="ztname" size="14" value=<%=trim(rs("ztname"))%>>
</td>
<td bgcolor="#E8F1FF" align="center">
<input name="ztorder" type="text" id="ztorder" size="2" value=<%=rs("ztorder")%> onKeyPress = "return regInput(this, /^[0-9]*$/, String.fromCharCode(event.keyCode))"
onpaste = "return regInput(this, /^[0-9]*$/, window.clipboardData.getData('Text'))"
ondrop = "return regInput(this, /^[0-9]*$/, event.dataTransfer.getData('Text'))">
</td>
<td bgcolor="#E8F1FF" STYLE='PADDING-LEFT: 20px'>
<input type="submit" name="Submit" value="修 改">
<a href="zhuanti.asp.asp?action=ztdel&id=<%=rs("ztid")%>"><font color="#FF0000">删除</font></a>
</td>
</form>
</tr>
<%rs.movenext
loop
rs.close
set rs=nothing%>
<tr>
<td bgcolor="#E8F1FF" align="center" colspan="3" background="../images/admin_bg_1.gif"><font color="#ffffff">添加</font><font color="#FFFFFF">专题类别</font></td>
</tr>
<tr>
<form name="form2" method="post" action="zhuanti.asp?action=ztadd">
<td bgcolor="#E8F1FF" align="center">
<input name="ztname" type="text" id="ztname" size="14">
</td>
<td bgcolor="#E8F1FF" align="center">
<input name="ztorder" type="text" id="ztorder" value=<%=i+1%> size="2" onKeyPress = "return regInput(this, /^[0-9]*$/, String.fromCharCode(event.keyCode))"
onpaste = "return regInput(this, /^[0-9]*$/, window.clipboardData.getData('Text'))"
ondrop = "return regInput(this, /^[0-9]*$/, event.dataTransfer.getData('Text'))">
</td>
<td bgcolor="#E8F1FF" STYLE='PADDING-LEFT: 20px'>
<input type="submit" name="Submit3" value="添 加">
</td>
</form>
</tr>
</table>
<%case "zt"%>
<%end select%>
</td>
</tr>
</table>
<!--#include file="copyright.asp"-->
</body>
</html>
<script>
function regInput(obj, reg, inputStr)
{
var docSel = document.selection.createRange()
if (docSel.parentElement().tagName != "INPUT") return false
oSel = docSel.duplicate()
oSel.text = ""
var srcRange = obj.createTextRange()
oSel.setEndPoint("StartToStart", srcRange)
var str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)
return reg.test(str)
}
</script>