Set objXML = CreateObject("Msxml2.XMLHTTP") 或 Set objXML = CreateObject("Microsoft.XMLHTTP") 'Or for version 3.0 of XMLHTTP, use: 'Set objXML = Server.CreateObject("MSXML2.ServerXMLHTTP")
<body> <input type="text" name="userid"><br> <input type="text" name="username"><br> <input type="button" onclick="AddDatapost(document.all.userid.value,document.all.username.value)" value="AdddData"> </body> </html> ----------------------------------- ServerAdd.asp <%@LANGUAGE="JAVASCRIPT" CODEPAGE="936"%> <% function OpenDB(sdbname) { var connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath(sdbname); var conn=Server.CreateObject("ADODB.Connection"); conn.Open(connstr); return conn; }
var sResult=""; var oConn=OpenDB("UserInfo.mdb"); var userid=Request.Form("userid"); var username=Request.Form("username");
sResult="userid:"+userid+"\nusername:"+username+"\n 添加成功!"; var sql="insert into Users(UserID,UserName) values('"+userid+"','"+username+"')"; oConn.Execute(sql); Response.Write(sResult); %>