DatabaseProperties (Bradley Ross Examples)

java.lang.Object
- bradleyross.library.database.DatabaseProperties

Direct Known Subclasses:

DatabaseConnection, DatabaseInstance
```
public abstract class DatabaseProperties
extends Object
```
Supports usage of databases via JDBC (Java DataBase Connection) protocol.
This is an abstract class and can't be used directly in the creation of objects. This means that subclasses must be created.

When creating subclasses, many fields will have to be set, including handlerClass, accountName, connectionString, and password.

By including the objects for the JDBC connection and statement, it is possible to encapsulate a large amount of the code for the database connectivity.

Please note that the methods in this class do not include one for obtaining the password used in connecting to the database. If required, this method can be added in the subclass. Eliminating this method adds to the security of the system. By encapsulating the password in a field in this class for use by the connect method, there is no need for other classes to have access to the information.

SQL Server notes
- Wants the string dbo. in front of table names.
- Specify the default database as part of the user configuration rather than including it in the connection string.
Oracle notes
- Will not accept semicolons at the end of SQL statements.
MySQL notes
Author:

Bradley Ross

Field Summary

Fields
Modifier and Type	Field and Description
`protected String`	`accountName` The account name to be used on the database server.
`protected boolean`	`autoCommit` True indicates that autoCommit is set for this database connection when the connection is opened.
`protected Connection`	`connection` The object representing the connection to the database.
`protected String`	`connectionString` The connection string to be used to connect to the database using JDBC (Java DataBase Connectivity)
`protected int`	`debugLevel` Amount of diagnostic messages.
`protected String`	`defaultCatalog` Default catalog for methods allowing the use of a default value.
`protected String`	`defaultEngine` When creating MySQL tables, this field can be used by the getEngineClause to add the ENGINE statement to CREATE TABLE statements.
`protected String`	`defaultSchema` Default schema for methods allowing the use of a default value.
`protected String`	`domainName` Domain name for the system containing the database.
`protected Driver`	`driver`
`protected DatabaseExtras`	`extras` Used to represent associated DatabaseExtras object.
`protected String`	`handlerClass` Name of the handler class for the database.
`protected boolean`	`invalidParameters` If the parameters supplied for instantiating the object are invalid, this field should be set to true.
`protected boolean`	`isConnected` Flag indicating whether database has been connected.
`protected String`	`password` The password to be used for accessing the database server.
`protected int`	`portNumber` Port number of the database connection.
`protected String`	`systemDescription` Optional field containing a human readable description of the database.
`protected String`	`systemName` This is the name of the system identifier to identify the database in database systems that can support multiple databases.
`protected String[]`	`tableNamePrefixes` Set of prefixes for table names

Constructor Summary

