|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.bitmechanic.maxq.DBUtil
public class DBUtil
Utility class used to simplify database operations from within MaxQ python scripts.
Constructor Summary | |
---|---|
DBUtil(java.lang.String driver,
java.lang.String url,
java.util.Properties props)
Oopens a database connection using the properties provided. |
|
DBUtil(java.lang.String driver,
java.lang.String url,
java.lang.String username,
java.lang.String pw)
Opens a database connection using the parameters provided. |
Method Summary | |
---|---|
void |
close()
Closes the JDBC Connection associated with this instance. |
int |
execute(java.lang.String sql)
Executes the INSERT/UPDATE/DELETE statement passed in. |
java.sql.Connection |
getConnection()
Returns the JDBC Connection object associated with this object. |
java.util.HashMap |
loadRow(java.lang.String sql)
Executes the SELECT statement passed in. |
java.util.ArrayList |
loadRows(java.lang.String sql)
Executes the SELECT statement passed in. |
java.lang.String |
loadVal(java.lang.String sql)
Executes the SELECT statement passed in. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public DBUtil(java.lang.String driver, java.lang.String url, java.lang.String username, java.lang.String pw) throws java.lang.Exception
driver
- Class name of the JDBC driver to useurl
- JDBC URL to connect tousername
- Database username to connect aspw
- Database password
java.lang.Exception
public DBUtil(java.lang.String driver, java.lang.String url, java.util.Properties props) throws java.lang.Exception
driver
- Class name of the JDBC driver to useurl
- JDBC URL to connect toprops
- JDBC properties to connect with
java.lang.Exception
Method Detail |
---|
public java.sql.Connection getConnection()
public int execute(java.lang.String sql) throws java.lang.Exception
java.lang.Exception
public java.util.ArrayList loadRows(java.lang.String sql) throws java.lang.Exception
sql
- SELECT query to run
java.lang.Exception
public java.util.HashMap loadRow(java.lang.String sql) throws java.lang.Exception
sql
- SELECT query to run.
java.lang.Exception
public java.lang.String loadVal(java.lang.String sql) throws java.lang.Exception
sql
- SELECT query to run
java.lang.Exception
public void close() throws java.lang.Exception
java.lang.Exception
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |