applications.basics
Class DbInfo

java.lang.Object
  applications.basics.BasicAdmin
      applications.basics.DbInfo

public class DbInfo
extends BasicAdmin

Field Summary

Fields inherited from class applications.basics.BasicAdmin

con

Constructor Summary

DbInfo(java.lang.String host, java.lang.String user, java.lang.String password, java.lang.String database)

DbInfo(t_connect con)

Method Summary

void	close()
protected void	finalize()
java.lang.String	getAllInfo()
java.util.Vector	getCatalog() Get the value of catalogs.
SingleColumnInfo	getColumnInfo(java.lang.String db, java.lang.String table, java.lang.String column)
java.util.Vector	getColumnNames(java.lang.String table)
java.sql.Connection	getConnection() Get the value of con.
java.sql.DatabaseMetaData	getDmd() Get the value of dmd.
java.lang.String	getDriverName() Get the value of driverName.
java.lang.String	getDriverVersion() Get the value of driverVersion.
java.util.Vector	getPk(java.lang.String table)
java.lang.String	getProductName() Get the value of productName.
java.lang.String	getProductVersion() Get the value of productVersion.
java.util.Vector	getSchemas() Get the value of schemas.
java.util.Vector	getSQLWords() retrieve all SQL-Keywords, available for this DB
java.lang.String	getTableDescription(java.lang.String table, java.lang.String leadingCharacter)
java.util.Vector	getTables(java.lang.String db) Get the value of tables.
java.util.Vector	getTables(java.lang.String db, java.lang.String schema)
java.util.Vector	getTables(java.lang.String db, java.lang.String schema, java.lang.String type)
java.util.Vector	getTables(java.lang.String db, java.lang.String schema, java.lang.String type, java.lang.String tableNamePattern)
static void	main(java.lang.String[] args)
void	setDriverName() Set the value of driverName.
void	setDriverVersion() Set the value of driverVersion.
void	setProductVersion() Set the value of productVersion.
void	setTables(java.util.Vector v) Set the value of tables.

Methods inherited from class applications.basics.BasicAdmin

getCon, getDatabase, getHost, getPassword, getSchema, getTable, getUser, setCon, setDatabase, setHost, setPassword, setSchema, setTable, setUser

Methods inherited from class java.lang.Object

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

Constructor Detail

DbInfo

public DbInfo(java.lang.String host,
              java.lang.String user,
              java.lang.String password,
              java.lang.String database)

DbInfo

public DbInfo(t_connect con)

Method Detail

getConnection

public java.sql.Connection getConnection()

Get the value of con.

Returns:

Value of con.

finalize

protected void finalize()

Overrides:

finalize in class java.lang.Object

close

public void close()

getDmd

public java.sql.DatabaseMetaData getDmd()

Get the value of dmd.

Returns:

Value of dmd.

getCatalog

public java.util.Vector getCatalog()

Get the value of catalogs.

Returns:

Value of catalogs.

getSchemas

public java.util.Vector getSchemas()

Get the value of schemas.

Returns:

Value of schemas.

getTables

public java.util.Vector getTables(java.lang.String db)

Get the value of tables.

Returns:

Value of tables.

getTables

public java.util.Vector getTables(java.lang.String db,
                                  java.lang.String schema)

getTables

public java.util.Vector getTables(java.lang.String db,
                                  java.lang.String schema,
                                  java.lang.String type)

getTables

public java.util.Vector getTables(java.lang.String db,
                                  java.lang.String schema,
                                  java.lang.String type,
                                  java.lang.String tableNamePattern)

setTables

public void setTables(java.util.Vector v)

Set the value of tables.

Parameters:

v - Value to assign to tables.

getSQLWords

public java.util.Vector getSQLWords()

retrieve all SQL-Keywords, available for this DB

getProductName

public java.lang.String getProductName()

Get the value of productName.

Returns:

Value of productName.

getProductVersion

public java.lang.String getProductVersion()

Get the value of productVersion.

Returns:

Value of productVersion.

setProductVersion

public void setProductVersion()

Set the value of productVersion.

Parameters:

v - Value to assign to productVersion.

getDriverName

public java.lang.String getDriverName()

Get the value of driverName.

Returns:

Value of driverName.

setDriverName

public void setDriverName()

Set the value of driverName.

Parameters:

v - Value to assign to driverName.

getDriverVersion

public java.lang.String getDriverVersion()

Get the value of driverVersion.

Returns:

Value of driverVersion.

setDriverVersion

public void setDriverVersion()

Set the value of driverVersion.

Parameters:

v - Value to assign to driverVersion.

getColumnInfo

public SingleColumnInfo getColumnInfo(java.lang.String db,
                                      java.lang.String table,
                                      java.lang.String column)

getAllInfo

public java.lang.String getAllInfo()

getPk

public java.util.Vector getPk(java.lang.String table)

getTableDescription

public java.lang.String getTableDescription(java.lang.String table,
                                            java.lang.String leadingCharacter)

getColumnNames

public java.util.Vector getColumnNames(java.lang.String table)

main

public static void main(java.lang.String[] args)