db/zz_db.h

Go to the documentation of this file.

/* libzzdb
 *
 * This program is distributed under the GNU General Public License, version 2.
 * A copy of this license is included with this source.
 *
 * Copyright 2000-2006, Toni Thomsson <toni@tonjac.org> 
*/

#ifndef zz_db_h
#define zz_db_h

#include <zz_string.h>
#include <zz_log.h>
#include <zz_export.h>
#include <otl.h>

#define BEGIN_TRY try{
#define END_TRY      }

#define BEGIN_CATCH catch (otl_exception& e){ CzzDbException::m_LastExtException = e;
#define END_CATCH   }

/*********************************************************************
  Class: CzzSQLStream

 ********************************************************************/
class ZZ_API CzzSQLStream: public otl_stream
{
private:
    CzzLog  m_Log;

public:
    CzzSQLStream(otl_connect& db, const CzzString Stm, const short BufSize, int autocommit = 0);
    
    int RowCount(void);
    char* GetSqlStm(void);
    otl_cursor* GetCurrentCursor(void);
};

/*********************************************************************
  Class: CzzDb

 ********************************************************************/
class ZZ_API CzzDb
{
    static int m_cnt;

protected:
    otl_connect m_db;
    CzzString   m_SQL;

    CzzLog      m_Log;
       
public:
    CzzDb(const CzzString& db_user, int autocommit = 1);
    ~CzzDb();
    
    void Commit(void);
    void Rollback(void);
    
    void GetSysDate(char* sysdate);
    void GetDbUser(char *dbUser);
  
    CzzSQLStream* getStream( const CzzString& sql, const short bufsize );

    int m_AutoCommit;
};


#endif

---