dbconnectivity
Class DatabaseSource

java.lang.Object
  extended by dbconnectivity.DatabaseSource
All Implemented Interfaces:
DatabaseConnector

public class DatabaseSource
extends java.lang.Object
implements DatabaseConnector

Class that filters and manages every action towards the selected dbms (PROXY pattern used)

Version:
0.3

Field Summary
static java.lang.String MYSQL
          MySQL Database id string
static java.lang.String ORACLE
          Oracle Database id string
static java.lang.String POSTGRESQL
          Postgress Database id string
static java.lang.String SQLSERVER
          SqlServer Database id string
 
Constructor Summary
DatabaseSource(java.lang.String type, java.awt.Component ancestor)
          Default Constructor
 
Method Summary
 java.lang.String access(java.lang.String user, java.lang.String password, java.lang.String hostname)
          Interface DatabaseConnector implementation
 BufferedResultSet checkCache(java.lang.String query, java.lang.Object dbs)
          Check cache for an already executed query
 boolean disconnect()
          Interface DatabaseConnector implementation
 BufferedResultSet executeQuery(java.lang.String query)
          Interface DatabaseConnector implementation
 boolean executeScript(java.lang.String filename)
          Interface DatabaseConnector implementation
 boolean executeUpdein(java.lang.String query, boolean warning)
          Interface DatabaseConnector implementation
 ConnectionData getConnectionData()
          Return connection data
 void invalidateCache()
          Method for invalidating cache
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

MYSQL

public static final java.lang.String MYSQL
MySQL Database id string

See Also:
Constant Field Values

ORACLE

public static final java.lang.String ORACLE
Oracle Database id string

See Also:
Constant Field Values

SQLSERVER

public static final java.lang.String SQLSERVER
SqlServer Database id string

See Also:
Constant Field Values

POSTGRESQL

public static final java.lang.String POSTGRESQL
Postgress Database id string

See Also:
Constant Field Values
Constructor Detail

DatabaseSource

public DatabaseSource(java.lang.String type,
                      java.awt.Component ancestor)
Default Constructor

Parameters:
type - is the type of db,
ancestor - is Component father ,if null this feature is ignored
Method Detail

access

public java.lang.String access(java.lang.String user,
                               java.lang.String password,
                               java.lang.String hostname)
Interface DatabaseConnector implementation

Specified by:
access in interface DatabaseConnector
Returns:
Exitus string

executeQuery

public BufferedResultSet executeQuery(java.lang.String query)
Interface DatabaseConnector implementation

Specified by:
executeQuery in interface DatabaseConnector
Returns:
a BufferedResultSet is returned

executeScript

public boolean executeScript(java.lang.String filename)
Interface DatabaseConnector implementation

Specified by:
executeScript in interface DatabaseConnector

executeUpdein

public boolean executeUpdein(java.lang.String query,
                             boolean warning)
Interface DatabaseConnector implementation

Specified by:
executeUpdein in interface DatabaseConnector

getConnectionData

public ConnectionData getConnectionData()
Description copied from interface: DatabaseConnector
Return connection data

Specified by:
getConnectionData in interface DatabaseConnector
Returns:
connection data object is returned

disconnect

public boolean disconnect()
Interface DatabaseConnector implementation

Specified by:
disconnect in interface DatabaseConnector

invalidateCache

public void invalidateCache()
Method for invalidating cache


checkCache

public BufferedResultSet checkCache(java.lang.String query,
                                    java.lang.Object dbs)
Check cache for an already executed query

Returns:
A bufferedResultSet object is returned if exists , or null if not present