org.ecoinformatics.seek.dataquery

Class HsqlDataQueryAction

java.lang.Object

javax.swing.AbstractAction

org.ecoinformatics.seek.dataquery.DataQueryAction

org.ecoinformatics.seek.dataquery.HsqlDataQueryAction

All Implemented Interfaces:

java.awt.event.ActionListener, java.io.Serializable, java.lang.Cloneable, java.util.EventListener, javax.swing.Action

public class HsqlDataQueryAction
extends DataQueryAction

This class will handle data query action base on Hsql sql engine

Author:

Jing Tao

See Also:

Serialized Form

Field Summary

Fields inherited from class javax.swing.AbstractAction

changeSupport, enabled

Fields inherited from interface javax.swing.Action

ACCELERATOR_KEY, ACTION_COMMAND_KEY, DEFAULT, DISPLAYED_MNEMONIC_INDEX_KEY, LARGE_ICON_KEY, LONG_DESCRIPTION, MNEMONIC_KEY, NAME, SELECTED_KEY, SHORT_DESCRIPTION, SMALL_ICON

Constructor Summary

Constructors

Constructor and Description
HsqlDataQueryAction() Default constructor.

Method Summary

Modifier and Type	Method and Description
void	actionPerformed(java.awt.event.ActionEvent event) This method will handle such staff: Load data into db(create text tables and set source file location to table) Run sql query against the db
void	close() Close the underlying database resources and invalidate object.
java.sql.ResultSet	getResultSet() Method to get result set
java.lang.String	getSQL() Get sql command
void	setPrintResultset(boolean printResultset) Method to print out the result set.
void	setSQL(java.lang.String mysql) Set sql command

Methods inherited from class javax.swing.AbstractAction

addPropertyChangeListener, clone, firePropertyChange, getKeys, getPropertyChangeListeners, getValue, isEnabled, putValue, removePropertyChangeListener, setEnabled

Methods inherited from class java.lang.Object

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

Constructor Detail

HsqlDataQueryAction

public HsqlDataQueryAction()
                    throws java.sql.SQLException,
                           java.lang.ClassNotFoundException

Default constructor. In this conctructor, it will set up connection to db

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

Method Detail

getSQL

public java.lang.String getSQL()

Get sql command

Specified by:

getSQL in class DataQueryAction

Returns:

String

setSQL

public void setSQL(java.lang.String mysql)

Set sql command

Specified by:

setSQL in class DataQueryAction

Parameters:

mysql - String

getResultSet

public java.sql.ResultSet getResultSet()

Method to get result set

Specified by:

getResultSet in class DataQueryAction

Returns:

ResultSet

close

public void close()

Close the underlying database resources and invalidate object.

setPrintResultset

public void setPrintResultset(boolean printResultset)

Method to print out the result set. This is for debug.

Parameters:

printResultset - boolean

actionPerformed

public void actionPerformed(java.awt.event.ActionEvent event)

This method will handle such staff: Load data into db(create text tables and set source file location to table) Run sql query against the db

Parameters:

event - ActionEvent