public class DbBase
extends java.lang.Object
History:
Constructor and Description |
---|
DbBase() |
Modifier and Type | Method and Description |
---|---|
static void |
CloseConnection(java.sql.Connection conn)
Close a specified connection (session) with a database
|
static void |
CloseConnection(java.sql.Connection conn,
Configuration config)
Close a specified connection (session) with a database
|
static java.lang.String |
FormatSqlStr(java.lang.String in)
Format a regular string to a legal SQL string for "'".
|
static java.sql.Connection |
OpenConnection(Configuration config)
Open a connection using URL specified in configuration bundle
|
static java.sql.Connection |
OpenConnection(java.lang.String driverName,
java.lang.String url,
java.lang.String userName,
java.lang.String password)
Open a connection to a specified URL of the database and specifying
a JDBC driver
|
static void |
ShutdownDb(java.sql.Connection conn,
Configuration config)
Close a specified connection (session) with a database
|
(package private) static void |
SubmitDMLs(java.lang.String query,
Configuration config)
Submit a query to a specific database.
|
public static java.sql.Connection OpenConnection(Configuration config) throws java.sql.SQLException
config
- configuration bundlejava.sql.SQLException
- if there is a database error happenspublic static java.sql.Connection OpenConnection(java.lang.String driverName, java.lang.String url, java.lang.String userName, java.lang.String password) throws java.sql.SQLException
driverName
- JDBC connection driverurl
- JDBC connection URLuserName
- user name for the DBpassword
- password for the DBjava.sql.SQLException
- if there is a database error happenspublic static void CloseConnection(java.sql.Connection conn) throws java.sql.SQLException
conn
- database connectionjava.sql.SQLException
- if there is a database error happenspublic static void CloseConnection(java.sql.Connection conn, Configuration config) throws java.sql.SQLException
conn
- database connectionconfig
- configuration bundlejava.sql.SQLException
- if there is a database error happenspublic static void ShutdownDb(java.sql.Connection conn, Configuration config) throws java.sql.SQLException
conn
- database connectionconfig
- configuration bundlejava.sql.SQLException
- if there is a database error happenspublic static java.lang.String FormatSqlStr(java.lang.String in)
in
- a regualr string used as SQLstatic void SubmitDMLs(java.lang.String query, Configuration config)
query
- a SQL query to be submittedconfig
- LVG configuration obj for DB connection