📄 updateperson.asp

📁 Java移动通信程序设计(J2ME MIDP)范例

💻 ASP

字号:

<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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -