db/DBConnection.h

#ifndef _DBCONNECTION_H_
#define _DBCONNECTION_H_

#include<occi.h>
#include<stdio.h>
#include<iostream>
#include "../Exceptions/Exception.h"

using namespace oracle::occi;
using namespace std;
using namespace ILCException;

class DBConnection{
  
 private:
  string database;
  string user;
  string password;
  Environment *env;
  Connection *conn;

  static DBConnection* handle;
  DBConnection();
  
 public:
  static DBConnection* getConnection();
  ~DBConnection();

  void setUser(string u);
  void setPassword(string p);
  void setDatabase(string d);

  bool isConnected();
  void connect();

  void disconnect();

  Statement* createStatement(string q);

  
  void terminateStatement(Statement* s);

  void commit();

  void rollback();

  Clob* createClob();

};
#endif

---