lib/BasicDML.hpp

Go to the documentation of this file.

//    <oraload - loads and gets lobs (Large Objects) into and out of an Oracle Database> 
//    Copyright (C) <2004-2007> <Ralf Duenkelmann>
//
//    This library is free software; you can redistribute it and/or modify it under the terms of the 
//    GNU Lesser General Public License as published by the Free Software Foundation; 
//    either version 2.1 of the License, or (at your option) any later version.
//
//    This library is distributed in the hope that it will be useful, 
//    but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS 
//    FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
//
//    You should have received a copy of the GNU Lesser General Public License along with this library; 
//    if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

#include <iostream>
#include <stdlib.h>
#include <fstream>
#include <cstdio>
#include <occi.h>
using namespace oracle::occi;
using namespace std;
#include "Connection.hpp"

#ifndef BASIC__DML_HPP
#define BASIC__DML_HPP

class BasicDML:public Conn
{
  private:
  Statement *stmt;  // Statement
  string sqlStmt;   // the sql itself with or without binds
  string bind[255]; // the bind values
  string bind_type[255]; // the bind datatypes

  public:
  
  BasicDML ();

  BasicDML (string user, string pass, string db);
  
  string displayRows (int selectCount,unsigned int bindCount);

  void setSQLStmt (string s);

  void setBind(int pos, string datatype , string wert) ;
  
  int InsertRow(string pSql);
  
  int InsertRow(void);
  
  void Commit(void);
  
  void Rollback(void);
};

#endif

---