edu.unh.sdb.mdb

Class DBIF

java.lang.Object

edu.unh.sdb.mdb.DBIF

Direct Known Subclasses:

MySQLDBIF, OracleDBIF

public abstract class DBIF
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
static java.util.Hashtable<java.lang.String,DBIF>	DBIFList
protected java.lang.String	dbUrl
protected java.lang.String	driver
protected java.lang.String	localhost
static int	MYSQL
protected URL	myUrl
static int	ORACLE
static int	POSTGRE

Constructor Summary

Constructors

Constructor and Description
DBIF() default constructor
DBIF(URL url) constructor, set up database conection

Method Summary

Methods

Modifier and Type	Method and Description
protected void	createDB(java.lang.String dbName)
void	createTable() create tables
static void	detach(URL url)
void	dropTable() drop all the tables from database
URL	getURL()
URL	getUrlByDBName(java.lang.String name)
boolean	isDSNameUsed(java.lang.String name)
DataSource	loadDS(java.lang.String name, WorkSpace ws) read one DataSource from database to WorkSpace
void	loadWorkSpace(WorkSpace ws) read meta data from database to WorkSpace
static DBIF	open(URL url)
void	setDB(URL url)
void	setVerbose(boolean b) the default state for verbose is false
void	show(java.lang.String tableName) For debugging, print out the table content
void	showAll()
void	writeDS(java.lang.String name, WorkSpace ws) write meta data from WorkSpace to database
void	writeWorkSpace(WorkSpace ws) write meta data from WorkSpace to database

Methods inherited from class java.lang.Object

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

Field Detail

MYSQL

public static final int MYSQL

See Also:

Constant Field Values

ORACLE

public static final int ORACLE

See Also:

Constant Field Values

POSTGRE

public static final int POSTGRE

See Also:

Constant Field Values

myUrl

protected URL myUrl

localhost

protected java.lang.String localhost

dbUrl

protected java.lang.String dbUrl

driver

protected java.lang.String driver

DBIFList

public static java.util.Hashtable<java.lang.String,DBIF> DBIFList

Constructor Detail

DBIF

public DBIF()

default constructor

DBIF

public DBIF(URL url)

constructor, set up database conection

Method Detail

createDB

protected void createDB(java.lang.String dbName)

open

public static DBIF open(URL url)
                 throws java.lang.Exception

Throws:

java.lang.Exception

detach

public static void detach(URL url)

getURL

public URL getURL()

setDB

public void setDB(URL url)

getUrlByDBName

public URL getUrlByDBName(java.lang.String name)

loadWorkSpace

public void loadWorkSpace(WorkSpace ws)
                   throws java.lang.Exception

read meta data from database to WorkSpace

Throws:

java.lang.Exception

loadDS

public DataSource loadDS(java.lang.String name,
                WorkSpace ws)
                  throws java.lang.Exception

read one DataSource from database to WorkSpace

Throws:

java.lang.Exception

writeWorkSpace

public void writeWorkSpace(WorkSpace ws)

write meta data from WorkSpace to database

writeDS

public void writeDS(java.lang.String name,
           WorkSpace ws)

write meta data from WorkSpace to database

createTable

public void createTable()

create tables

dropTable

public void dropTable()

drop all the tables from database

setVerbose

public void setVerbose(boolean b)

the default state for verbose is false

show

public void show(java.lang.String tableName)

For debugging, print out the table content

showAll

public void showAll()

isDSNameUsed

public boolean isDSNameUsed(java.lang.String name)