_javascript techniques for manipulating MySQL database instances in JavaScript

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, specific configuration please refer to: http://www.connectionstrings.com/
//If you do not know how to configure the connection string, you can configure the UDL file with a text editor to open to get
var ConnectionString = "Driver={mysql ODBC 5.2w Driver}; Server=localhost;database=mydatabase; User=myusername; password=mypassword;option=3; port=3306 ";
Open Connection
Conn.Open (connectionstring);
 
Query statement
var sql = "Select * from Tb_col";
Open the dataset (that is, execute the query statement)
Rs.Open (sql,conn);
(or Rs=conn.execute (SQL);)
//Traverse all records
while (!rs.eof) {
 //wscript is a script Host object for Windows, please find in Windows Help for details.
 //wscript.echo The contents
 of the output record WScript.Echo (Rs. Fields ("id") + "\ T" + Rs. Fields ("name") + "\ n");
 
 Next record
 rs.movenext ();
}
Close recordset
rs.close ();
Close database connection
conn.close ();
} catch (e) {
//Exception Report
WScript.Echo (E.message);
} finally{
//
}