com.openrules.tools

Class DbUtil

java.lang.Object

com.openrules.tools.DbUtil

public class DbUtil
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DbUtil.DbEnv

Constructor Summary

Constructors

Constructor and Description
DbUtil(DbUtil.DbEnv env)

Method Summary

Modifier and Type	Method and Description
int	count(java.lang.String tableName)
java.sql.ResultSet	executeQuery(java.lang.String sql)
void	freeConnection()
java.lang.String[]	getArray(java.lang.String tableName, java.lang.String columnName)
java.lang.String[]	getArrayFromDB(java.lang.String dbName, java.lang.String tableName, java.lang.String columnName)
java.sql.Connection	getConnection()
static DbUtil	getDBInstance(java.lang.String dbName)
static DbUtil	getDBInstance(java.lang.String dbName, java.lang.String user, java.lang.String pwd, java.lang.String driver)
java.sql.ResultSet	selectAll(java.lang.String tableName)

Methods inherited from class java.lang.Object

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

Constructor Detail

DbUtil

public DbUtil(DbUtil.DbEnv env)

Method Detail

getDBInstance

public static DbUtil getDBInstance(java.lang.String dbName)

getDBInstance

public static DbUtil getDBInstance(java.lang.String dbName,
                                   java.lang.String user,
                                   java.lang.String pwd,
                                   java.lang.String driver)

count

public int count(java.lang.String tableName)
          throws java.lang.Exception

Throws:

java.lang.Exception

selectAll

public java.sql.ResultSet selectAll(java.lang.String tableName)
                             throws java.lang.Exception,
                                    java.lang.Exception

Throws:

java.lang.Exception

getArray

public java.lang.String[] getArray(java.lang.String tableName,
                                   java.lang.String columnName)
                            throws java.lang.Exception

Throws:

java.lang.Exception

getArrayFromDB

public java.lang.String[] getArrayFromDB(java.lang.String dbName,
                                         java.lang.String tableName,
                                         java.lang.String columnName)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

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