csheets.ext.database.core

Class ConsoleHsqlTest

java.lang.Object

csheets.ext.database.core.ConsoleHsqlTest

public class ConsoleHsqlTest
extends Object

A console-based application to test the HSQL database What this application does: 1) it creates an hsql database in the path "res/csheets/ext/database/hsql_db" 2) it creates a table called SAMPLE_TABLE with four entries 3) in order to view the data entered go to http://www.hsqldb.org and download the latest stable release (mine is 2.2.9) 4) once you have it go to terminal, move to "hsqldb-2.2.9/hsqldb/lib" and run the following command: $ java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing 5) once launched, select the following: TYPE: HSQL database engine standalone DRIVER: org.hsqldb.jdbcDriver URL: jdbc:hsqldb:file:src-resources/csheets/ext/database/embebbed_db/hsql_db USER: user PASS: pass 6) You should be prompted with the SAMPLE_TABLE that was created when this program was run (based in the code of Karl Meissner, at http://www.hsqldb.org/doc/guide/apb.html)

Author:

João Carreira

Field Summary

Fields

Modifier and Type	Field and Description
(package private) Connection	conn

Constructor Summary

Constructors

Constructor and Description
ConsoleHsqlTest(String db_file_name_prefix)

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
static void	dump(ResultSet rs) using cursors
static void	main(String[] args) Console test application
void	query(String expression) select statement
String[][]	queryTo2dArray(ArrayList array, String[][] table)
ArrayList	queryToArray(String tableName) saves a query in an ArrayList
void	shutdown() safe shutdown of HSQL database
void	update(String expression) SQL commands CREATE, DROP, INSERT and UPDATE

Methods inherited from class java.lang.Object

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

Field Detail

conn

Connection conn

Constructor Detail

ConsoleHsqlTest

public ConsoleHsqlTest(String db_file_name_prefix)
                throws Exception

Throws:

Exception

Method Detail

shutdown

public void shutdown()
              throws SQLException

safe shutdown of HSQL database

Throws:

SQLException

query

public void query(String expression)
           throws SQLException

select statement

Parameters:

expression -

Throws:

SQLException

update

public void update(String expression)
            throws SQLException

SQL commands CREATE, DROP, INSERT and UPDATE

Parameters:

expression -

Throws:

SQLException

dump

public static void dump(ResultSet rs)
                 throws SQLException

using cursors

Parameters:

rs -

Throws:

SQLException

queryToArray

public ArrayList queryToArray(String tableName)
                       throws SQLException

saves a query in an ArrayList

Parameters:

expression - sql expression

Returns:

arraylist with indidivual items

Throws:

SQLException

countsRowsAndCols

public 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

public int countRows(String tableName)
              throws SQLException

counts the rows of a given table

Parameters:

tableName -

Returns:

Throws:

SQLException

queryTo2dArray

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

main

public static void main(String[] args)
                 throws SQLException

Console test application

Parameters:

args -

Throws:

SQLException