|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--DSRG.MW.DBManager
The lowest layer of the DB connection, right above the ODBC driver.
All methods go directly to the DB, every time they are invoked.
This is subclassed to provide functionality for different DB systems
in the ISs.
Field Summary | |
java.lang.String |
className
The Class name for the appropriate DB driver |
protected boolean |
connected
am I connected? |
java.sql.Connection |
connection
the DB connection |
static java.lang.String |
date_datatype
constant for the string Oracle expects for the date datatype |
(package private) static boolean |
DEBUG
|
java.lang.Class |
driver
the DB driver |
java.lang.String |
ISName
the name of the IS for this DBManager |
static java.lang.String |
numeric_datatype
constant for the string Oracle expects for the numeric datatype |
java.lang.String |
passwd
Password |
java.lang.String |
url
DB URL |
java.lang.String |
user
Username |
Constructor Summary | |
DBManager()
constructior. Initializes the "connected" variable. |
Method Summary | |
abstract boolean |
addAttribute(java.lang.String RelationName,
java.lang.String AttributeName,
java.lang.String type,
int size)
|
abstract boolean |
addRelation(java.lang.String relationName,
java.util.Vector attName,
java.util.Vector attTypes)
interface for the schema change operations |
abstract boolean |
deleteAttribute(java.lang.String RelationName,
java.lang.String attributeName)
|
abstract boolean |
deleteRelation(java.lang.String name,
boolean silent)
|
Table |
executeQuery(java.lang.String SQL)
executes a SQL-Query against one database. |
Table |
executeViewQuery(java.lang.String SQL)
executes a SQL-View-Query against one database (which should be the local database, of course). |
java.util.Vector |
getAttributeExtent(java.lang.String RelationName,
java.lang.String AttributeName)
returns a vector of strings, which represent actual data values. |
java.util.Vector |
getAttributeNames(java.lang.String RelationName)
returns a vector of strings representing attribute names in a certain relation 10/6/97 koeller |
java.lang.String |
getAttributeType(java.lang.String relationName,
java.lang.String attributeName)
a string representing the type (in the syntax of the underlying DB!) of the attribute attributeName in the relation relationName 10/6/97 koeller |
java.lang.String |
getISName()
returns the ISName for this DBManager |
java.util.Vector |
getRelationNames()
gets Relation names for this IS. |
private java.lang.String |
getTableName(java.lang.String SQL,
int index)
determines which table a certain attribute comes from. |
boolean |
isConnected()
am I connected? |
(package private) java.lang.String |
makeSelectClause(java.lang.String schema)
Helper function. |
private Table |
privateExecuteQuery(java.lang.String SQL,
boolean withRelationNames)
returns a single Table object not tied to an IS. |
abstract boolean |
renameAttribute(java.lang.String RelationName,
java.lang.String oldName,
java.lang.String newName)
|
java.lang.String |
renameAttributeInSchema(java.lang.String schema,
java.lang.String oldName,
java.lang.String newName)
Helper function. |
abstract boolean |
renameRelation(java.lang.String oldName,
java.lang.String newName)
|
boolean |
sendUpdate(java.lang.String relationName,
int count,
java.lang.String update)
send an update :) |
abstract boolean |
storeRelation(Table table)
|
java.lang.String |
stripAttributeFromSchema(java.lang.String schema,
java.lang.String attributeName)
Helper function. |
Methods inherited from class java.lang.Object |
|
Field Detail |
static final boolean DEBUG
public java.lang.String url
public java.lang.String user
public java.lang.String passwd
public java.lang.String className
public java.lang.Class driver
public java.sql.Connection connection
public java.lang.String ISName
protected boolean connected
public static final java.lang.String numeric_datatype
public static final java.lang.String date_datatype
Constructor Detail |
public DBManager()
Method Detail |
public boolean isConnected()
public java.lang.String getISName()
public java.util.Vector getRelationNames()
public java.util.Vector getAttributeNames(java.lang.String RelationName)
public java.lang.String getAttributeType(java.lang.String relationName, java.lang.String attributeName)
attributeName
in the relation relationName
public java.util.Vector getAttributeExtent(java.lang.String RelationName, java.lang.String AttributeName)
public Table executeQuery(java.lang.String SQL)
public Table executeViewQuery(java.lang.String SQL)
executeQuery(String SQL)
private Table privateExecuteQuery(java.lang.String SQL, boolean withRelationNames)
executeQuery()
and executeViewQuery()
-methods.public boolean sendUpdate(java.lang.String relationName, int count, java.lang.String update)
public abstract boolean addRelation(java.lang.String relationName, java.util.Vector attName, java.util.Vector attTypes)
public abstract boolean deleteRelation(java.lang.String name, boolean silent)
public abstract boolean renameAttribute(java.lang.String RelationName, java.lang.String oldName, java.lang.String newName)
public abstract boolean addAttribute(java.lang.String RelationName, java.lang.String AttributeName, java.lang.String type, int size)
public abstract boolean deleteAttribute(java.lang.String RelationName, java.lang.String attributeName)
public abstract boolean renameRelation(java.lang.String oldName, java.lang.String newName)
public abstract boolean storeRelation(Table table)
public java.lang.String stripAttributeFromSchema(java.lang.String schema, java.lang.String attributeName)
private java.lang.String getTableName(java.lang.String SQL, int index)
{<table_name>.<attribute_name>,}<table_name>.<attribute_name>
as a format.
public java.lang.String renameAttributeInSchema(java.lang.String schema, java.lang.String oldName, java.lang.String newName)
java.lang.String makeSelectClause(java.lang.String schema)
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |