generalDatabase

Class TableUtilities

java.lang.Object

generalDatabase.TableUtilities

public class TableUtilities
extends java.lang.Object

Some general functions to do with table checks which I want to use outside of the normal dattabse interface.

Author:

Doug Gillespie

Constructor Summary

Constructors

Constructor and Description
TableUtilities()

Method Summary

Methods

Modifier and Type	Method and Description
static boolean	addColumn(java.sql.Connection con, SQLTypes sqlTypes, java.lang.String systemName, EmptyTableDefinition tableDef, PamTableItem tableItem)
static boolean	columnExists(java.sql.Connection con, java.lang.String tableName, java.lang.String columnName, int sqlType)
static boolean	tableExists(java.sql.Connection con, java.lang.String systemName, EmptyTableDefinition tableDef)

Methods inherited from class java.lang.Object

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

Constructor Detail

TableUtilities

public TableUtilities()

Method Detail

columnExists

public static boolean columnExists(java.sql.Connection con,
                   java.lang.String tableName,
                   java.lang.String columnName,
                   int sqlType)

addColumn

public static boolean addColumn(java.sql.Connection con,
                SQLTypes sqlTypes,
                java.lang.String systemName,
                EmptyTableDefinition tableDef,
                PamTableItem tableItem)

tableExists

public static boolean tableExists(java.sql.Connection con,
                  java.lang.String systemName,
                  EmptyTableDefinition tableDef)