Constructors
Constructor and Description
`DatabaseProperties()` Constructor using a default system and account name.
`DatabaseProperties(String value)` Constructor specifying identifier for system and using a default account name.
`DatabaseProperties(String systemName, String accountName)` Constructor specifying system and account name.

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`clearTableNamePrefixes()` Clears the list of table name prefix values.
`void`	`close()` Close the database connection.
`String`	`comment(String text)` Returns the parameter as a DDL comment if the database is of a type that allows comments in DDL statements.
`void`	`commit()` Execute a commit statement for the SQL connection.
`void`	`connect()` Open the database connection.
`static String`	`decodeSqlType(int value)` Decode the values of constants in java.sql.TYPES to String values.
`void`	`dumpResultSet(ResultSet rs, String targetTableName, GenericPrinter output)` Dumps a result set as a set of INSERT SQL statements.
`void`	`dumpResultSet(ResultSet rs, String targetTableName, PrintStream outputStream)` Dumps a result set to a PrintStream object
`void`	`dumpResultSet(ResultSet rs, String targetTableName, PrintWriter outputWriter)` Dumps a result set to a PrintWriter object
`void`	`dumpTable(String table, PrintStream output)` Dump contents of database to PrintStream object
`void`	`dumpTable(String table, PrintWriter output)` Dump contents of database table to PrintWriter object.
`void`	`dumpTable(String sourceTableName, String targetTableName, GenericPrinter output)`
`protected void`	`dumpTable(String sourceTableName, String targetTableName, PrintWriter outputWriter, PrintStream outputStream)` Dumps the contents of a table as a series of SQL statements.
`ResultSet`	`executeQuery(String sqlCode)` This class executes an SQL query and returns a ResultSet.
`String`	`executeSimpleQuery(String sqlCode)` This class reads the first field on the first record from an SQL Query.
`int`	`executeUpdate(String sqlCode)` Execute SQL statement without returning results.
`String`	`getAccountName()` Return the account name used for the database connection.
`Connection`	`getConnection()` Obtain the connection object for the database connection.
`DatabaseExtras`	`getDatabaseExtras()` Get value of extras.
`String`	`getDateTerm()` Return the expression used in SQL statements to represent a data type for holding a date.
`String`	`getDatetimeTerm()` Return the expression used in SQL statements to represent a data type for holding a date and time.
`String`	`getDbms()` Get name of database management system
`int`	`getDebugLevel()` Gets the amount of diagnostic messages to be printed.
`String`	`getDefaultCatalog()` Get the value of defaultCatalog.
`String`	`getDefaultSchema()` Gets value of defaultSchema
`Driver`	`getDriver()` Returns the instance of the JDBC driver used to connect to the database.
`String`	`getEngineClause()` Create optional ENGINE clause
`String`	`getLongblobTerm()` Return the data type used for large BLOBS (Binary Large Objects).
`String`	`getNowTerm()` Return the expression used in SQL statements to obtain the current time.
`String`	`getSystem()` Return the system identifier used for the database connection.
`String`	`getSystemDescription()` Getter for systemDescription
`String`	`getTableNamePrefixes()` Get the value of the default table name prefix (item 0)
`String`	`getTableNamePrefixes(int i)` Get the value of a table name prefix
`boolean`	`hasInvalidParameters()` Determine whether parameters for constructor were valid.
`void`	`insertRow(String tableName, String[] columnNames, Object... value)` Deprecated.
`void`	`insertRowWithKeys(String tableName, String[] columnNames, int columnCount, Object... value)` Insert rows in a table where there is more than one column in the primary key.
`String`	`prefixTableName(int type, String value)` Prefixes a table name with a value that was set as part of the database connection.
`String`	`prefixTableName(String value)` Prefixes a table name with a value that was set as part of the database connection.
`PreparedStatement`	`prepareStatement(String query)` Generate a prepared statement for this database.
`void`	`rollback()` Execute a rollback statement for the SQL connection.
`void`	`setAccountName(String value)` Setter for accountName.
`void`	`setAutoCommit(boolean value)` Set autoCommit flag
`void`	`setConnectionString(String value)` Specify the connection string to be used.
`void`	`setDatabaseExtras(DatabaseExtras value)` Set value of extras.
`abstract void`	`setDatabaseInstance()` Internal program for setting up connection using default database and account.
`abstract void`	`setDatabaseInstance(String system)` Internal program for setting up connection using specified database with a default account for the database.
`abstract void`	`setDatabaseInstance(String system, String user)` Internal program for setting up connection with a specified database and account name.
`void`	`setDebugLevel(int level)` Set the amount of diagnostic messages.
`void`	`setDefaultCatalog(String value)` Sets value of defaultCatalog.
`void`	`setDefaultSchema(String value)` Sets value of defaultSchema.
`void`	`setDomainName(String value)` Setter for domainName
`void`	`setHandlerClass(String value)` Set the class name to be used for the handler class.
`protected void`	`setInvalidParameters(boolean value)` Set value of invalidParameters to indicate that constructor is not valid.
`void`	`setPassword(String value)` Sets the password to be used for the connection when it is desired to avoid placing the value in the program.
`void`	`setPortNumber(int value)` Setter for port number
`void`	`setSystemName(String value)` Setter for systemName.
`String`	`showAttributes()` Return attributes of the connection properties

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

driver
```
protected Driver driver
```

debugLevel
```
protected int debugLevel
```
Amount of diagnostic messages.
A value of zero indicates that no diagnostic messages should be displayed. The higher the value, the more diagnostic messages will be generated.

extras
```
protected DatabaseExtras extras
```
Used to represent associated DatabaseExtras object.

tableNamePrefixes
```
protected String[] tableNamePrefixes
```
Set of prefixes for table names

autoCommit
```
protected boolean autoCommit
```
True indicates that autoCommit is set for this database connection when the connection is opened.

systemDescription
```
protected String systemDescription
```
Optional field containing a human readable description of the database. This string will have to be escaped before it is safe for use in HTML code and SQL queries.

systemName
```
protected String systemName
```
This is the name of the system identifier to identify the database in database systems that can support multiple databases.

