<mce:script language="javascript"><!-- //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=E://a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from friends_infor"; rs.open(sql, conn); shtml = "<table width='100%' border=1>"; shtml +="<tr bgcolor='#f4f4f4'><td>au_id</td><td>au_lname</td><td>au_fname</td></tr>"; while(!rs.EOF) { shtml += "<tr><td>" + rs("friend_id") + "</td><td>" + rs("friend_name") + "</td><td>" + rs("friend_nickname") + "</td></tr>"; rs.moveNext; } shtml += "</table>"; document.write(shtml); rs.close(); rs = null; conn.close(); conn = null; // --></mce:script> 详细出处参考:http://www.jb51.net/article/9960.htm <table width='100%' border=1> <tr bgcolor='#f4f4f4'><td>friend_name</td><td>friend_nickname</td></tr> <tr><td><input name=username id=username type=text value="" /></td> <td><input name=nickname id=nickname type=text value=""/></td></tr> </table> <mce:script language="javascript"><!-- function editmdb(username,nickname) { //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=E://a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="insert into friends_infor(friend_name,friend_nickname) values('" + username + "','" + nickname + "')"; //rs.open(sql, conn); //rs.close(); //rs = null; conn.execute(sql); conn.close(); conn = null; alert("添加成功"); } // --></mce:script> <input name="1" type="button" value="添加" οnclick="editmdb (username.value,nickname.value)"/> 详细出处参考:http://www.jb51.net/article/9960.htm <input name="1" type="button" value="修改" οnclick=""/> <mce:script language="javascript"><!-- //function deldata(userid) //{ //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=E://a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="delete from friends_infor where friend_id=135"; //rs.open(sql, conn); //rs.close(); //rs = null; conn.execute(sql); conn.close(); conn = null; alert("修改成功"); //} // --></mce:script> 详细出处参考:http://www.jb51.net/article/9960.htm 修改 <mce:script language="javascript"><!-- function getdata() { //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=E://a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="select * from friends_infor where friend_id=100"; rs.open(sql, conn); shtml = "<table width='100%' border=1>"; shtml +="<tr bgcolor='#f4f4f4'><td>friend_id</td><td>friend_name</td><td>friend_nickname</td></tr>"; while(!rs.EOF) { shtml += "<tr><td>" + rs("friend_id") + "</td><td>" + rs("friend_name") + "</td><td>" + rs("friend_nickname") + "</td></tr>"; shtml += "<tr><td>" + rs("friend_id") + "<input name=userid id=userid type=hidden value=" + rs("friend_id") + " /></td><td><input name=username id=username type=text value=" + rs("friend_name") + " /></td><td><input name=nickname id=nickname type=text value=" + rs("friend_nickname") + " /></td></tr>"; rs.moveNext; } shtml += "</table>"; document.write(shtml); rs.close(); rs = null; conn.close(); conn = null; } getdata() // --></mce:script> <mce:script language="javascript"><!-- function editmdb(userid,username,nickname) { //用 JavaScript 写服务器端连接数据库的代码示例 var conn = new ActiveXObject("ADODB.Connection"); conn.Open("DBQ=E://a.mdb;DRIVER={Microsoft Access Driver (*.mdb)};"); var rs = new ActiveXObject("ADODB.Recordset"); var sql="update friends_infor set friend_name='" + username + "',friend_nickname='" + nickname + "' where friend_id=" + userid + ""; //rs.open(sql, conn); //rs.close(); //rs = null; conn.execute(sql); conn.close(); conn = null; alert("修改成功"); getdata() } // --></mce:script> <input name="1" type="button" value="修改" οnclick="editmdb (userid.value,username.value,nickname.value)"/> 详细出处参考:http://www.jb51.net/article/9960.htm