com.edgeti.VisibilityServer.UsersAndRoles

Class DbHelper

java.lang.Object

com.edgeti.VisibilityServer.UsersAndRoles.DbHelper

public class DbHelper
extends java.lang.Object

Class to do basic MySQL stuff - connect and disconnect from the MySQL server, ask a query, maintain statements.

Author:

phil.feldman

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.String	database The database.
private java.sql.Connection	dBconnection The d bconnection.
private java.lang.String	driver The driver.
private java.lang.String	host The host.
private java.lang.String	password The password.
private java.sql.ResultSet	resultSet The result set.
private java.sql.Statement	statement The statement.
private java.lang.String	user The user.

Constructor Summary

Constructors

Constructor and Description
DbHelper()

Method Summary

Methods

Modifier and Type	Method and Description
void	closeStatement() close the current statement if it is open.
void	connect(java.lang.String host, java.lang.String database, java.lang.String driver, java.lang.String user, java.lang.String password) connect to database using specified parameters.
void	disconnect() Disconnect from database and clean up.
java.sql.Connection	getConnection() Gets the connection.
java.sql.ResultSet	runRawSQL(java.lang.String stmt) Run an unchecked sql command.

Methods inherited from class java.lang.Object

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

Field Detail

host

private java.lang.String host

The host.

database

private java.lang.String database

The database.

driver

private java.lang.String driver

The driver.

user

private java.lang.String user

The user.

password

private java.lang.String password

The password.

dBconnection

private java.sql.Connection dBconnection

The d bconnection.

statement

private java.sql.Statement statement

The statement.

resultSet

private java.sql.ResultSet resultSet

The result set.

Constructor Detail

DbHelper

public DbHelper()

Method Detail

connect

public void connect(java.lang.String host,
           java.lang.String database,
           java.lang.String driver,
           java.lang.String user,
           java.lang.String password)
             throws java.lang.Exception

connect to database using specified parameters.

Parameters:

host - the host

database - the database

driver - the driver

user - the user

password - the password

Throws:

java.lang.Exception - the exception

disconnect

public void disconnect()

Disconnect from database and clean up.

runRawSQL

public java.sql.ResultSet runRawSQL(java.lang.String stmt)
                             throws java.lang.Exception

Run an unchecked sql command.

Parameters:

stmt - the stmt

Returns:

the result set

Throws:

java.lang.Exception - the exception

getConnection

public java.sql.Connection getConnection()

Gets the connection.

Returns:

the connection

closeStatement

public void closeStatement()
                    throws java.sql.SQLException

close the current statement if it is open.

Throws:

java.sql.SQLException - the SQL exception