derby
Class Database

java.lang.Object
  derby.Database

public class Database
extends java.lang.Object

This code creates an instance of the Apache Derby Database running in embedded mode. Instantiating the database does not, by default, start up the database.

Author:

zozer

Field Summary

private java.sql.Connection	conn
private java.lang.String	driver
private java.lang.String	framework
private java.lang.String	protocol
private java.sql.Statement	s

Constructor Summary

Database()
Database constructor.

Method Summary

boolean	isReady() Boolean for telling if the database is currently running.
boolean	modify(java.lang.String sqlstatement) Performs modifications on the database.
java.sql.ResultSet	query(java.lang.String sqlstatement) Performs a query on an existing database and returns the ResultSet
boolean	shutdown() Shuts down the database.
boolean	startup() Starts up the database.

Methods inherited from class java.lang.Object

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

Field Detail

framework

private java.lang.String framework

driver

private java.lang.String driver

protocol

private java.lang.String protocol

s

private java.sql.Statement s

conn

private java.sql.Connection conn

Constructor Detail

Database

public Database()

Database constructor. Instantiating the database does not start up the database.

Method Detail

startup

public boolean startup()
                throws DBException

Starts up the database.

Returns:

boolean (true if runs to completion)

Throws:

DBException - (If the database fails to startup from a driver error)

modify

public boolean modify(java.lang.String sqlstatement)
               throws DBException

Performs modifications on the database.

Parameters:

sqlstatement - Any valid SQL statement

Returns:

boolean (true if the query successfully executes, false o/w)

Throws:

DBException - for invalid SQL Syntax or if the query fails to execute

query

public java.sql.ResultSet query(java.lang.String sqlstatement)
                         throws DBException

Performs a query on an existing database and returns the ResultSet

Parameters:

sqlstatement - Any valid SQL statement

Returns:

ResultSet (never null)

Throws:

DBException - for invalid SQL Syntax

shutdown

public boolean shutdown()
                 throws DBException

Shuts down the database.

Returns:

boolean True if the database was properly shutdown, false o/w

Throws:

DBException

isReady

public boolean isReady()

Boolean for telling if the database is currently running.

Returns:

boolean