com.fgm.javaUtils.SQLScriptRunner

Class MySQLConnector

java.lang.Object

com.fgm.javaUtils.SQLScriptRunner.MySQLConnector

public class MySQLConnector
extends java.lang.Object

The Class MySQLConnector.

Field Summary

Fields

Modifier and Type	Field and Description
static int	connectCounter The connect counter.
private java.lang.String	database The database.
private java.sql.Connection	dBconnection The d bconnection.
static boolean	debugFlag The debug flag.
private java.lang.String	driver The driver.
private static boolean	FAIL The Constant FAIL.
private java.lang.String	host The host.
protected org.apache.log4j.Logger	logger The logger.
private java.lang.String	password The password.
private static java.lang.String	PROP_FILE Name of the properties file which must exist on the classpath.
private java.sql.ResultSet	resultSet The result set.
private java.lang.String	sqlStr The sql str.
private java.sql.Statement	statement The statement.
private static boolean	SUCCESS The Constant SUCCESS.
static java.lang.String	TABLE_INFO_NAME The Constant TABLE_INFO_NAME.
private java.lang.String	user The user.

Constructor Summary

Constructors

Constructor and Description
MySQLConnector() Instantiates a new my sql connector.
MySQLConnector(java.lang.String host, java.lang.String user, java.lang.String password, java.lang.String database, java.lang.String driver) Instantiates a new my sql connector.

Method Summary

Methods

Modifier and Type	Method and Description
java.sql.Connection	connect() Connect.
java.sql.Connection	connect(java.lang.String user, java.lang.String password) Connect.
void	disconnect() Disconnect.
java.sql.Connection	getConnection() Gets the connection.
java.sql.ResultSet	runRawSQL(java.lang.String stmt) Run an unchecked sql command.
private boolean	SQLError(java.lang.Exception e, java.lang.String sqlStr) SQL error.
void	terminate() Terminate.

Methods inherited from class java.lang.Object

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

Field Detail

PROP_FILE

private static final java.lang.String PROP_FILE

Name of the properties file which must exist on the classpath.

See Also:

Constant Field Values

TABLE_INFO_NAME

public static final java.lang.String TABLE_INFO_NAME

The Constant TABLE_INFO_NAME.

See Also:

Constant Field Values

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.

sqlStr

private java.lang.String sqlStr

The sql str.

debugFlag

public static boolean debugFlag

The debug flag.

SUCCESS

private static final boolean SUCCESS

The Constant SUCCESS.

See Also:

Constant Field Values

FAIL

private static final boolean FAIL

The Constant FAIL.

See Also:

Constant Field Values

connectCounter

public static int connectCounter

The connect counter.

logger

protected org.apache.log4j.Logger logger

The logger.

Constructor Detail

MySQLConnector

public MySQLConnector()

Instantiates a new my sql connector.

MySQLConnector

public MySQLConnector(java.lang.String host,
              java.lang.String user,
              java.lang.String password,
              java.lang.String database,
              java.lang.String driver)

Instantiates a new my sql connector.

Parameters:

host - the host

user - the user

password - the password

database - the database

driver - the driver

Method Detail

SQLError

private boolean SQLError(java.lang.Exception e,
               java.lang.String sqlStr)

SQL error.

Parameters:

e - the e

sqlStr - the sql str

Returns:

true, if successful

connect

public java.sql.Connection connect()

Connect.

Returns:

the connection

connect

public java.sql.Connection connect(java.lang.String user,
                          java.lang.String password)

Connect.

Parameters:

user - the user

password - the password

Returns:

the connection

disconnect

public void disconnect()

Disconnect.

getConnection

public java.sql.Connection getConnection()

Gets the connection.

Returns:

the connection

terminate

public void terminate()

Terminate.

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