您的当前位置：首页正文

js连接数据库总结

来源：好兔宠物网

varstrConnString = \"Provider=OraOLEDB.Oracle;Data Source=cpt_d;User ID=john;Password=doe;PLSQLRset=1 \"

var conn = new ActiveXObject( \"ADODB.Connection \"); conn.open(strConnString);

varrs = conn.execute( \"SELECT * FROM Yourtable \"); while (!rs.EOF) {

for (int i=0; i alert(rs.fields(i).name + \": \" + rs.fields(i).value); }

rs.moveNext(); }

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

CREATE TABLE relatrec_feat ( machID VACHAR )

INSERT INTO routes (machID,r_x,r_y) values (num1,108.95345,34.265865); INSERT INTO routesvalues (‘num1’,’108.922836’,’34.249574’);

INSERT INTO routes (machID,r_x,r_y) values (num1,108.990532,34.253573);

因篇幅问题不能全部显示，请点此查看更多更全内容

查看全文