#ifndef _DB_H
#define _DB_H

#include "Init.h"
#include <ocicpp.h>

using namespace OCICPP;

class DB
{
public:
	DB(CWriteDateLog* in, string strName);
	virtual ~DB();
	
	static bool DbOpen(const char *tns, const char *user, const char *pwd);
	static Connection* GetConn(void){return m_pConn;} 
	static void DbClose(void){m_pConn->drop();fConnActive=false;}
	
	static bool Update(string strSQL);
	static bool Select(string strSQL, Cursor& cur);
	static void TransStart(void){if(fConnActive) m_pConn->transStart();};
	static void TransCommit(void){if(fConnActive) m_pConn->transCommit();}
	static void TransRollback(void){if(fConnActive) m_pConn->transRollback();}
protected:
	static string m_name;
	static string m_tns;
	static string m_user;
	static string m_pwd;	
	static bool fConnActive;
	static int m_iReConnCount;
	static Connection* m_pConn;
	static CWriteDateLog* m_pLog;
};
#endif