com.openrules.tools

Class DatabaseMySQL

java.lang.Object

com.openrules.tools.DatabaseMySQL

public class DatabaseMySQL
extends java.lang.Object

Field Summary

Fields

Modifier and Type	Field and Description
java.lang.String	driver
java.lang.String	dsn
java.lang.String	password
java.lang.String	user_name

Constructor Summary

Constructors

Constructor and Description
DatabaseMySQL(java.lang.String dbName)
DatabaseMySQL(java.lang.String dbName, java.lang.String user, java.lang.String pwd, java.lang.String driver)

Method Summary

Modifier and Type	Method and Description
java.sql.ResultSet	createAndExecuteBriefQuery(java.lang.String tableName)
java.sql.ResultSet	executeQuery(java.lang.String sql)
void	freeConnection()
java.sql.Connection	getConnection()
org.apache.commons.beanutils.ResultSetDynaClass	readDataInstances(java.lang.String tableName)

Methods inherited from class java.lang.Object

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

Field Detail

driver

public java.lang.String driver

dsn

public java.lang.String dsn

user_name

public java.lang.String user_name

password

public java.lang.String password

Constructor Detail

DatabaseMySQL

public DatabaseMySQL(java.lang.String dbName)

DatabaseMySQL

public DatabaseMySQL(java.lang.String dbName,
                     java.lang.String user,
                     java.lang.String pwd,
                     java.lang.String driver)

Method Detail

executeQuery

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

Throws:

java.lang.Exception

freeConnection

public void freeConnection()
                    throws java.lang.Exception

Throws:

java.lang.Exception

getConnection

public java.sql.Connection getConnection()
                                  throws java.lang.Exception

Throws:

java.lang.Exception

createAndExecuteBriefQuery

public java.sql.ResultSet createAndExecuteBriefQuery(java.lang.String tableName)

readDataInstances

public org.apache.commons.beanutils.ResultSetDynaClass readDataInstances(java.lang.String tableName)