by 好大一小白
2010.5.2 12:40
使用JavaScript操作数据库,这里主要介绍下主流的ACCESS,MSSQL,ORACLE三种数据库与JavaScript的连接问题.
var conn=new ActiveXObject("adodb.connection");
var rs=new ActiveXObject("Adodb.Recordset");
conn.Open("DBQ=\\path\*.mdb;DRIVER={Microsoft Access Driver (*.mdb)};");
var sql="select * from YOURTable ";
rs.open(sql, conn);
connstr="Provider=SQLOLEDB.1;User ID=sa;Password=suotian;Initial Catalog=linshi;Data Source=SUOTIAN-9Y1GMIF";
conn.open(connstr);
rs.LockType=rs.CursorType=1;
rs.ActiveConnection=connstr;
rs.Source="SELECT [column] FROM [YOURTable]";
rs.Open();
conn.open("DSN=YourDSN;UID=YourUID;PWD=YourPWD"); //or oledb connection string
rs = conn.execute("SELECT * FROM YOURTable");
while(!rs.EOF)
{
rs("column _name"); //读取字段值
}
rs.close();
rs = null;
conn.close();
conn = null;