csheets.ext.database.core

Interface DBConnectionStrategy

All Known Implementing Classes:

DerbyConnection, HsqlDBConnection

public interface DBConnectionStrategy

Database connection interface (applying the adapter pattern)

Author:

João Carreira

Method Summary

Methods

Modifier and Type	Method and Description
int	countRows(String tableName) counts the rows of a given table
int[]	countsRowsAndCols(String tableName) counts rows and columns of a give database table
void	createConnection(String url, String user, String pass) creates a connection to a database driver
void	createTable(String tableName, Cell[][] cells) creates a new table in the database
void	deleteRows(String tableName, String[] toDelete) deletes rows from a database table
void	disconnet() closes connection from the database
String[][]	getTableContent(String tableName) returns the data of a given table
String[]	getTableList(ArrayList list) returns all the tables availabe int he database
void	insertNewData(String tableName, String[][] newData) inserts a new row into a database table
String[][]	queryTo2dArray(ArrayList array, String[][] table) converts database table-content stored in an array list to a 2D String array
ArrayList	queryToArray() saves the result of a SQL expression into an arraylist
ArrayList	queryToArray(String tableName) saves a SQL query in an ArrayList
void	updateRow(String tableName, String column, String origin, String destination) updates a single row in a database table
void	updateTable() updates a given table

Method Detail

createConnection

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

creates a connection to a database driver

Parameters:

url - path to driver

user - username

pass - password

Throws:

ClassNotFoundException

SQLException

createTable

void createTable(String tableName,
               Cell[][] cells)

creates a new table in the database

Parameters:

tableName - table's name

cells - cells to be added to the table

disconnet

void disconnet()

closes connection from the database

queryToArray

ArrayList queryToArray()

saves the result of a SQL expression into an arraylist

Parameters:

str - SQL expression

Returns:

arraylist with statement objects

getTableList

String[] getTableList(ArrayList list)

returns all the tables availabe int he database

Returns:

array with table list

getTableContent

String[][] getTableContent(String tableName)

returns the data of a given table

updateTable

void updateTable()

updates a given table

queryToArray

ArrayList queryToArray(String tableName)
                       throws SQLException

saves a SQL query in an ArrayList

Parameters:

expression - sql expression

Returns:

arraylist with indidivual items

Throws:

SQLException

countsRowsAndCols

int[] countsRowsAndCols(String tableName)
                        throws SQLException

counts rows and columns of a give database table

Parameters:

tableName - table name

Returns:

2D array with number of rows (index 0) and columns (index 1)

Throws:

SQLException

countRows

int countRows(String tableName)
              throws SQLException

counts the rows of a given table

Parameters:

tableName -

Returns:

Throws:

SQLException

queryTo2dArray

String[][] queryTo2dArray(ArrayList array,
                        String[][] table)

converts database table-content stored in an array list to a 2D String array

Parameters:

array - arralist with table-content

table - 2D array

Returns:

table

updateRow

void updateRow(String tableName,
             String column,
             String origin,
             String destination)

updates a single row in a database table

Parameters:

tableName - table's name

column - table's column

origin - value to be final

destination - primary key in database

insertNewData

void insertNewData(String tableName,
                 String[][] newData)

inserts a new row into a database table

Parameters:

tableName - database table name

newData - 2D array with data to be added to the database

deleteRows

void deleteRows(String tableName,
              String[] toDelete)

deletes rows from a database table

Parameters:

tableName - database table name

toDelete - array with primary keys for deletion