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 + -
显示快捷键?