Role JavaScript access and manipulate databases

JS Operation Access Database

JS Code

2. <script language="JavaScript" >
4. <!--
6. var filePath = location.href.substring (0, Location.href.indexOf ("instance 197. Connect to an Access database. html")); //Based on the current paging file, find the absolute path where the file resides
8. var path = FilePath + "197.mdb";
10. Path = path.substring (8);
12. var objdbconn = new ActiveXObject ("ADODB.         Connection ");
14. var strdsn = "Driver={microsoft Access driver (*.mdb)};d bq=" + path;
16. Objdbconn.open (STRDSN);
18. document.write ("Connection to Access database successfully!<br>");
20. Objdbconn.close ();
22. -
24. </SCRIPT>

Connecting to a SQL Server database

JS Code

1. <script language= "JavaScript" >  
2. <!--  
3. var objdbconn = new activexobject (" ADODB. Connection ");     
4. var strdsn  =  "driver={sql server}; server= (local); Uid=sa; Pwd=111111;database=hljdatabase ";     
5. objdbconn.open (STRDSN);        
6. document.write (
7. objdbconn.close ();                      
8. //-->&NBSP;&NBSP;
9. </script>  

Querying a DB instance

JS Code

2. <script language="JavaScript" >
4. <!--
6. var objdbconn = new ActiveXObject ("ADODB.    Connection ");
8. var strdsn = "Driver={sql Server}; server= (local); Uid=sa;      Pwd=111111;database=hljdatabase "; //need to modify your server address, username, password
10. Objdbconn.open (STRDSN);
12. var objRS = Objdbconn.execute ("select * FROM table where association = 0"); //Enter a local table
14. var fdcount = objRS. fields.count-1;
16. if (!objrs. EOF) {
18. document.write ("<table border=1><tr>");
20. For (var i=0; I <= fdcount; i++)
22. document.write ("<td><b>" + objRS. Fields (i).  Name + "</b></td>");
24. document.write ("</tr>");
28. While (!objrs. EOF) {
30. document.write ("<tr>");
32. For (i=0; I <= fdcount; i++)
34. document.write ("<td valign= ' top ' >" + objRS. Fields (i).  Value + "</td>");
36. document.write ("</tr>");
38. Objrs.movenext ();
40. }
42. document.write ("</table>");
44. }
46. Else
48. document.write ("No records!<br> in the database");
50. objRS. Close ();
52. Objdbconn.close ();
54. -
56. </SCRIPT>

Manipulating Database instances

JS Code

2. <script language="JavaScript" >
4. <!--
6. var objdbconn = new ActiveXObject ("ADODB.    Connection ");
8. var strdsn = "Driver={sql Server}; server= (local); Uid=sa;   Pwd=111111;database=hljdatabase "; //need to modify your server address, username, password
10. Objdbconn.open (STRDSN);
12. Objdbconn.execute ("UPDATE table Set association = 0"); //write your own statement of execution
14. document.write ("Update data successfully!<br>");
16. Objdbconn.close ();
18. -
20. </SCRIPT>