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       
%>
&nbsp;&nbsp;&nbsp;
<a href="javascript:history.back(1)">返回</a> 
 
<!--msnavigation--></td></tr><!--msnavigation--></table></body>        
</html>        
 
 


⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?