在asp中,要处理表单中的数据,一般采用如上文kakaxi(初学到老)所说方式。
设表单页为a.htm,处理数据页为a.asp:
a.htm:
<form action ="a.asp" method ="post">
<table><tr>
<td>文本一<input type = "text" name = "text1"></td></tr><tr>
<td>文本二<input type = "password" name = "text2"></td></tr><tr>
<td cospan = "2" align="center"><input type="submit" value = "ok"></td></tr>
</table>
</form>
a.asp:
db="*.mdb" (此处是你的.mdb文件名。*自己改)
set conn=server.createobject("ADODB.connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("" & db & "")
conn.open connstr
(以上是建立了与*.mdb数据库的连接。access数据库都这样写,死记住就行了。)
dim rs
dim sql
set rs=Server.CreateObject("ADODB.Recordset") (建立recordset集)
sql="select * from table" (此处是sql查询语句。其中的table是关键字,在实际操作中不可写成table.)
rs.open sql,conn,3,3 (按sql语句操作数据库.后边两个数据如果不知道什么意思,通常填3,3就行了。)
<form action = "" method = "post name = "form1">
<table>
<td>用户名<td><input type = "text" name = "user_name"><tr>
<td>密 码<td><input type = "password" name = "password"><tr>
<td cospan = "2"><input type = "submit" value = "ok"><tr>
</table>
</form>
<%
if Request("user_name") <> "" then
Dim db,connstr,sql,rs
connstr = "DBQ="+server.mappath("yang_yang.mdb")+";DefaultDir=;DRIVER{Microsoft Access Driver (*.mdb)};"
set db = Server.CreateObject("ADODB.Connection")
db.Open connstr
set rs = server.createobject("adodb.recordset")
sqlstr = "select * from onine"
rs.open sqlstr,db,1,2
rs.AddNew
rs("user_name") = Requset("user_name")
rs("password") = Requset("password")
rs.Update
Response.Write "成功注册"
set rs = nothing
db.Close
set db = nothing
end if
%>