sapw.asp
来自「《动态网页设计基础教程》,胡杰,科学出版社」· ASP 代码 · 共 70 行
ASP
70 行
<html>
<head>
<link rel="stylesheet" href="comCSS.css">
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>口令修改</title>
<meta name="Microsoft Border" content="t, default">
</head>
<body><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><td>
<p align="left"> </p>
</td></tr><!--msnavigation--></table><!--msnavigation--><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr><!--msnavigation--><td valign="top">
<%
dim sql
dim t1,t2,t3
Certificate()
t1=request.form("T1")
t2=request.form("T2")
t3=request.form("T3")
t4=request.form("T4")
if t3<>t4 then
response.write "新口令有误,请重新输入新口令!"
else
set Conn=Server.CreateObject("ADODB.Connection")
'Conn.open session("sysDSN")
'conn,open session("mydb")
conn.open "Driver={SQL Server};Database=testonline;Server=(local);uid=sa;pwd="
sql="select * from dba where dbaCode='" + t1 + "' and dbaPW= '" + t2 + "'"
set rs=Server.CreateOBject("ADODB.Recordset")
rs.open sql,conn,1,2,1
if not rs.eof then
set rs=nothing
sql ="Update dba SET dbaPW='" + t3 +"'" + "where dbaCode='" + t1 + "'"
set ret=Server.CreateOBject("ADODB.Recordset")
set ret=conn.execute (sql)
response.write "新口令修改完成!"
set ret=nothing
else
response.write "原口令输入错误!"
end if
set conn=nothing
end if
%>
<a href="javascript:history.back(1)">返回</a>
<!--msnavigation--></td></tr><!--msnavigation--></table></body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?