csheets.ext.database.core

Class DatabaseFacade

java.lang.Object

java.util.Observable

csheets.ext.database.core.DatabaseFacade

public class DatabaseFacade
extends Observable

A class that deals with all the data going into and from the databases (UML facade pattern)

Author:

João Carreira

Constructor Summary

Constructors

Constructor and Description
DatabaseFacade() constructor

Method Summary

Methods

Modifier and Type	Method and Description
String[][]	cellsTo2dArray(Cell[][] cells) converts selected spreadsheet content in a 2D String array
boolean	compareCellsWithDB(String[][] tableData, String[][] selectedCells) compares if there's any difference in content between the selected cells in the spreadsheet and the ones imported from the DB
void	createConnection(String url, String user, String pass, String dbName) creates a connection to a database driver
void	exportData(Cell[][] cells, String tableName) exports data to a database
String[]	getTableList() gets the table list of a given database
String[][]	loadTable(String tableName) loads data from a table of the database
void	startSync(String user, String pass, Cell[][] cells, String tableName, String url, Observer observer) Starts a new sync with database
void	updateTable(String tableName, String[][] tableData, String[][] selectedCells, Cell[][] cells) updates a database table based on the selected cells
void	updateTableWithDeletion(String tableName, String[][] tableData, String[][] selectedCells, Cell[][] cells) updates a database table by deleting unselected rows and editing modified rows

Methods inherited from class java.util.Observable

addObserver, clearChanged, countObservers, deleteObserver, deleteObservers, hasChanged, notifyObservers, notifyObservers, setChanged

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseFacade

public DatabaseFacade()

constructor

Method Detail

createConnection

public void createConnection(String url,
                    String user,
                    String pass,
                    String dbName)
                      throws SQLException,
                             ClassNotFoundException,
                             Exception

creates a connection to a database driver

Parameters:

url - path to the driver

user - username

pass - password

Throws:

SQLException

ClassNotFoundException

Exception

exportData

public void exportData(Cell[][] cells,
              String tableName)

exports data to a database

Parameters:

cells - cells to be exported

tableName - table's name in the database

getTableList

public String[] getTableList()

gets the table list of a given database

loadTable

public String[][] loadTable(String tableName)

loads data from a table of the database

Parameters:

tableName - name of the table

startSync

public void startSync(String user,
             String pass,
             Cell[][] cells,
             String tableName,
             String url,
             Observer observer)

Starts a new sync with database

Parameters:

user - username

pass - username's password

cells - cells to be sync

tableName - name of the table

url - database url

observer - the observer object

cellsTo2dArray

public String[][] cellsTo2dArray(Cell[][] cells)

converts selected spreadsheet content in a 2D String array

Parameters:

cells - selected cells in spreadsheet

Returns:

2D array with content in selected cells

compareCellsWithDB

public boolean compareCellsWithDB(String[][] tableData,
                         String[][] selectedCells)

compares if there's any difference in content between the selected cells in the spreadsheet and the ones imported from the DB

Parameters:

tableData - content imported from BD

selectedCells - cells selected in the spreadsheet

Returns:

true if there's any difference, false if they're equal

updateTable

public void updateTable(String tableName,
               String[][] tableData,
               String[][] selectedCells,
               Cell[][] cells)

updates a database table based on the selected cells

Parameters:

tableName - target table to be updated

tableData - 2D array with current table data

selectedCells - 2D array with selected cells in spreadsheet

updateTableWithDeletion

public void updateTableWithDeletion(String tableName,
                           String[][] tableData,
                           String[][] selectedCells,
                           Cell[][] cells)

updates a database table by deleting unselected rows and editing modified rows

Parameters:

tableName - table name in database

tableData - content from database

selectedCells - content sppreadsheet

cells - selected cells