spo.src.SPDB.dbAdapter
Class MySQLAdapter

java.lang.Object
  |
  +--spo.src.SPDB.dbAdapter.AbstractDatabase
        |
        +--spo.src.SPDB.dbAdapter.MySQLAdapter

public class MySQLAdapter

extends AbstractDatabase

The MySQL db adapter implementation.

Constructor Summary

MySQLAdapter()

Method Summary

int	createSequence(DBUtil dbutil, java.lang.String tableName) Create a sequence
int	dropSequence(DBUtil dbutil, java.lang.String tableName) Drop the sequence
java.lang.String	getDateTimeFunction() The MySQL's function name that gets the current date and time from the database server: "sysdate()"
java.lang.String	getIsNULLFunction() The MySQL's function name that is used to return non-NULL value
java.lang.String	getStringDelimiter() The MySQL's string delimiter character: single quote (')
int	getUniqueID(DBUtil dbutil, java.lang.String tableName) The MySQL unique ID generator through use of the constraint Auto Increment for a unique field(i.e primary key).
int	getUniqueRID(DBUtil dbutil, java.lang.String tableName)

Methods inherited from class spo.src.SPDB.dbAdapter.AbstractDatabase

createObject, main

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MySQLAdapter

public MySQLAdapter()

Method Detail

createSequence

public int createSequence(DBUtil dbutil,
                          java.lang.String tableName)
                   throws java.sql.SQLException

Description copied from class: AbstractDatabase

Create a sequence

Specified by:

createSequence in class AbstractDatabase

Parameters:

tableName - name of the table

java.sql.SQLException

dropSequence

public int dropSequence(DBUtil dbutil,
                        java.lang.String tableName)
                 throws java.sql.SQLException

Description copied from class: AbstractDatabase

Drop the sequence

Specified by:

dropSequence in class AbstractDatabase

Parameters:

tableName - name of the table

java.sql.SQLException

getUniqueID

public int getUniqueID(DBUtil dbutil,
                       java.lang.String tableName)
                throws java.sql.SQLException

The MySQL unique ID generator through use of the constraint Auto Increment for a unique field(i.e primary key).

Specified by:

getUniqueID in class AbstractDatabase

Parameters:

tableName - the name of table

java.sql.SQLException

getUniqueRID

public int getUniqueRID(DBUtil dbutil,
                        java.lang.String tableName)
                 throws java.sql.SQLException

Specified by:

getUniqueRID in class AbstractDatabase

java.sql.SQLException

getDateTimeFunction

public java.lang.String getDateTimeFunction()

The MySQL's function name that gets the current date and time from the database server: "sysdate()"

Specified by:

getDateTimeFunction in class AbstractDatabase

Returns:

return the current date and time function name: "sysdate()"

getIsNULLFunction

public java.lang.String getIsNULLFunction()

The MySQL's function name that is used to return non-NULL value

Specified by:

getIsNULLFunction in class AbstractDatabase

Returns:

return the non-NULL function name: "ISNULL()"

getStringDelimiter

public java.lang.String getStringDelimiter()

The MySQL's string delimiter character: single quote (')

Specified by:

getStringDelimiter in class AbstractDatabase

Returns:

return the string delimiter: single quote (')