generalDatabase

Class SQLTypes

java.lang.Object

generalDatabase.SQLTypes

Direct Known Subclasses:

MSAccessSQLTypes, MySQLSQLTypes, OOoDBSQLTypes, UCanAccessSqlTypes

public class SQLTypes
extends java.lang.Object

Utilities for converting between java.sql.types numeric and text formats.

SQL format can be slightly different between different databases. For example, MS Access allows you to put column names in "" which then enables you to use otherwise reserved words. MySQL on the other hand, will not let you do this.

This base class contains some default behaviours, but expect them to be overridden in many instances.

Author:

Doug Gillespie

See Also:

Types

Constructor Summary

Constructors

Constructor and Description
SQLTypes()

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	formatColumnName(java.lang.String columnName) Format the column name.
int	systemSqlType(int sqlType) Some SQL types are unavailable on some systems, so qutomatically swap them for something else.
java.lang.String	typeToString(int sqlType, int length) Converts a numeric SQL type and length to a text string that can be used in SQL statements.
java.lang.String	typeToString(int sqlType, int length, boolean counter)
java.lang.String	typeToString(PamTableItem tableItem)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLTypes

public SQLTypes()

Method Detail

typeToString

public java.lang.String typeToString(PamTableItem tableItem)

typeToString

public java.lang.String typeToString(int sqlType,
                            int length)

Converts a numeric SQL type and length to a text string that can be used in SQL statements. The length parameter is generally only required by text and character types.

Parameters:

sqlType - SQL type as defined in java.sql.Types

length - length of character and text fields

Returns:

string representation of the type

typeToString

public java.lang.String typeToString(int sqlType,
                            int length,
                            boolean counter)

formatColumnName

public java.lang.String formatColumnName(java.lang.String columnName)

Format the column name. Formats may be slightly different for different DBMS's. e.g. MS Access can put quotes around names. OODB requires them to be all upper case, etc.

Parameters:

columnName -

Returns:

formatted column name.

systemSqlType

public int systemSqlType(int sqlType)

Some SQL types are unavailable on some systems, so qutomatically swap them for something else.

Parameters:

sqlType -

Returns: