本文来源:http://www.jb51.net/article/9960.htm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title> New Document </title> <meta name="Generator" content="EditPlus"> <meta name="Author" content=""> <meta name="Keywords" content=""> <meta name="Description" content=""> <script language="javascript"> //转载 //http://www.jb51.net/article/9960.htm function editmdb(name,amount) { //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=E:\\db1.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); //var rs = new ActiveXObject("ADODB.Recordset"); var sql="insert into test(name,amount) values('" + name + "','" + amount + "')"; conn.execute(sql); conn.close(); conn = null; alert("添加成功"); location.reload(); } </script> </head> <body> <table> <tr> <td>姓名:</td> <td><input type="text" id="name" name="testname"/></td> </tr> <tr> <td>金额:</td> <td><input type="text" id="amount" name="amount"/></td> </tr> <tr> <td><button οnclick="editmdb(testname.value,amount.value)">保存</button></td> <td></td> </tr> </table> <script language="javascript"> //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=E:\\db1.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from test"; rs.open(sql, conn); shtml = "<table width='100%' border=1>"; shtml +="<tr bgcolor='#f4f4f4'><td>编号</td><td>姓名</td><td>金额</td></tr>"; while(!rs.EOF) { shtml += "<tr><td>" + rs("id") + "</td><td>" + rs("name") + "</td><td>" + rs("amount") + "</td></tr>"; rs.moveNext; } shtml += "</table>"; document.write(shtml); rs.close(); rs = null; conn.close(); conn = null; </script> </body> </html>