MMSDBMySQL Class Reference

#include <mmsdbmysql.h>

Inheritance diagram for MMSDBMySQL:

List of all members.


Public Member Functions

 MMSDBMySQL (DataSource *datasource=NULL, bool autoreconnect=false)
 Constructor.
virtual ~MMSDBMySQL ()
 Destructor.
void connect ()
 Connects to the mysql database.
void disconnect ()
 Disconnects from a mysql database.
void startTransaction ()
 Starts a transaction.
void commitTransaction ()
 Commits a transaction.
void rollbackTransaction ()
 Does a rollback on the current transaction.
int query (string statement, MMSRecordSet *rs)
 This function executes given database query and puts the results in MMSRecordSet.
int query (string statement)
 This function executes given database query.
int getLastInsertedID ()
 Returns the ID of the last inserted record.

Private Attributes

MYSQL dbhandle
bool autoreconnect

Detailed Description

Definition at line 58 of file mmsdbmysql.h.


Constructor & Destructor Documentation

MMSDBMySQL::MMSDBMySQL ( DataSource _datasource = NULL,
bool  autoreconnect = false 
)

Constructor.

It just sets the datasource and the reconnect parameters for later use in the connect() method.

Parameters:
_datasource [in] datasource object containing definitions for database connection
autoreconnect [in] if set to true, connection to the database server will be reestablished, if lost (needs mysql >= 5.0.13)
Exceptions:
MMSError No datasource given (Look at the exception message).
See also:
MMSDBMySQL::~MMSDBMySQL()

MMSError::getMessage()

Definition at line 65 of file mmsdbmysql.cpp.

MMSDBMySQL::~MMSDBMySQL (  )  [virtual]

Destructor.

Handles disconnection from the mysql database.

See also:
MMSDBMySQL::MMSDBMySQL()

Definition at line 79 of file mmsdbmysql.cpp.


Member Function Documentation

void MMSDBMySQL::connect (  )  [virtual]

Connects to the mysql database.

See also:
MMSDBMySQL::disconnect()

MMSError::getMessage()

Exceptions:
MMSError Error while trying to connect (Look at the exception message).

Implements IMMSDB.

Definition at line 150 of file mmsdbmysql.cpp.

void MMSDBMySQL::disconnect (  )  [virtual]

Disconnects from a mysql database.

See also:
MMSDBMySQL::connect()

Implements IMMSDB.

Definition at line 183 of file mmsdbmysql.cpp.

void MMSDBMySQL::startTransaction (  )  [virtual]

Starts a transaction.

If you are using transaction based queries, call this method to start a transaction. To commit it, call commitTransaction().

See also:
MMSDBMySQL::commitTransaction()

MMSError::getMessage()

Exceptions:
MMSError Error while trying to start transaction (Look at the exception message).

Implements IMMSDB.

Definition at line 95 of file mmsdbmysql.cpp.

void MMSDBMySQL::commitTransaction (  )  [virtual]

Commits a transaction.

If you are using transaction based queries, call this method to commit a transaction. To start it, call startTransaction().

See also:
MMSDBMySQL::startTransaction()

MMSError::getMessage()

Exceptions:
MMSError Error while trying to commit transaction (Look at the exception message).

Implements IMMSDB.

Definition at line 112 of file mmsdbmysql.cpp.

void MMSDBMySQL::rollbackTransaction (  )  [virtual]

Does a rollback on the current transaction.

If you are using transaction based queries, call this method to rollback a transaction.

See also:
MMSDBMySQL::startTransaction()

MMSDBMySQL::commitTransaction()

MMSError::getMessage()

Exceptions:
MMSError Error while trying to rollback the transaction (Look at the exception message).

Implements IMMSDB.

Definition at line 133 of file mmsdbmysql.cpp.

int MMSDBMySQL::query ( string  statement,
MMSRecordSet rs 
) [virtual]

This function executes given database query and puts the results in MMSRecordSet.

This method is used for select statements

Parameters:
statement [in] buffer with database query
rs [out] MMSRecordSet that holds the results
See also:
MMSRecordSet

MMSError::getMessage()

Returns:
Returns the number of affected rows
Exceptions:
MMSError Query couldn't be executed (Look at the exception message).

Implements IMMSDB.

Definition at line 208 of file mmsdbmysql.cpp.

int MMSDBMySQL::query ( string  statement  )  [virtual]

This function executes given database query.

This method is used for insert, update and delete statements

Parameters:
statement buffer with database query
See also:
MMSError::getMessage()
Returns:
Returns the number of affected rows
Exceptions:
MMSError Query couldn't be executed (Look at the exception message).

Implements IMMSDB.

Definition at line 261 of file mmsdbmysql.cpp.

int MMSDBMySQL::getLastInsertedID (  )  [virtual]

Returns the ID of the last inserted record.

Returns:
Returns the ID of the last inserted record
Exceptions:
MMSError Couldn't fetch last ID (Look at the exception message).

Implements IMMSDB.

Definition at line 293 of file mmsdbmysql.cpp.


Member Data Documentation

MYSQL MMSDBMySQL::dbhandle [private]

Definition at line 60 of file mmsdbmysql.h.

bool MMSDBMySQL::autoreconnect [private]

Definition at line 61 of file mmsdbmysql.h.


The documentation for this class was generated from the following files: