newperson.asp

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

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


cnnDB.Open "MIDPDB"

'Response.Write request("txtName")
'Response.Write "\n"
'Response.Write request("txtEMail")
'Response.Write "\n"
'Response.Write request("txtAge")

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

'Response.Write newSQL
'Response.Write "\n"
Response.Write "appending ok"

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

%>