handlerClass
```
protected String handlerClass
```
Name of the handler class for the database.

Product Handler Class Default
Port

MySQL com.mysql.jdbc.Driver 3306

Oracle oracle.jdbc.driver.OracleDriver 1521

SQL Server com.microsoft.sqlserver.jdbc.SQLServerDriver 1433

It may be necessary to use the name of the handlerClass in generating the SQL statements, since the syntax for different databases such as MySQL, Oracle, DB2, Postgres, etc. differ for many of the built in functions.

Although there is no get method for this field, one can be added when creating subclasses.

portNumber
```
protected int portNumber
```
Port number of the database connection.
The default port number is shown in the discussion of the handler class names. If a port number other than the default is used, it is included as part of the domain name and connection string.

connectionString

protected String connectionString

The connection string to be used to connect to the database using JDBC (Java DataBase Connectivity)

The connection string is composed as a series of tokens separated by colons. The first token is always jdbc while the second is the name of the database manager product. The remaining tokens are dependent on the DBMS package used.

The following are examples of connection strings.

MySQL	`jdbc:mysql://server.foo.com/alpha`	alpha is default database
Oracle	`jdbc:oracle:thin:@//server.foo.com/weather jdbc:oracle:oci:`	Connects to weather service The options thin and oci refer to the two types of JDBC connections. The OCI method requires the installation of additional pieces of software and uses SQL*Net to connect to the database.
SQL Server	`jdbc:sqlserver://server.foo.com`	SQL Server allows you to specify a default database as part of the user configuration.

domainName
```
protected String domainName
```
Domain name for the system containing the database.
The domain name is included as part of the connection string.

accountName
```
protected String accountName
```
The account name to be used on the database server.

password
```
protected String password
```
The password to be used for accessing the database server.
It should be noted that there is no get method for the field. This improves security for the package. If necessary, a get method can be added in a subclass.

defaultEngine
```
protected String defaultEngine
```
When creating MySQL tables, this field can be used by the getEngineClause to add the ENGINE statement to CREATE TABLE statements.

See Also:
getEngineClause()

defaultCatalog
```
protected String defaultCatalog
```
Default catalog for methods allowing the use of a default value.

See Also:
getDefaultCatalog(), setDefaultCatalog(String)

defaultSchema
```
protected String defaultSchema
```
Default schema for methods allowing the use of a default value.

See Also:
getDefaultSchema(), setDefaultSchema(String)

connection
```
protected Connection connection
```
The object representing the connection to the database.

See Also:
getConnection()

isConnected
```
protected boolean isConnected
```
Flag indicating whether database has been connected.

invalidParameters
```
protected boolean invalidParameters
```
If the parameters supplied for instantiating the object are invalid, this field should be set to true.

See Also:
setInvalidParameters(boolean), hasInvalidParameters()

Constructor Detail
- DatabaseProperties
```
public DatabaseProperties()
```
  Constructor using a default system and account name.
- DatabaseProperties
```
public DatabaseProperties(String value)
```
  Constructor specifying identifier for system and using a default account name.
  
  Parameters:
  value - Identifier code for system
- DatabaseProperties
```
public DatabaseProperties(String systemName,
                  String accountName)
```
  Constructor specifying system and account name.
  
  Parameters:
  systemName - Identifier code for system
  accountName - Account name to be used

Method Detail
- setDatabaseInstance
```
public abstract void setDatabaseInstance()
```
  Internal program for setting up connection using default database and account.
  
  See Also:
  setDatabaseInstance(String, String)
- setDatabaseInstance
```
public abstract void setDatabaseInstance(String system)
```
  Internal program for setting up connection using specified database with a default account for the database.
  
  Parameters:
  system - Identifying code for database
- setDatabaseInstance
```
public abstract void setDatabaseInstance(String system,
                       String user)
```
  Internal program for setting up connection with a specified database and account name.
  
  Parameters:
  system - Identifier code for database
  user - Account name to be used
- setDatabaseExtras
```
public void setDatabaseExtras(DatabaseExtras value)
```
  Set value of extras.
  
  Parameters:
  value - Object to be used for DatabaseExtras object.
  See Also:
  extras
- getDatabaseExtras
```
public DatabaseExtras getDatabaseExtras()
                                 throws NotSupportedException
```
  Get value of extras.
  
  Returns:
  DatabaseExtras object being used.
  
  Throws:
  
  NotSupportedException
  See Also:
  extras
