com.webstersmalley.mediacollection.database
Class DatabaseConnection

java.lang.Object
  com.webstersmalley.mediacollection.database.DatabaseConnection

public class DatabaseConnection
extends java.lang.Object

Constructor Summary

DatabaseConnection(java.lang.String databaseName, boolean create)

Method Summary

static void	drop(java.lang.String databaseName)
static java.lang.String	escapeString(java.lang.String input)
void	execute(java.lang.String sql)
java.sql.ResultSet	executeQuery(java.lang.String sql)
java.sql.Connection	getConnection()
void	runScript(java.lang.String filename)
void	setConnection(java.sql.Connection connection)
static void	shutdown(java.lang.String databaseName)

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseConnection

public DatabaseConnection(java.lang.String databaseName,
                          boolean create)
                   throws java.lang.ClassNotFoundException,
                          java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

Method Detail

drop

public static void drop(java.lang.String databaseName)
                 throws java.io.IOException

Throws:

java.io.IOException

execute

public void execute(java.lang.String sql)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

getConnection

public java.sql.Connection getConnection()

Returns:

Returns the connection.

setConnection

public void setConnection(java.sql.Connection connection)

Parameters:

connection - The connection to set.

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

runScript

public void runScript(java.lang.String filename)
               throws java.io.IOException,
                      java.sql.SQLException

Throws:

java.io.IOException

java.sql.SQLException

shutdown

public static void shutdown(java.lang.String databaseName)

escapeString

public static java.lang.String escapeString(java.lang.String input)