|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectfootyquiz.server.integration.DatabaseConnector
public class DatabaseConnector
Database Connector connects to the database using connection pooling.
Constructor Summary | |
---|---|
DatabaseConnector()
Default constructor, that uses dbname in setup file |
|
DatabaseConnector(java.sql.Connection connection)
Constructor creates an instance with the connection passed to it. |
Method Summary | |
---|---|
boolean |
closeConnection()
Kills the database connection. |
boolean |
commit()
This method commits the data to the database if transaction is set to true. |
boolean |
createConnection()
Connects to the database. |
java.util.List<java.util.Map> |
executeQuery(java.lang.String sql,
boolean autoconnect)
Executes sql, that wil return the results in an Arraylist. |
java.util.List<java.util.Map> |
executeQuery(java.lang.String sql,
java.util.List<java.lang.String> values,
boolean autoconnect)
SQL queries with where conditions should be run here. |
boolean |
executeSQL(java.lang.String sql,
java.util.List<java.lang.String> values,
boolean autoconnect)
Executes SQL quary using the sql string pased to it. |
boolean |
rollback()
This method rolls back if transaction is set to true. |
void |
setAutocommit(boolean value)
Sets the transaction control to the database. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public DatabaseConnector()
public DatabaseConnector(java.sql.Connection connection)
connection
- -
Connection used to connect to databaseMethod Detail |
---|
public boolean createConnection()
public boolean closeConnection()
public boolean executeSQL(java.lang.String sql, java.util.List<java.lang.String> values, boolean autoconnect)
sql
- -
SQL to executeautoconnect
- -
If true, database connection will be opened
public void setAutocommit(boolean value)
value
- if true, database autocommitspublic boolean commit()
public boolean rollback()
public java.util.List<java.util.Map> executeQuery(java.lang.String sql, java.util.List<java.lang.String> values, boolean autoconnect)
sql
- values
-
public java.util.List<java.util.Map> executeQuery(java.lang.String sql, boolean autoconnect)
sql
- -
Query to executeautoconnect
- -
if true, connects db automatically
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |