com.fgm.javaUtils.database

Class DbHelper

java.lang.Object

com.fgm.javaUtils.database.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.sql.Connection	dBconnection The d bconnection.
private java.sql.ResultSet	resultSet The result set.
private java.sql.Statement	statement The statement.

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.
static void	main(java.lang.String[] args) The main method.
java.sql.ResultSet	runPrecompiledInsert(java.lang.String schemaName, java.lang.String tableName, java.util.HashMap<java.lang.String,java.lang.String> valueMap) Build a precompiled inset based on the data types in the table.
java.sql.ResultSet	runRawSQL(java.lang.String stmt) Run an unchecked sql command.
void	setAutoCommit(boolean val)
boolean	tableExists(java.lang.String tableName) See if the named table exists in the database we're using.

Methods inherited from class java.lang.Object

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

Field Detail

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 name (i.e. "jdbc:mysql://localhost:3306/")

database - the mySQL database (i.e. "mySqlDatabase")

driver - the driver (i.e. "com.mysql.jdbc.Driver")

user - the user (i.e. "myUserName")

password - the password (i.e. "myCleverPassword")

Throws:

java.lang.Exception - the exception

setAutoCommit

public void setAutoCommit(boolean val)

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 SQL query ("select * from table_foo")

Returns:

the ResultSet (global, so is accessible after the call in a dangerous, strtok sort of way)

Throws:

java.lang.Exception - the exception

runPrecompiledInsert

public java.sql.ResultSet runPrecompiledInsert(java.lang.String schemaName,
                                      java.lang.String tableName,
                                      java.util.HashMap<java.lang.String,java.lang.String> valueMap)
                                        throws java.lang.Exception

Build a precompiled inset based on the data types in the table. Example follows: HashMap valMap = new HashMap(); valMap.put("name", "Prepared Insert Test"); valMap.put("owner", "3"); valMap.put("xml_layout", ""); valMap.put("published", "1"); DbHelper dbh = new DbHelper(); try { dbh.connect(_hostName, _schema, _driverName, _userName, _passwordString); dbh.runPrecompiledInsert(_schema, _table, valMap); dbh.disconnect(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }

Parameters:

schemaName - the schema name

tableName - the table name

valueMap - the value HashMap

Returns:

the ResultSet

Throws:

java.lang.Exception

getConnection

public java.sql.Connection getConnection()

Gets the connection.

Returns:

the global java.sql.Connection

closeStatement

public void closeStatement()
                    throws java.sql.SQLException

close the current statement if it is open.

Throws:

java.sql.SQLException

tableExists

public boolean tableExists(java.lang.String tableName)

See if the named table exists in the database we're using. If DbHelper is initialized incorrectly, or if the table does not exist, this method will return false

Parameters:

tableName - the table name

Returns:

true, if successful

main

public static void main(java.lang.String[] args)

The main method. For debugging

Parameters:

args - the arguments