js 连接数据库如何操作数据库中的数据
 //连接SQL 
//连接ACCESS
   代码如下:
<script language="javascript"> 
var conn = new ActiveXObject("ADODB.Connection"); 
conn.Open("Provider=SQLOLEDB.1; Data Source=tgf; User ID=sa; " 
+"Password=sasa; Initial Catalog=MyBulletin"); 
var rs = new ActiveXObject("ADODB.Recordset"); 
var sql="select id,name from Category"; 
rs.open(sql, conn); 
alert(rs(0));//取出第一个来 
rs.close(); 
rs = null; 
conn.close(); 
conn = null; 
</script> //连接ACCESS
代码如下:
<script language="javascript"> 
function conn(){ 
var db_bbs 
db_bbs="dd.mdb"//定义数据库 
var conn = new ActiveXObject("ADODB.Connection"); 
conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+db_bbs+""); 
var rs = new ActiveXObject("ADODB.Recordset"); 
var sql="select name from authors"; //数据库中有authors表,name字段 
rs.open(sql,conn); 
alert(rs(0))//取出第一个来 
conn.close(); 
conn = null; 
} 
</script> 相关推荐
  lbyd0    2020-11-17  
   腾讯soso团队    2020-11-06  
   yangkang    2020-11-09  
   KANSYOUKYOU    2020-11-16  
   wushengyong    2020-10-28  
   Apsaravod    2020-11-05  
   PeterChangyb    2020-11-05  
   gyunwh    2020-11-02  
 