csheets.ext.database.controller

Class ControllerImport

java.lang.Object

csheets.ext.database.controller.ControllerImport

All Implemented Interfaces:

Subject

public class ControllerImport
extends Object
implements Subject

The controller for UIImport

Author:

João Carreira

Constructor Summary

Constructors

Constructor and Description
ControllerImport(Observer o)

Method Summary

Methods

Modifier and Type	Method and Description
void	addObserver(Observer o)
void	connect(String url, String user, String pass, String dbName) Connects with a database
String[][]	getDBlist() returns the list of supported databases name
String[]	getTableList() gets the table list of the selected database
String[][]	loadTable(String tableName) imports a table from the database
void	notifyObserver(String str)
void	removerObserver(Observer o)

Methods inherited from class java.lang.Object

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

Constructor Detail

ControllerImport

public ControllerImport(Observer o)

Method Detail

connect

public void connect(String url,
           String user,
           String pass,
           String dbName)
             throws Exception

Connects with a database

Parameters:

url - path to database

user - username

pass - password

dbName - database name

Throws:

Exception

getDBlist

public String[][] getDBlist()
                     throws FileNotFoundException

returns the list of supported databases name

Returns:

2D array with database name and url

Throws:

FileNotFoundException

addObserver

public void addObserver(Observer o)

Specified by:

addObserver in interface Subject

removerObserver

public void removerObserver(Observer o)

Specified by:

removerObserver in interface Subject

notifyObserver

public void notifyObserver(String str)

Specified by:

notifyObserver in interface Subject

getTableList

public String[] getTableList()

gets the table list of the selected database

Parameters:

dbName - name of the database

loadTable

public String[][] loadTable(String tableName)

imports a table from the database

Parameters:

tableName - name of the table