gpl.fredy.metadata
Class DbInfo

java.lang.Object
  extended by gpl.fredy.share.BasicAdmin
      extended by gpl.fredy.metadata.DbInfo

public class DbInfo
extends BasicAdmin


Field Summary
 
Fields inherited from class gpl.fredy.share.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 gpl.fredy.share.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)