javascript对数据库的操作

1、insert

var conn = new ActiveXObject( " ADODB.Connection " );
conn.Open( " Provider=SQLOLEDB;DataSource=xxs-oatest;UserID=sa;Password=sa;InitialCatalog=ExFlow " );
var sql = " insertintosms_temp(id,Name_Re,Name_Se,Text,Time_Se)values(' " + id + " ',' " + have_send_name + " ',' " + user_name + " ',' " + textbox[ 0 ].value + " ',' " + send_time + " ') " ;
var objrs = conn.Execute(sql);
objrs = null ;
conn = null ;

2、delete、update操作与insert操作类似，只需修改sql语句即可。
3、select

var conn = new ActiveXObject( " ADODB.Connection " );
conn.Open( " Provider=SQLOLEDB;DataSource=xxs-oatest;UserID=sa;Password=sa;InitialCatalog=ExFlow " );
var rs = new ActiveXObject( " ADODB.Recordset " );
var sql = " select*frommypower " ;
rs.open(sql,conn);
if ( ! rs.EOF)
... {
alert(rs("toget_power");
}

rs.close();
rs = null ;
conn.close();
conn = null ;