- getTableNamePrefixes
```
public String getTableNamePrefixes()
```
  Get the value of the default table name prefix (item 0)
  
  Returns:
  Default table name prefix
- getTableNamePrefixes
```
public String getTableNamePrefixes(int i)
```
  Get the value of a table name prefix
  
  Parameters:
  i - Location of table name prefix in list
  
  Returns:
  Value of table name prefix
- getSystemDescription
```
public String getSystemDescription()
```
  Getter for systemDescription
  
  Returns:
  Description of system
  See Also:
  systemDescription
- getDefaultCatalog
```
public String getDefaultCatalog()
```
  Get the value of defaultCatalog.
  
  Returns:
  Value of defaultCatalog
  See Also:
  defaultCatalog
- setDefaultCatalog
```
public void setDefaultCatalog(String value)
```
  Sets value of defaultCatalog.
  
  Parameters:
  value - Value to be used for defaultCatalog
  See Also:
  defaultCatalog
- getDefaultSchema
```
public String getDefaultSchema()
```
  Gets value of defaultSchema
  
  Returns:
  Value of defaultSchema
  See Also:
  defaultSchema
- setDefaultSchema
```
public void setDefaultSchema(String value)
```
  Sets value of defaultSchema.
  
  Parameters:
  value - Value to be used for defaultSchema
  See Also:
  defaultSchema
- setDebugLevel
```
public void setDebugLevel(int level)
```
  Set the amount of diagnostic messages.
  
  Parameters:
  level - Amount of diagnostic messages.
- getDebugLevel
```
public int getDebugLevel()
```
  Gets the amount of diagnostic messages to be printed.
  
  Returns:
  Level of diagnostic messages to be printed.
- getDriver
```
public Driver getDriver()
```
  Returns the instance of the JDBC driver used to connect to the database.
  
  Returns:
  JDBC driver
- getSystem
```
public String getSystem()
```
  Return the system identifier used for the database connection.
  
  Returns:
  System identifier
- getDbms
```
public String getDbms()
```
  Get name of database management system
  The database name is extracted from the connection string as the second token of the string.
- getAccountName
```
public String getAccountName()
```
  Return the account name used for the database connection.
  
  Returns:
  Account name for database.
- getEngineClause
```
public String getEngineClause()
```
  Create optional ENGINE clause
  
  Returns:
  ENGINE clause for CREATE TABLE SQL statement
  See Also:
  defaultEngine
- connect
```
public void connect()
             throws SQLException
```
  Open the database connection.
  
  Throws:
  
  SQLException
- close
```
public void close()
           throws SQLException
```
  Close the database connection.
  
  Throws:
  
  SQLException
- getConnection
```
public Connection getConnection()
```
  Obtain the connection object for the database connection.
  
  Returns:
  connection
- executeUpdate
```
public int executeUpdate(String sqlCode)
                  throws SQLException
```
  Execute SQL statement without returning results.
  This method is usually used to make updates to the database.
  
  Parameters:
  sqlCode - SQL code to be executed.
  
  Throws:
  
  SQLException
- executeSimpleQuery
```
public String executeSimpleQuery(String sqlCode)
                          throws SQLException
```
  This class reads the first field on the first record from an SQL Query.
  Since only the first field is read, the statement is closed after reading the field. This eliminates the possibility of leaving a statement open if it returns multiple rows.
  
  Parameters:
  sqlCode - SQL code to be executed.
  
  Returns:
  String object continuing result of SQL query
  
  Throws:
  
  SQLException
- executeQuery
```
public ResultSet executeQuery(String sqlCode)
                       throws SQLException
```
  This class executes an SQL query and returns a ResultSet.
  
  Parameters:
  sqlCode - SQL code to be executed.
  
  Returns:
  ResultSet
  
  Throws:
  
  SQLException
- commit
```
public void commit()
```
  Execute a commit statement for the SQL connection.
- rollback
```
public void rollback()
```
  Execute a rollback statement for the SQL connection.
- setAutoCommit
```
public void setAutoCommit(boolean value)
```
  Set autoCommit flag
  
  Parameters:
  value - Value to be used for setting autoCommit flag
- showAttributes
```
public String showAttributes()
```
  Return attributes of the connection properties
  
  Returns:
  String containing connection information
