javaScript connect to database

Posted on 2009-07-04 filed under: AJAX (RSS) 350 views

js connect to database
Key words: js connected database, javascript connection database, js operation database, js read a database, javascript link data
Database on the Desktop
<script language="javascript">
/ / Use javascript to write server-side sample code to connect database
function conn () (
var db_bbs
db_bbs = "dd.mdb" / / definition of a database
var conn = new ActiveXObject ( "ADODB.Connection");
conn.Open ( "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =" + db_bbs +"");

var rs = new ActiveXObject ( "ADODB.Recordset");
var sql = "select name from authors"; / / database in the authors table, name field
rs.open (sql, conn);
alert (rs (0)) / / Remove the first to

conn.close ();
conn = null;
)
</ script>
The following is the sql connection
<script language="javascript">
/ / Use javascript to write server-side sample code to connect database
var conn = new ActiveXObject ( "ADODB.Connection");
conn.Open ( "Provider = SQLOLEDB.1; Data Source = localhost; User"
+ "Password =; Initial Catalog = pubs");
var rs = new ActiveXObject ( "ADODB.Recordset");
var sql = "select * from authors";
rs.open (sql, conn);

rs.close ();
rs = null;
conn.close ();
conn = null;
</ script>