首頁猿問如何利用原生的js實現(xiàn)基本的增刪改查功能

如何利用原生的js實現(xiàn)基本的增刪改查功能

JavaScript

慕桂英546537 2019-03-27 18:17:18

查看完整描述

4 回答

躍然一笑

TA貢獻(xiàn)1826條經(jīng)驗獲得超6個贊

//創(chuàng)建數(shù)據(jù)庫連接對象
var conn = new ActiveXObject("ADODB.Connection");
//創(chuàng)建數(shù)據(jù)集對象
var rs = new ActiveXObject("ADODB.Recordset");
try{
var connectionstring = "Driver={MySQL ODBC 5.2w Driver};Server=localhost;Database=myDataBase;User=myUsername; Password=myPassword;Option=3;Port=3306";
conn.open(connectionstring);
var sql = " select * from tb_col ";//顯然這里可以改成insert\update
//執(zhí)行查詢
rs.open(sql,conn);//(或者rs=conn.execute(sql);)
while(!rs.eof){
//WScript是Windows 的腳本宿主對象
WScript.Echo(rs.Fields("id") + "\t" + rs.Fields("name") + "\n");
//下一條記錄
rs.moveNext();
}
rs.close();
conn.close();
} catch(e){
WScript.Echo(e.message);
} finally{
rs.close();
conn.close();
}