把下面这些 放在INC 文件当中就可以咯。 var oraSession;
var oraDatabase;
var oraDynaset;
function oraInit(){
oraSession=new ActiveXObject("OracleInProcServer.XOraSession");
oraDatabase=oraSession.DbOpenDatabase("ora","ora_user/ora_pwd",0);
} function oraSql( sql ){
oraDynaset=oraDatabase.DbCreateDynaset( sql,0 );
}
function oraSqlExec( sql ){
oraDatabase.DbExecuteSQL( sql );
oraDatabase.DbExecuteSQL( "commit" );
}
function oraClose(sql){
delete oraDynaset;
delete oraDatabase;
delete oraSession;
}
var oraDatabase;
var oraDynaset;
function oraInit(){
oraSession=new ActiveXObject("OracleInProcServer.XOraSession");
oraDatabase=oraSession.DbOpenDatabase("ora","ora_user/ora_pwd",0);
} function oraSql( sql ){
oraDynaset=oraDatabase.DbCreateDynaset( sql,0 );
}
function oraSqlExec( sql ){
oraDatabase.DbExecuteSQL( sql );
oraDatabase.DbExecuteSQL( "commit" );
}
function oraClose(sql){
delete oraDynaset;
delete oraDatabase;
delete oraSession;
}
如果没有,请先做好这一步
sql="select * from w_bagua_top";
oraSql(sql);oraClose(sql);