📄 del.asp
字号:
<%@ Language=VBScript %>
<%
name=trim(request("name"))
pass1=trim(request("pass1"))
pass2=trim(request("pass2"))
quanxian=trim(request("quanxian"))
session("quanxian")=quanxian
if name<>"" and pass1<>"" and pass2<>"" then
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("../试题库.mdb")
set rs= server.createobject("adodb.recordset")
if pass1<>pass2 then
response.write "两次密码不一致！"
else
select case request.querystring("quanxian")
case "题库维护用户":
sql= "select * from 单位记录 where 用户名='"& name &"' and 密码='"& pass1 &"'"
case "超级用户":
sql= "select * from 超级用户 where 用户名='"& name &"' and 密码='"& pass1 &"'"
case else
sql= "select * from 用户记录 where 用户名='"& name &"' and 密码='"& pass1 &"'"
end select
Set rs= conn.Execute(sql)
if not rs.eof then
select case request.querystring("quanxian")
case "题库维护用户":
sql="DELETE FROM 单位记录 where 用户名='"& name &"' and 密码='"& pass1 &"'"
case "超级用户":
sql="DELETE FROM 超级用户 where 用户名='"& name &"' and 密码='"& pass1 &"'"
case else
sql="DELETE FROM 用户记录 where 用户名='"& name &"' and 密码='"& pass1 &"'"
end select
conn.execute(sql)
conn.close
response.redirect "idmanage.asp"
else
Response.Write "无此用户！"
end if
end if
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>删除帐号</title>
<meta name="GENERATOR" content="Microsoft FrontPage 3.0">
<meta NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
</head>
<body background="../images/1024.jpg">
<form action="DEL.asp" id="FORM1" method="get" name="FORM1">
<table border="0" width="100%">
<tr>
<th width="100%"><table border="0" width="100%">
<tr>
<th width="100%"><img src="../Images/back.gif" alt="../背景.gif (87350 bytes)"></th>
</tr>
</table>
</th>
</tr>
</table>
<div align="center"><center><h2 title>用户名： <input id="text1" name="name"
style="HEIGHT: 22px; WIDTH: 100px" size="20"></h2>
</center></div><div align="center"><center><h2 title>口 令： <input
id="password1" name="pass1" style="HEIGHT: 22px; WIDTH: 100px" type="password" size="20"></h2>
</center></div><div align="center"><center><h2 title>确 认： <input
id="password1" name="pass2" style="HEIGHT: 22px; WIDTH: 100px" type="password" size="20"></h2>
</center></div><div align="center"><center>
<h2 title>用户权限:
<select size="1" name="quanxian">
<option value="一般用户" selected>一般用户
<option value="题库维护用户">题库维护用户
<option value="超级用户">超级用户
</select></h2>
</center></div><table border="0" width="100%">
<tr>
<td width="100%" checked="false"></td>
</tr>
</table>
<div align="center"><center><p title><input id="submit1" name="submit1" type="submit"
style="font-size: large; font-style: normal; font-variant: normal; font-weight: bold; background-image: url('../Images/enter3.bmp'); background-repeat: no-repeat; background-position: center 50%"
title value=" "></p>
</center></div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -