包含前端 HTML 表單 (產品、數量、姓名、電話、Email、QQ、博客、銀行卡號)、後端參數化 INSERT、連線管理、編碼設定 (GB2312) 的完整單檔案範例,適合快速原型開發。
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<% Option Explicit %>
<%
If Request.Form("ag") <> "" Then
Dim conn, cmd, ag, amount, name2, tel, email, qq, bolg, blank
ag = Request.Form("ag")
amount = Request.Form("amount")
name2 = Request.Form("name")
tel = Request.Form("tel")
email = Request.Form("email")
qq = Request.Form("QQ")
bolg = Request.Form("bolg")
blank = Request.Form("blank")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../skyj.mdb")
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = "INSERT INTO 訂單 (訂單,數量,人名,電話,Email,QQ,博客,銀行卡號) VALUES (?,?,?,?,?,?,?,?)"
cmd.CommandType = 1
cmd.Parameters.Append cmd.CreateParameter("@p1", 200, 1, 50, ag)
cmd.Parameters.Append cmd.CreateParameter("@p2", 200, 1, 20, amount)
cmd.Parameters.Append cmd.CreateParameter("@p3", 200, 1, 50, name2)
cmd.Parameters.Append cmd.CreateParameter("@p4", 200, 1, 50, tel)
cmd.Parameters.Append cmd.CreateParameter("@p5", 200, 1, 100, email)
cmd.Parameters.Append cmd.CreateParameter("@p6", 200, 1, 20, qq)
cmd.Parameters.Append cmd.CreateParameter("@p7", 200, 1, 100, bolg)
cmd.Parameters.Append cmd.CreateParameter("@p8", 200, 1, 50, blank)
cmd.Execute
conn.Close
Set conn = Nothing
Response.Write ""
End If
%>
<!DOCTYPE html>
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>ASP Access 訂單新增</title>
</head><body>
<form method="POST" action="example5.asp">
<table>
<tr><td>產品</td><td><input name="ag"></td></tr>
<tr><td>數量(斤)</td><td><input name="amount"></td></tr>
<tr><td>姓名</td><td><input name="name"></td></tr>
<tr><td>電話</td><td><input name="tel"></td></tr>
<tr><td>Email</td><td><input name="email"></td></tr>
<tr><td>QQ</td><td><input name="QQ"></td></tr>
<tr><td>博客</td><td><input name="bolg"></td></tr>
<tr><td>銀行卡號</td><td><input name="blank"></td></tr>
</table>
<input type="submit" value="提交"> <input type="reset" value="重置">
</form>
</body></html>
On Error Resume Next 捕捉 cmd.Execute 失敗。CREATE TABLE 訂單 (
ID AUTOINCREMENT PRIMARY KEY,
訂單 TEXT(50),
數量 TEXT(20),
人名 TEXT(50),
電話 TEXT(50),
Email TEXT(100),
QQ TEXT(20),
博客 TEXT(100),
銀行卡號 TEXT(50),
建立時間 DATETIME DEFAULT NOW()
);