Package com.version1.DataBaseManagement

Class DatabaseHelper

java.lang.Object

com.version1.DataBaseManagement.DatabaseHelper

public class DatabaseHelper
extends Object

Database helper utility class providing support methods for DataBase connection and executing the queries JDBC configuration is fetched from config.json

Field Summary

Fields

Modifier and Type	Field	Description
protected static Connection	conn
static Map<String,Object>	DBConfig

Constructor Summary

Constructors

Constructor	Description
DatabaseHelper()

Method Summary

Modifier and Type	Method	Description
List	executeQuery(String sqlQuery)	Executed the Query to the database
protected org.apache.commons.dbutils.QueryRunner	getQueryRunner()	Creates the instance of the QuerryRunner class QuerryRunner class executes SQL queries with pluggable strategies for handling ResultSets
protected static Connection	setUpConnection()	Steps up the connection to the database using the jdbc configurations

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

conn

protected static Connection conn

DBConfig

public static Map<String,Object> DBConfig

Constructor Details

DatabaseHelper

public DatabaseHelper()

Method Details

setUpConnection

protected static Connection setUpConnection()

Steps up the connection to the database using the jdbc configurations

executeQuery

public List executeQuery(String sqlQuery)
                  throws SQLException

Executed the Query to the database

Parameters:

sqlQuery - to be executed in the database

Returns:

List of values returned by the executed Query

Throws:

SQLException

getQueryRunner

protected org.apache.commons.dbutils.QueryRunner getQueryRunner()

Creates the instance of the QuerryRunner class QuerryRunner class executes SQL queries with pluggable strategies for handling ResultSets

Returns:

QueryRunner the instance of the QueryRunner class