Mysql database instance in JavaScript, javascriptmysql

Mysql database instance in JavaScript, javascriptmysql

// Create a database connection object var conn = new ActiveXObject ("ADODB. connection "); // create a DataSet object var rs = new ActiveXObject (" ADODB. recordset "); try {// Database connection string. For detailed configuration, see connectionstring =" Driver = {MySQL ODBC 5.2 w Driver}; Server = localhost; Database = myDataBase; user = myUsername; Password = myPassword; Option = 3; Port = 3306 "; // open the connection conn. open (connectionstring); // query statement var SQL = "select * from tb_col"; // open the dataset (that is, execute the query syntax rs.open( SQL ,conn=((~rs=conn.exe cute (SQL);) // traverse all the records while (! Rs. eof) {// WScript is the host object of the Windows Script. For details, see windows Help. // WScript. echo output Record Content WScript. echo (rs. fields ("id") + "\ t" + rs. fields ("name") + "\ n"); // The next record rs. moveNext ();} // closes the record set rs. close (); // close the database connection conn. close ();} catch (e) {// WScript for exception reporting. echo (e. message);} finally {//}