public class DatabaseUtil
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
DB_CONNECTION_URL |
static java.lang.String |
DB_DRIVER_CLASS |
static java.lang.String |
DB_PWD |
static java.lang.String |
DB_USER |
Constructor and Description |
---|
DatabaseUtil() |
Modifier and Type | Method and Description |
---|---|
static void |
close(java.sql.Connection conn)
close connection if not null ignoring exception if any |
static void |
close(java.sql.PreparedStatement ps)
close PreparedStatement if not null ignoring exception if any |
static void |
close(java.sql.PreparedStatement ps,
java.sql.ResultSet rs)
Utility method to close result-set and statement if not not and ignoring exception if any
|
static void |
close(java.sql.ResultSet rs)
close result set if not null ignoring exception if any |
static void |
close(java.sql.Statement s)
close Statement if not null ignoring exception if any |
static void |
close(java.sql.Statement st,
java.sql.ResultSet rs)
Utility method to close result-set and statement if not not and ignoring exception if any
|
static java.sql.Connection |
getConnection()
For default data base configuration, Creates data base connection using following properties:
db.driver.class
db.connection.url
db.user
db.pwd
|
static java.sql.Connection |
getConnection(java.lang.String prefix)
If you want to use multiple data bases in the project.
|
static java.sql.Connection |
getConnection(java.lang.String driverCls,
java.lang.String url,
java.lang.String user,
java.lang.String pwd) |
static java.lang.Object[][] |
getData(java.lang.String query) |
static java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
getRecordAsMap(java.lang.String query)
use this method when you want to run query using default database configuration
|
static java.util.List<java.util.Map<java.lang.String,java.lang.Object>> |
getRecordAsMap(java.lang.String connectionPrefix,
java.lang.String query)
Use this method if you have multiple database configuration.
|
static java.lang.Object[][] |
getRecordDataAsMap(java.lang.String query) |
public static final java.lang.String DB_CONNECTION_URL
public static final java.lang.String DB_DRIVER_CLASS
public static final java.lang.String DB_USER
public static final java.lang.String DB_PWD
public static void close(java.sql.PreparedStatement ps)
close PreparedStatement
if not null ignoring exception if anyps
- public static void close(java.sql.Statement s)
close Statement
if not null ignoring exception if anys
- public static void close(java.sql.PreparedStatement ps, java.sql.ResultSet rs)
ps
- rs
- public static void close(java.sql.Statement st, java.sql.ResultSet rs)
st
- rs
- public static void close(java.sql.ResultSet rs)
close result set
if not null ignoring exception if anyrs
- public static void close(java.sql.Connection conn)
close connection
if not null ignoring exception if anyconn
- public static java.sql.Connection getConnection() throws java.lang.Exception
Connection
objectjava.lang.Exception
public static java.sql.Connection getConnection(java.lang.String prefix) throws java.lang.Exception
defualt
another database configuration
getConnection("con1")
prefix
- - prefix of the database configuration to be usedjava.lang.Exception
public static java.sql.Connection getConnection(java.lang.String driverCls, java.lang.String url, java.lang.String user, java.lang.String pwd) throws java.lang.Exception
driverCls
- url
- user
- pwd
- Connection
objectjava.lang.Exception
public static java.lang.Object[][] getData(java.lang.String query)
query
- public static java.lang.Object[][] getRecordDataAsMap(java.lang.String query)
query
- public static java.util.List<java.util.Map<java.lang.String,java.lang.Object>> getRecordAsMap(java.lang.String query)
query
- public static java.util.List<java.util.Map<java.lang.String,java.lang.Object>> getRecordAsMap(java.lang.String connectionPrefix, java.lang.String query)
connectionPrefix
- query
- getConnection(String)
Copyright © 2000 Infostretch Corp.