deal_edit.asp

来自「好像是ASP实例导航中的进销存管理系统的源代码,忘了名」· ASP 代码 · 共 25 行

ASP
25
字号
<!-- #include file="protect.inc" -->
<!-- #include file="opendb.inc" -->
<html>
<head>
<title>修改注册处理</title>
</head>
<body>
<%
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open(sqlOpenDB)	 	'打开数据库

Sql0="Select * From Customer Where Name='" & Session("User") & "'" 
Set Rs=Conn.Execute(Sql0)
Sql1="Update Customer Set Password='" & Request.Form("Password") & "',Address='" & Request.Form("Address") & "',City='" & Request.Form("City") & "',Region='" & Request.Form("Region") & "',PostalCode='" & Request.Form("PostalCode") & "',Country='" & Request.Form("Country") & "',Phone='" & Request.Form("Phone") & "',Fax='" & Request.Form("Fax") & "',Email='" & Request.Form("Email") & "'" 
Conn.Execute(Sql1)			'修改用户注册信息
%>
<p><center><b>注册信息已修改。</b></center></p>
<%
Rs.Close
Set Rs=Nothing
Conn.Close
Set Conn=Nothing
%>
</body>
</html>

⌨️ 快捷键说明

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