csheets.ext.database.core

Class DerbyConnection

java.lang.Object

csheets.ext.database.core.DerbyConnection

All Implemented Interfaces:

DBConnectionStrategy

public class DerbyConnection
extends Object
implements DBConnectionStrategy

Creates a new connection to a derby database

Author:

Andre

Constructor Summary

Constructors

Constructor and Description
DerbyConnection()

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

Methods inherited from class java.lang.Object

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

Constructor Detail

DerbyConnection

public DerbyConnection()

Method Detail

createConnection

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

Description copied from interface: DBConnectionStrategy

creates a connection to a database driver

Specified by:

createConnection in interface DBConnectionStrategy

Parameters:

url - path to driver

user - username

pass - password

Throws:

ClassNotFoundException

SQLException

createTable

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

Description copied from interface: DBConnectionStrategy

creates a new table in the database

Specified by:

createTable in interface DBConnectionStrategy

Parameters:

tableName - table's name

cells - cells to be added to the table

disconnet

public void disconnet()

Description copied from interface: DBConnectionStrategy

closes connection from the database

Specified by:

disconnet in interface DBConnectionStrategy

queryToArray

public ArrayList queryToArray()

Description copied from interface: DBConnectionStrategy

saves the result of a SQL expression into an arraylist

Specified by:

queryToArray in interface DBConnectionStrategy

Returns:

arraylist with statement objects

getTableList

public String[] getTableList(ArrayList list)

Description copied from interface: DBConnectionStrategy

returns all the tables availabe int he database

Specified by:

getTableList in interface DBConnectionStrategy

Returns:

array with table list

getTableContent

public String[][] getTableContent(String tableName)

Description copied from interface: DBConnectionStrategy

returns the data of a given table

Specified by:

getTableContent in interface DBConnectionStrategy

updateTable

public void updateTable()

Description copied from interface: DBConnectionStrategy

updates a given table

Specified by:

updateTable in interface DBConnectionStrategy

queryToArray

public ArrayList queryToArray(String tableName)
                       throws SQLException

Description copied from interface: DBConnectionStrategy

saves a SQL query in an ArrayList

Specified by:

queryToArray in interface DBConnectionStrategy

Returns:

arraylist with indidivual items

Throws:

SQLException

countsRowsAndCols

public int[] countsRowsAndCols(String tableName)
                        throws SQLException

Description copied from interface: DBConnectionStrategy

counts rows and columns of a give database table

Specified by:

countsRowsAndCols in interface DBConnectionStrategy

Parameters:

tableName - table name

Returns:

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

Throws:

SQLException

countRows

public int countRows(String tableName)
              throws SQLException

Description copied from interface: DBConnectionStrategy

counts the rows of a given table

Specified by:

countRows in interface DBConnectionStrategy

Returns:

Throws:

SQLException

queryTo2dArray

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

Description copied from interface: DBConnectionStrategy

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

Specified by:

queryTo2dArray in interface DBConnectionStrategy

Parameters:

array - arralist with table-content

table - 2D array

Returns:

table

updateRow

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

Description copied from interface: DBConnectionStrategy

updates a single row in a database table

Specified by:

updateRow in interface DBConnectionStrategy

Parameters:

tableName - table's name

column - table's column

origin - value to be final

destination - primary key in database

insertNewData

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

Description copied from interface: DBConnectionStrategy

inserts a new row into a database table

Specified by:

insertNewData in interface DBConnectionStrategy

Parameters:

tableName - database table name

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

deleteRows

public void deleteRows(String tableName,
              String[] toDelete)

Description copied from interface: DBConnectionStrategy

deletes rows from a database table

Specified by:

deleteRows in interface DBConnectionStrategy

Parameters:

tableName - database table name

toDelete - array with primary keys for deletion