csheets.ext.database.controller

Class ControllerUpdate

java.lang.Object

csheets.ext.database.controller.ControllerUpdate

All Implemented Interfaces:

Subject

public class ControllerUpdate
extends Object
implements Subject

The controller for UIUpdate

Author:

João Carreira

Constructor Summary

Constructors

Constructor and Description
ControllerUpdate()
ControllerUpdate(Observer o) Constructor with observer

Method Summary

Methods

Modifier and Type	Method and Description
void	addObserver(Observer o) adds Observer o to arraylist
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	connect(String url, String user, String pass, String dbName) creates connection to 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) removes Observer o from arraylist
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 spreadsheets table by deleting unselected cells and editing modified cells

Methods inherited from class java.lang.Object

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

Constructor Detail

ControllerUpdate

public ControllerUpdate()

ControllerUpdate

public ControllerUpdate(Observer o)

Constructor with observer

Parameters:

o - Observer object

Method Detail

getDBlist

public String[][] getDBlist()
                     throws FileNotFoundException

returns the list of supported databases name

Returns:

2D array with database name and url

Throws:

FileNotFoundException

connect

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

creates connection to a database

Parameters:

url - path to driver

user - username

pass - password

adapteeName - adaptee class name

Throws:

Exception

addObserver

public void addObserver(Observer o)

adds Observer o to arraylist

Specified by:

addObserver in interface Subject

Parameters:

o - Observer object

removerObserver

public void removerObserver(Observer o)

removes Observer o from arraylist

Specified by:

removerObserver in interface Subject

Parameters:

o - Observer object

notifyObserver

public void notifyObserver(String str)

Specified by:

notifyObserver in interface Subject

loadTable

public String[][] loadTable(String tableName)

imports a table from the database

Parameters:

tableName - name of the table

getTableList

public String[] getTableList()

gets the table list of the selected database

Parameters:

dbName - name of the database

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 spreadsheets table by deleting unselected cells and editing modified cells

Parameters:

tableName - table name in database

tableData - table content from database

selectedCells - selected content from cleansheets

cells - selected cells