UC知道asp数据添加
来源：百度知道 编辑：UC知道 时间：2024/05/30 23:31:35
<%
user=request("user")
email=request("email")
towho=request("towho")
content=request("content")
addtime=date()
set rs=server.createobject("adodb.recordset")
conn = "DBQ=" + server.mappath("message.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
sql="insert into mytable(user,email,towho,addtime,content) values('"&user&"','"&email&"','"&towho&"','"&addtime&"','"&content&"')"
rs.open conn,1,1
set rs=nothing
set conn=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('记录已添加！');" & "history.back()" & "</script>"
%>
user=request("user")
email=request("email")
towho=request("towho")
content=request("content")
addtime=date()
set rs=server.createobject("adodb.recordset")
conn = "DBQ=" + server.mappath("message.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
sql="insert into mytable(user,email,towho,addtime,content) values('"&user&"','"&email&"','"&towho&"','"&addtime&"','"&content&"')"
rs.open conn,1,1
set rs=nothing
set conn=nothing
response.write "<script language=JavaScript>" & chr(13) & "alert('记录已添加！');" & "history.back()" & "</script>"
%>
<%
user=request("user")
email=request("email")
towho=request("towho")
content=request("content")
addtime=date()
set conn=server.createobject("adodb.connection") '注意
conn = "DBQ=" + server.mappath("message.mdb") + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
sql="insert into mytable(user,email,towho,addtime,content) values('"&user&"','"&email&"','"&towho&"','"&addtime&"','"&content&"')"
conn.execute(sql) '注意
response.write "<script language=JavaScript>" & chr(13) & "alert('记录已添加！');" & "history.back()" & "</script>"
%>
rs.open conn,1,1 改为
set rs=conn.Execute(sql)