manage.asp(用户显示页面)
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../Inc/Conn.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=" http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>用户管理</title>
</head>
<body>
<table width="450" border="1" align="center" cellpadding="0" cellspacing="0" bordercolordark="#FFFFFF" bordercolorlight="#CCCCCC">
<tr >
<td height="25" colspan="3" align="center" bgcolor="#A4B6D7"><strong>用户管理</strong></td>
</tr>
<tr >
<td width="96" height="22" align="center" bgcolor="#A4B6D7">用户名</td>
<td width="258" align="center" bgcolor="#A4B6D7">密码</td>
<td width="88" height="22" align="center" bgcolor="#A4B6D7">编辑</td>
</tr>
<%
Set rs= Server.CreateObject("ADODB.Recordset")
sql="select * from User1"
rs.Open sql,conn,1,3
do while not rs.eof
%>
<tr >
<td width="96" height="22" align="center" bgcolor="#A4B6D7"><%= rs("UserName") %></td>
<td width="258" align="center" bgcolor="#A4B6D7"><%= rs("Password") %></td>
<td width="88" height="22" align="center" bgcolor="#A4B6D7">
<a href="userdel.asp?id=<%= rs("UserID") %>">删除 </a>|
<a href="modify.asp?id=<%= rs("UserID") %>">修改</a></td>
</tr>
<%
rs.movenext
loop
rs.Close
set rs=nothing
%>
</table>
</body>
</html>
userdel.asp(用户处理删除页面代码!)
<!--#include file="../inc/Conn.asp"-->
<%
id=trim(request.QueryString("id"))
tsql="delete * from User1 where UserID='"&id&"'"
conn.Execute tsql
Response.write "<script language='javascript'>"
Response.write "alert('删除成功!');"
Response.write "window.document.location.href='manage.asp';"
Response.write "</script>"
Response.End
%>
错误好像没有,但删除功能没有实现,估计是页面传输UserID出现问题!请高手解决一下,小弟不甚感激!