- setAccountName
```
public void setAccountName(String value)
```
  Setter for accountName.
  Must be used before database connection is made.
  
  Parameters:
  value - Value for accountName
- setConnectionString
```
public void setConnectionString(String value)
```
  Specify the connection string to be used.
  Do not specify the account name or password as part of the connection string.
  
  Parameters:
  value - Connection string to be used
  See Also:
  connectionString
- setDomainName
```
public void setDomainName(String value)
```
  Setter for domainName
  Does not include port number
  
  Parameters:
  value - Value to be used for domain name
  See Also:
  domainName
- setHandlerClass
```
public void setHandlerClass(String value)
```
  Set the class name to be used for the handler class.
  
  Parameters:
  value - Name of handler class
  See Also:
  handlerClass
- setPassword
```
public void setPassword(String value)
```
  Sets the password to be used for the connection when it is desired to avoid placing the value in the program.
  
  Parameters:
  value - Value to be used for the password
- setPortNumber
```
public void setPortNumber(int value)
```
  Setter for port number
  
  Parameters:
  value - port number to be used for connection
  See Also:
  portNumber
- setSystemName
```
public void setSystemName(String value)
```
  Setter for systemName.
  
  Parameters:
  value - Value to be used for system name
  See Also:
  systemName
- clearTableNamePrefixes
```
public void clearTableNamePrefixes()
```
  Clears the list of table name prefix values.
- prefixTableName
```
public String prefixTableName(int type,
                     String value)
```
  Prefixes a table name with a value that was set as part of the database connection.
  
  Parameters:
  type - Location of the desired prefix in the tableNamePrefixes list
  value - Table name to be prefixed
  
  Returns:
  Prefixed table name
- prefixTableName
```
public String prefixTableName(String value)
```
  Prefixes a table name with a value that was set as part of the database connection.
  This version of the method uses the first entry in the tableNamePrefixes array. (index=0)
  
  Parameters:
  value - Table name to be prefixed
  
  Returns:
  Prefixed table name
- prepareStatement
```
public PreparedStatement prepareStatement(String query)
                                   throws SQLException
```
  Generate a prepared statement for this database.
  
  Parameters:
  query - SQL Query to be used in statement
  
  Returns:
  PreparedStatement object
  
  Throws:
  
  SQLException
- comment
```
public String comment(String text)
```
  Returns the parameter as a DDL comment if the database is of a type that allows comments in DDL statements.
  SQL Server does not allow comments in DDL statements.
  
  Parameters:
  text - Text to be used in comment
  
  Returns:
  Formatted material for comment in CREATE TABLE statement
- getLongblobTerm
```
public String getLongblobTerm()
```
  Return the data type used for large BLOBS (Binary Large Objects).
  
  Returns:
  Name of data type.
- getNowTerm
```
public String getNowTerm()
```
  Return the expression used in SQL statements to obtain the current time.
  
  Returns:
  SQL clause.
- getDateTerm
```
public String getDateTerm()
```
  Return the expression used in SQL statements to represent a data type for holding a date.
  SQL Server 2000 and 2005 do not have a DATE data type, and SMALLDATETIME should be used instead.
  
  Returns:
  SQL clause.
- getDatetimeTerm
```
public String getDatetimeTerm()
```
  Return the expression used in SQL statements to represent a data type for holding a date and time.
  It appears that Oracle refers to this data type as TIMESTAMP.
  
  Returns:
  SQL clause.
- decodeSqlType
```
public static String decodeSqlType(int value)
```
  Decode the values of constants in java.sql.TYPES to String values.
  
  Parameters:
  value - Value of constant
  
  Returns:
  Corresponding string describing constant
  See Also:
  Types
- setInvalidParameters
```
protected void setInvalidParameters(boolean value)
```
  Set value of invalidParameters to indicate that constructor is not valid.
  
  Parameters:
  value - Value to be used for notSupported
- hasInvalidParameters
```
public boolean hasInvalidParameters()
```
  Determine whether parameters for constructor were valid.
  
  Returns:
  True if combination of system and account is not supported
- dumpTable
```
public void dumpTable(String table,
             PrintWriter output)
```
  Dump contents of database table to PrintWriter object.
  
  Parameters:
  table - Name of table to be dumped
  output - Destination PrintWriter
- dumpTable
```
public void dumpTable(String table,
             PrintStream output)
```
  Dump contents of database to PrintStream object
  
  Parameters:
  table - Name of table to be dumped
  output - Destination PrintStream
