|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.qriterium.dogma.BaseConnection
public class BaseConnection
The BaseConnection class handles the database connection and query handling of the Dogma ResourceBase. A ResourceBase can have only one BaseConnection to handle it's queries. Notice that there are no exception handling, this is done with the ResourceBase class. The BaseConnection assumes that it uses HSQLDB, but it can be altered to use other kinds of databases as well, provided that these databases have an available JDBC driver.
Constructor Summary | |
---|---|
BaseConnection(java.lang.String dbtype,
java.lang.String db,
java.lang.String user,
java.lang.String pass)
Creates a BaseConnection. |
Method Summary | |
---|---|
void |
closeConnection()
closeConnection closeConnection method closes the database connection. |
void |
sqlExec(java.lang.String sql)
sqlExec executes an SQL command, typically an INSERT, DELETE or UPDATE command. |
java.sql.ResultSet |
sqlQuery(java.lang.String sql)
sqlQuery executes an SQL query, typically SELECT. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public BaseConnection(java.lang.String dbtype, java.lang.String db, java.lang.String user, java.lang.String pass) throws java.sql.SQLException
dbtype
- db
- user
- pass
-
java.sql.SQLException
Method Detail |
---|
public java.sql.ResultSet sqlQuery(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
public void sqlExec(java.lang.String sql) throws java.sql.SQLException
sql
-
java.sql.SQLException
public void closeConnection() throws java.sql.SQLException
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |