复制代码 代码如下: //连接SQL <BR> var conn = new ActiveXObject("ADODB.Connection"); <BR> conn.Open("Provider=SQLOLEDB.1; Data Source=tgf; User ID=sa; " <BR> +"Password=sasa; Initial Catalog=MyBulletin"); <BR> var rs = new ActiveXObject("ADODB.Recordset"); <BR> var sql="select id,name from Category"; <BR> rs.open(sql, conn);<BR> alert(rs(0));//取出第一个来<BR> rs.close(); <BR> rs = null; <BR> conn.close(); <BR> conn = null; <BR> 复制代码 代码如下: //连接ACCESS <BR> function conn(){<BR> var db_bbs<BR> db_bbs="dd.mdb"//定义数据库<BR> var conn = new ActiveXObject("ADODB.Connection"); <BR>conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+db_bbs+""); <br><br>var rs = new ActiveXObject("ADODB.Recordset"); <BR> var sql="select name from authors"; //数据库中有authors表，name字段<BR>rs.open(sql,conn);<BR> alert(rs(0))//取出第一个来 <P>conn.close(); <BR> conn = null; <BR>}<BR>