- dumpTable
```
protected void dumpTable(String sourceTableName,
             String targetTableName,
             PrintWriter outputWriter,
             PrintStream outputStream)
```
  Dumps the contents of a table as a series of SQL statements.
  An OutputStreamWriter can be created from an OutputStream using the constructor OutputStreamWriter(OutputStream out).
  
  The objects System.out and System.err are PrintStream objects. A PrintStream object can be created from an OutputStream object using the constructor PrintStream(OutputStream out).
  
  A PrintStream object can be created from a File object using the constructor PrintStream (File out).
  
  Parameters:
  sourceTableName - Table to be dumped
  targetTableName - Table name to be used in SELECT statement
  outputWriter - PrintWriter object to which information is to be passed
  outputStream - PrintStream object to which information is to be passed
- dumpTable
```
public void dumpTable(String sourceTableName,
             String targetTableName,
             GenericPrinter output)
```
- dumpResultSet
```
public void dumpResultSet(ResultSet rs,
                 String targetTableName,
                 PrintWriter outputWriter)
```
  Dumps a result set to a PrintWriter object
  
  Parameters:
  rs - Result Set
  targetTableName - Table name to be used in INSERT statement
  outputWriter - Destination PrintWriter object
- dumpResultSet
```
public void dumpResultSet(ResultSet rs,
                 String targetTableName,
                 PrintStream outputStream)
```
  Dumps a result set to a PrintStream object
  
  Parameters:
  rs - Result set
  targetTableName - Table name to be used in INSERT statement
  outputStream - Destination PrintStream object
- dumpResultSet
```
public void dumpResultSet(ResultSet rs,
                 String targetTableName,
                 GenericPrinter output)
```
  Dumps a result set as a set of INSERT SQL statements.
  
  Parameters:
  rs - Result set to be dumped
  targetTableName - Table name to be used in INSERT statements
  output - GenericPrinter object to which information is passed
- insertRow
```
public void insertRow(String tableName,
             String[] columnNames,
             Object... value)
               throws SQLException
```
  Deprecated.
  
  Insert rows in a table where there is only one column in the primary key.
  The primary key should be the first column in the list.
  
  Parameters:
  tableName - Name of the table
  columnNames - Array containing column names in the database table for the columns to be populated with data.
  value - Values to be inserted in the columns
  
  Throws:
  
  SQLException
- insertRowWithKeys
```
public void insertRowWithKeys(String tableName,
                     String[] columnNames,
                     int columnCount,
                     Object... value)
                       throws SQLException
```
  Insert rows in a table where there is more than one column in the primary key.
  
  Parameters:
  tableName - Name of the table
  columnNames - Array containing column names in the database table.
  columnCount - Number of columns in primary key. These are the first columns in the list.
  value - Values to be inserted in the columns
  
  Throws:
  
  SQLException

Product	Handler Class	Default Port
MySQL	`com.mysql.jdbc.Driver`	3306
Oracle	`oracle.jdbc.driver.OracleDriver`	1521
SQL Server	`com.microsoft.sqlserver.jdbc.SQLServerDriver`	1433

Class DatabaseProperties

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

driver

debugLevel

extras

tableNamePrefixes

autoCommit

systemDescription

systemName

handlerClass

portNumber

connectionString

domainName

accountName

password

defaultEngine

defaultCatalog

defaultSchema

connection

isConnected

invalidParameters

Constructor Detail

DatabaseProperties

DatabaseProperties

DatabaseProperties

Method Detail

setDatabaseInstance

setDatabaseInstance

setDatabaseInstance

setDatabaseExtras

getDatabaseExtras

getTableNamePrefixes

getTableNamePrefixes

getSystemDescription

getDefaultCatalog

setDefaultCatalog

getDefaultSchema

setDefaultSchema

setDebugLevel

getDebugLevel

getDriver

getSystem

getDbms

getAccountName

getEngineClause

connect

close

getConnection

executeUpdate

executeSimpleQuery

executeQuery

commit

rollback

setAutoCommit

showAttributes

setAccountName

setConnectionString

setDomainName

setHandlerClass

setPassword

setPortNumber

setSystemName

clearTableNamePrefixes

prefixTableName

prefixTableName

prepareStatement

comment

getLongblobTerm

getNowTerm

getDateTerm

getDatetimeTerm

decodeSqlType

setInvalidParameters

hasInvalidParameters

dumpTable

dumpTable