public interface DataAccessTemplate
| Modifier and Type | Interface and Description |
|---|---|
static class |
DataAccessTemplate.DatabaseType
Lists the supported database types.
|
| Modifier and Type | Method and Description |
|---|---|
void |
closeObjects(java.sql.Statement query,
java.sql.ResultSet data)
Clean up DB objects.
|
boolean |
connect()
Connects to the data connection information provided.
|
java.sql.Statement |
executeNonSelect(java.lang.String sql)
Executes an SQL non-select query and returns the record change count.
|
int |
executeNonSelectRowChange(java.lang.String sql)
Executes an SQL non-select query and returns the record change count.
|
java.sql.Statement |
executeSelect(java.lang.String sql)
Executes an SQL select query and returns the Statement object with data.
|
java.sql.ResultSet |
executeSelectResultSet(java.lang.String sql)
Executes an SQL select query and returns the ResultSet object with data.
|
boolean |
getAutoCommit()
Auto commit getter.
|
java.sql.Connection |
getConnection()
Returns a reference to the connection object.
|
java.sql.Statement |
getData(java.lang.String sql)
Runs an SQL query.
|
java.lang.String |
getPassword()
Password getter.
|
java.lang.String |
getPort()
Port number getter.
|
java.lang.String |
getServer()
Server name getter.
|
java.lang.String |
getSid()
The SID for Oracle 10G databases, the schema for Mysql databases.
|
java.lang.String |
getSqlEscapeChar()
SQL escape character getter.
|
DataAccessTemplate.DatabaseType |
getType()
Database type getter.
|
java.lang.String |
getUsername()
Username getter.
|
void |
setAutoCommit(boolean b)
Auto commit setter.
|
void |
setConnInfo(java.lang.String uname,
java.lang.String pword,
java.lang.String prt,
java.lang.String SID,
java.lang.String svr)
Standard connection initialization method.
|
void |
SetPassword(java.lang.String s)
Password setter.
|
void |
SetPort(java.lang.String s)
Port number setter.
|
void |
setServer(java.lang.String s)
Server name setter.
|
void |
setSid(java.lang.String s)
The SID for Oracle 10G databases, the schema name for Mysql databases.
|
void |
setSqlEscapeChar(java.lang.String s)
SQL escape character setter.
|
void |
setType(DataAccessTemplate.DatabaseType t)
Database type setter.
|
void |
SetUsername(java.lang.String s)
Username setter.
|
void closeObjects(java.sql.Statement query,
java.sql.ResultSet data)
query - Statement object to close.data - ResultSet object to close.void setConnInfo(java.lang.String uname,
java.lang.String pword,
java.lang.String prt,
java.lang.String SID,
java.lang.String svr)
uname - Database username.pword - Database password.prt - Database port.SID - Database SID on Oracle connections, SCHEMA for MYSQL connections, INSTANCE for MSSQL connections.svr - The target server hosting the database.boolean connect()
setConnInfojava.sql.Connection getConnection()
connectjava.sql.Statement getData(java.lang.String sql)
sql - Oracle query text.connectjava.sql.Statement executeSelect(java.lang.String sql)
throws java.lang.Exception
sql - A valid SQL select statement to execute.java.lang.Exception - Throws a generic exception.Statementjava.sql.ResultSet executeSelectResultSet(java.lang.String sql)
throws java.lang.Exception
sql - A valid SQL select statement to execute.java.lang.Exception - Throws a generic exception.ResultSetjava.sql.Statement executeNonSelect(java.lang.String sql)
throws java.lang.Exception
sql - A valid SQL select statement to execute.java.lang.Exception - Throws a generic exception.int executeNonSelectRowChange(java.lang.String sql)
throws java.lang.Exception
sql - A valid SQL select statement to execute.java.lang.Exception - Throws a generic exception.java.lang.String getSqlEscapeChar()
void setSqlEscapeChar(java.lang.String s)
s - The SQL escape character that should be used with the current database.java.lang.String getUsername()
void SetUsername(java.lang.String s)
s - The database connection username.java.lang.String getPassword()
void SetPassword(java.lang.String s)
s - The database connection password.java.lang.String getPort()
void SetPort(java.lang.String s)
s - The database port number.java.lang.String getServer()
void setServer(java.lang.String s)
s - The database server.java.lang.String getSid()
void setSid(java.lang.String s)
s - The SID for Oracle databases, the schema name for Mysql databases.DataAccessTemplate.DatabaseType getType()
void setType(DataAccessTemplate.DatabaseType t)
t - A valid database type entry.boolean getAutoCommit()
void setAutoCommit(boolean b)
b - If auto commit is false commits have to be done manually by the dataAccess implementation.
If auto commit is true the database is automatically committing queries.