de.oio.sqlrest.db
Class DatabaseUtil

java.lang.Object
  |
  +--de.oio.sqlrest.db.DatabaseUtil

public class DatabaseUtil

extends java.lang.Object

Author:

tbayer

Constructor Summary

DatabaseUtil()

Method Summary

static void	deleteRow(java.lang.String tableName, java.lang.String primaryKey) Method deleteRow.
static java.util.Collection	getCatalogs() A Catalog is a logical database in a dbms.
static java.util.Collection	getColumnsMetaData(java.lang.String tableName) Method getColumnsMetaData.
static int	getColumnType(java.lang.String tableName, java.lang.String columnName) Method getColumnType.
static java.lang.String	getPrimaryKeyColumnName(java.lang.String tableName)
static java.util.Collection	getPrimaryKeyValuesFromTable(java.lang.String tableName) Method getTable.
static java.lang.String	getSQLParameterSubstring(java.lang.String value, int type)
static java.util.ArrayList	getTableDetails(java.lang.String tableName, java.lang.String id) Method getTableDetails.
static java.util.Collection	getTableNames()
static boolean	isNumericType(int type)

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseUtil

public DatabaseUtil()

Method Detail

getCatalogs

public static java.util.Collection getCatalogs()

A Catalog is a logical database in a dbms. The method returns a list of catalognames.

Returns:

Collection containing Strings with the names of the database Catalogs.

getTableNames

public static java.util.Collection getTableNames()

getPrimaryKeyValuesFromTable

public static java.util.Collection getPrimaryKeyValuesFromTable(java.lang.String tableName)

Method getTable.

Parameters:

tableName -

getTableDetails

public static java.util.ArrayList getTableDetails(java.lang.String tableName,
                                                  java.lang.String id)

Method getTableDetails.

getSQLParameterSubstring

public static java.lang.String getSQLParameterSubstring(java.lang.String value,
                                                        int type)

isNumericType

public static boolean isNumericType(int type)

getPrimaryKeyColumnName

public static java.lang.String getPrimaryKeyColumnName(java.lang.String tableName)

getColumnType

public static int getColumnType(java.lang.String tableName,
                                java.lang.String columnName)

Method getColumnType.

Parameters:

tableName -

Returns:

String

deleteRow

public static void deleteRow(java.lang.String tableName,
                             java.lang.String primaryKey)
                      throws java.sql.SQLException

Method deleteRow.

java.sql.SQLException

getColumnsMetaData

public static java.util.Collection getColumnsMetaData(java.lang.String tableName)

Method getColumnsMetaData.

Parameters:

tableName -

Returns:

Collection