net.sf.borg.model.db.jdbc

Class JdbcDB

java.lang.Object

net.sf.borg.model.db.jdbc.JdbcDB

final class JdbcDB
extends Object

class providing basic common JDBC services

Field Summary

Fields

Modifier and Type	Field and Description
protected static Connection	connection_

Constructor Summary

Constructors

Constructor and Description
JdbcDB()

Method Summary

Methods

Modifier and Type	Method and Description
static void	beginTransaction() begin a JDBC transaction on the shared connection
static String	buildDbDir() Builds the db url from the user's settings.
static void	close() Close the open connection and shutdown the db (if HSQL)
static void	commitTransaction() commit a JDBC transaction on the shared connection
static void	connect(String urlIn) Connect to the database.
static ResultSet	execSQL(String sql) Execute arbitrary SQL against the open JDBC connection
static Connection	getConnection() Gets the connection.
static String	getUrl() Gets the JDBC url.
static void	rollbackTransaction() rollback a JDBC transaction on the shared connection
static int	toInt(boolean in)
static int	toInt(Integer in)
static String	toStr(Vector<String> v)
static Vector<String>	toVect(String s)

Methods inherited from class java.lang.Object

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

Field Detail

connection_

protected static Connection connection_

Constructor Detail

JdbcDB

JdbcDB()

Method Detail

getUrl

public static String getUrl()

Gets the JDBC url.

Returns:

the JDBC url

beginTransaction

public static void beginTransaction()
                             throws Exception

begin a JDBC transaction on the shared connection

Throws:

Exception

commitTransaction

public static final void commitTransaction()
                                    throws Exception

commit a JDBC transaction on the shared connection

Throws:

Exception

rollbackTransaction

public static final void rollbackTransaction()
                                      throws Exception

rollback a JDBC transaction on the shared connection

Throws:

Exception

connect

public static void connect(String urlIn)
                    throws Exception

Connect to the database. The logic varies based on the URL. Supports MYSQL, HSQL For HSQL - if the DB doesn't exist, it will be created

Parameters:

urlIn - the JDBC url

Throws:

Exception - the exception

toStr

public static final String toStr(Vector<String> v)

toInt

public static final int toInt(Integer in)

toInt

public static final int toInt(boolean in)

toVect

public static final Vector<String> toVect(String s)

execSQL

public static final ResultSet execSQL(String sql)
                               throws Exception

Execute arbitrary SQL against the open JDBC connection

Parameters:

sql - the sql

Returns:

the result set

Throws:

Exception - the exception

getConnection

public static Connection getConnection()

Gets the connection.

Returns:

the connection

close

public static void close()
                  throws Exception

Close the open connection and shutdown the db (if HSQL)

Throws:

Exception - the exception

buildDbDir

public static String buildDbDir()

Builds the db url from the user's settings. Supports HSQL, MYSQL, generic JDBC

Returns:

the jdbc url