footyquiz.server.integration
Class DatabaseConnector

java.lang.Object
  extended by footyquiz.server.integration.DatabaseConnector

public class DatabaseConnector
extends java.lang.Object

Database Connector connects to the database using connection pooling.

Author:
Mikael Kopteff & Hannu Leinonen

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

DatabaseConnector

public DatabaseConnector()
Default constructor, that uses dbname in setup file


DatabaseConnector

public DatabaseConnector(java.sql.Connection connection)
Constructor creates an instance with the connection passed to it. When connection passed to it, createConnection() -method is obsolete.

Parameters:
connection - - Connection used to connect to database
Method Detail

createConnection

public boolean createConnection()
Connects to the database. Return true if connection created succefully.

Returns:
true if successful

closeConnection

public boolean closeConnection()
Kills the database connection. Returns true if connection closed succesfully.

Returns:
true if successful

executeSQL

public 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. If autoconnect is true method opens db itself.

Parameters:
sql - - SQL to execute
autoconnect - - If true, database connection will be opened
Returns:
- true is execution succesfull

setAutocommit

public void setAutocommit(boolean value)
Sets the transaction control to the database.

Parameters:
value - if true, database autocommits

commit

public boolean commit()
This method commits the data to the database if transaction is set to true.


rollback

public boolean rollback()
This method rolls back if transaction is set to true.

Returns:
true if succesful

executeQuery

public 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. The list of values to be out in the Statement is given as parameter.

Parameters:
sql -
values -
Returns:
A List of HashMaps where the results can be found.

executeQuery

public java.util.List<java.util.Map> executeQuery(java.lang.String sql,
                                                  boolean autoconnect)
Executes sql, that wil return the results in an Arraylist. Methods breaks-down the resultset into HashMap in an arraylist.

Parameters:
sql - - Query to execute
autoconnect - - if true, connects db automatically
Returns:
- ArrayList values from query