BasicDML Class Reference

#include <BasicDML.hpp>

Inheritance diagram for BasicDML:

Conn Log Lob BinLob CharLob List of all members.

Public Member Functions

 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)

Private Attributes

Statement * stmt
string sqlStmt
string bind [255]
string bind_type [255]

Detailed Description

BasicDML

-----------

Basic DML methods

Author: Ralf Duenkelmann

Date : 01.06.2004


Constructor & Destructor Documentation

BasicDML::BasicDML (  ) 

Def Constructor

BasicDML::BasicDML ( string  user,
string  pass,
string  db 
)

Constructor

Parameters:
user username of Database
pass password
db the database alias


Member Function Documentation

string BasicDML::displayRows ( int  selectCount,
unsigned int  bindCount 
)

displayRows

execute and display the result of a select

Parameters:
selectCount number of select attributes
bindCount number of binds in select
Returns:
the result as string

void BasicDML::setSQLStmt ( string  s  ) 

setSQLStmt

set the SQL to be executed

Parameters:
s the SQL

void BasicDML::setBind ( int  pos,
string  datatype,
string  wert 
)

setBind

set a Bind

Parameters:
pos the position in SQL
datatype the datatype of the bind, valid are "string" and "int" at the moment
wert the actual value of the bind

int BasicDML::InsertRow ( string  pSql  ) 

InsertRow

use InsertRow for updates, inserts etc, which do not return values

Parameters:
pSql the SQL

int BasicDML::InsertRow ( void   ) 

InsertRow

use InsertRow for updates, inserts etc, which do not return values

void BasicDML::Commit ( void   ) 

Commit

void BasicDML::Rollback ( void   ) 

Rollback


Member Data Documentation

Statement* BasicDML::stmt [private]

string BasicDML::sqlStmt [private]

string BasicDML::bind[255] [private]

string BasicDML::bind_type[255] [private]


The documentation for this class was generated from the following files:
Generated on Wed Jun 6 17:56:27 2007 for LobShooter for Oracle (oraload) by  doxygen 1.5.1