com.irisel.oms.dbh
Class DbhMySql

java.lang.Object
  com.irisel.oms.dbh.Dbh
      com.irisel.oms.dbh.DbhMySql

All Implemented Interfaces:

DBHandler

public class DbhMySql
extends Dbh

Field Summary

Fields inherited from class com.irisel.oms.dbh.Dbh

KEY_FETCH_SIZE

Method Summary

boolean	begin()
void	close() For data source-based implementations that need to return the connection to a pool after each operation.
boolean	commit()
void	connect(java.lang.String url)
java.lang.String	makeURL(java.lang.String host, java.lang.String port, java.lang.String db, java.lang.String user, java.lang.String pass) Constructs URL following the format accepted by the corresponding JDBC driver
boolean	rollback()

Methods inherited from class com.irisel.oms.dbh.Dbh

connect, connect, connect, disconnect, execute, execute, executeQuery, executeQuery, executeQuery, executeUpdate, executeUpdate, finalize, getBlob, getConnection, getDatabaseMetaData, getDbName, getDbPasswd, getDbUser, getHost, getPort, getSchema, getTableNames, getTables, isConnected, loadDriver, reconnect, ResultSetToText, ResultSetToVector, saveBlob, setDbName, setDbPasswd, setDbUser, setHost, setPort, setSchema, toString

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Method Detail

makeURL

public java.lang.String makeURL(java.lang.String host,
                                java.lang.String port,
                                java.lang.String db,
                                java.lang.String user,
                                java.lang.String pass)

Description copied from class: Dbh

Constructs URL following the format accepted by the corresponding JDBC driver

Specified by:

makeURL in class Dbh

begin

public boolean begin()
              throws java.sql.SQLException

Specified by:

begin in interface DBHandler

Overrides:

begin in class Dbh

Throws:

java.sql.SQLException

commit

public boolean commit()
               throws java.sql.SQLException

Specified by:

commit in interface DBHandler

Overrides:

commit in class Dbh

Throws:

java.sql.SQLException

rollback

public boolean rollback()

Specified by:

rollback in interface DBHandler

Overrides:

rollback in class Dbh

connect

public void connect(java.lang.String url)
             throws ConnectionException

Specified by:

connect in interface DBHandler

Specified by:

connect in class Dbh

Throws:

ConnectionException

close

public void close()

Description copied from class: Dbh

For data source-based implementations that need to return the connection to a pool after each operation.

Specified by:

close in interface DBHandler

Specified by:

close in class Dbh