occi.cpp

occi连接oracle数据库,连接

include "StdAfx.h"
#include "OcciDB.h"
#include "windows.h"



COcciDB::COcciDB(void)
{
	env = Environment::createEnvironment(Environment::DEFAULT );	
}

COcciDB::~COcciDB(void)
{
    if(conn)	
	   env->terminateConnection (conn);	
    Environment::terminateEnvironment (env);
}

void COcciDB::setServiceName(string service)
{
	serviceName=service;	
}

bool COcciDB::connectToDatabase()
{  
	 try{		
          conn= env->createConnection ("test","test",serviceName);
	 }catch(SQLException &e){
		 ::AfxMessageBox((CString)e.what());
		 return false;
	 } 	
	 return false;
}
void COcciDB::setsqlStatement(std::string sql)
{
     sqlStmt=sql;	
}

ResultSet* COcciDB::executeQuery(void)
{
  ResultSet *rs; 
  try{  
        stmt=conn->createStatement(sqlStmt);   
        rs=stmt->executeQuery();		
   }catch(exception &e){
	 ::AfxMessageBox(((CString)(e.what()));
	 rs=NULL;
   } 
  return rs;
}

bool COcciDB::executeSql(void)
{
  bool flag; 
  try{  
        stmt=conn->createStatement(sqlStmt); 		
		stmt->executeUpdate();        
        flag=true;
  }catch(exception &e){	  
	    ::AfxMessageBox(((CString)(e.what()));         
	    flag=false; 
  }
  CloseStmt();
  return flag;  
}