#include<iostream>
#include<occi.h>


using namespace oracle::occi;
using namespace std;

class occidml
{
private:
	Environment *env;
	Connection *conn;
	Statement *stmt; 
public:
	occidml(string user, string passwd, string db)
	{
		env=Environment::createEnvironment(Environment::DEFAULT);
		conn=env->createConnection(user,passwd, db);
	}
	
	~occidml()
	{
		env->terminateConnection(conn);
		Environment::terminateEnvironment(env);
	}
	
	void displayAllRows()
	{
			string sqlStmt="select * from tcm_rate_area where rownum<50";
			stmt=conn->createStatement(sqlStmt);
			ResultSet *rset=stmt->executeQuery();
			try{
				while(rset->next()){
					cout<< rset->getString(1)<<"\t"<<rset->getInt(2)<<endl;					
					}
				}catch(SQLException ex){
					cout<< "Exception\t"
						<<ex.getErrorCode()<<"\t"
						<<ex.getMessage()<<endl;
					}
					stmt->closeResultSet(rset);
					conn->terminateStatement(stmt);
	}
};
	
	
	int main(void){
		string usr="TEST";
		string pass="TEST";
		string db="TESTDB";
		cout<<"hello this is rakesh";

		occidml *demo=new occidml(usr,pass, db);
		demo->displayAllRows();  

		/*Environment *env1 ;
		Connection *conn;

		env1=Environment::createEnvironment(Environment::DEFAULT);
		Connection *conn=env1->createConnection("STLIUC", "STLIUC","IAD");  */


		return 0;
		}