updateperson.asp

来自「Java移动通信程序设计」· ASP 代码 · 共 50 行

ASP
50
字号
<HTML>

<BODY>

<%
  
Set cnnDB = Server.CreateObject("ADODB.Connection")


cnnDB.Open "MIDPDB"

delSQL = "DELETE * FROM person where name = '" & request("txtName") & "'"
cnnDB.Execute delSQL


newSQL = "INSERT INTO person(name, email,age)  values('" &_
              Request("txtName") & "','" &_
                         Request("txtEMail") & "','" &_
                         Request("txtAge") & "')"
                         
cnnDB.Execute newSQL

set records = Server.CreateObject("ADODB.Recordset")
records.Open "person",cnnDB
records.close

querySQL = "SELECT * FROM person where name='" & request("txtName") & "'"
records.Open querySQL,cnnDB
  
  Response.Write "Name:"
  Response.Write records("name")
  Response.Write "<br>"
  Response.Write "E Mail:"
  Response.Write records("email")
  Response.Write "<br>"
  Response.Write "Age:"  
  Response.Write records("age")

Response.Write "update ok"

records.close
set records = nothing
cnnDB.Close
set cnnDB = nothing

%>

</BODY>
</HTML>

⌨️ 快捷键说明

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