#include <iostream>	   
#include <occi.h>	   
	   
using namespace oracle::occi;	   
using namespace std;	   
	   
int main (void)	   
{	   
	   
  //Environment und Connection erzeugen	   
  Environment* env = Environment::createEnvironment();	   
  Connection* conn = env->createConnection( "scott", "tiger"	   
                                          , "cornel" );	   
  cout << "Environment und Connection erzeugt" << endl;	   
	   
  //SQL-Statement erzeugen	   
  Statement* stmt = conn->createStatement();	   
  cout << "Statement erzeugt" << endl;	   
	   
  //DML: INSERT	   
  stmt->setSQL("INSERT INTO dept (deptno, dname, loc) \	   
                VALUES (80,'SALES EMEA','FRANKFURT')");	   
  stmt->executeUpdate();	   
  cout << "Record inserted" << endl;	   
	   
  //DML: UPDATE	   
  stmt->setSQL("UPDATE dept SET dname = 'SALES EU', \	   
                loc = 'COLOGNE' WHERE deptno = 80");	   
  stmt->executeUpdate();	   
  cout << "Record updated" << endl;	   
	   
  //DML: DELETE	   
  stmt->setSQL("DELETE FROM dept WHERE deptno = 80");	   
  stmt->executeUpdate();	   
  cout << "Record deleted" << endl;	   
	   
  //DML: SELECT	   
  stmt->setSQL("SELECT empno, ename from emp");	   
	   
  ResultSet *rset = stmt->executeQuery();	   
	   
  while (rset->next()) //solange Ergebniszeilen da, auslesen	   
  {	   
    cout << "EMPNO: " << rset->getInt(1) << "  ENAME: "	   
         << rset->getString(2) << endl;	   
  }	   
	   
  stmt->closeResultSet (rset);	   
	   
  conn->terminateStatement(stmt);	   
  cout << "Statement beendet" << endl;	   
	   
  //Environment und Connection beenden	   
  env->terminateConnection(conn);	   
  Environment::terminateEnvironment(env);	   
  cout << "Environment und Connection beendet" << endl;	   
	   
}