Code for using javascript to operate ACCESS database (read, add, modify and delete) under static pages_javascript skills

Static page reads ACCESS database.htm

Copy code The code is as follows: //Use JavaScript to write code examples for server-side connection to the database 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 = " "; shtml =" &lt ;td>au_id au_lname au_fname "; while(!rs.EOF) { shtml = " " rs("friend_id") " " rs("friend_name") " " rs("friend_nickname ") " "; rs.moveNext; } shtml = " "; document.write(shtml); rs.close(); rs = null; conn.close(); conn = null;

Add data Go to the database page-Insert.htm

Copy the code The code is as follows: friend_name friend_nickname

function editmdb(username ,nickname) { //Use JavaScript to write a code example for server-side connection to the database 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("Added successfully"); }

Delete function -Delete.htm

Copy code The code is as follows: //function deldata(userid) //{ // Use JavaScript to write a code example for server-side connection to the database 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("Modification successful");

//} function getdata() { //Use JavaScript to write code examples for server-side connection to the database 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 = " "; shtml =" friend_id friend_name friend_nickname "; while(!rs.EOF) { shtml = " " rs("friend_id") " " rs("friend_name") " " rs("friend_nickname") " "; shtml = " " rs("friend_id" ) " "; rs.moveNext; } shtml = " "; document.write(shtml); rs.close(); rs = null; conn.close(); conn = null; } getdata()

function editmdb(userid,username,nickname) { //Use JavaScript to write a code example for server-side connection to the database 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("Modification successful"); getdata() }

Code for using javascript to operate ACCESS database (read, add, modify and delete) under static pages_javascript skills

Related articles