com.directmediatips.database

Class DatabaseConnection

java.lang.Object

com.directmediatips.database.DatabaseConnection

public class DatabaseConnection
extends Object

Wrapper for the java.sql.Connection class.

Field Summary

Fields

Modifier and Type	Field and Description
protected Connection	connection The actual connection.
protected static String	PROPS Path to the properties file to make the DB connection:.

Constructor Summary

Constructors

Constructor and Description
DatabaseConnection() Creates a database connection by reading the connection details from a properties file.

Method Summary

Modifier and Type	Method and Description
void	close() Closes the connection and throws a runtime exception if not successful.
ResultSet	execute(String sql) Executes a simple SQL query and returns a result set.
PreparedStatement	prepare(String sql) Creates a prepared statement.

Methods inherited from class java.lang.Object

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

Field Detail

PROPS

protected static final String PROPS

Path to the properties file to make the DB connection:.

See Also:

Constant Field Values

connection

protected Connection connection

The actual connection.

Constructor Detail

DatabaseConnection

public DatabaseConnection()
                   throws IOException,
                          SQLException

Creates a database connection by reading the connection details from a properties file.

Throws:

IOException - Signals that an I/O exception has occurred.

SQLException - the SQL exception

Method Detail

execute

public ResultSet execute(String sql)
                  throws SQLException

Executes a simple SQL query and returns a result set.

Parameters:

sql - the SQL query

Returns:

a ResultSet

Throws:

SQLException - the SQL exception

prepare

public PreparedStatement prepare(String sql)
                          throws SQLException

Creates a prepared statement.

Parameters:

sql - the SQL template for the query

Returns:

a prepared statement

Throws:

SQLException - the SQL exception

close

public void close()

Closes the connection and throws a runtime exception if not successful.