com.raritantechnologies.searchApp.database
Class QueryRunner

java.lang.Object
  com.raritantechnologies.searchApp.database.QueryRunner

public class QueryRunner

extends java.lang.Object

Runs queries against a database. Uses an RTI IDatabaseConnectionManager and an RTI SQLQueryManager.

Developed by Raritan Technologies .

Author:

Alan Connell

Constructor Summary

QueryRunner()

QueryRunner(IDatabaseConnectionManager connManager)

QueryRunner(java.lang.String connManagerName)

QueryRunner(java.lang.String connManagerName, java.lang.String queryManagerName)

Method Summary

void	closeConnection()
java.lang.String	createItemId()
void	finalize() Make sure that we close our connection when we are garbage collected.
java.sql.ResultSet	getResultSet(java.lang.String query)
java.sql.ResultSet	getResultSet(java.lang.String queryName, java.lang.String params)
java.lang.String	getSingleResult(java.lang.String query)
java.lang.String	getSingleResult(java.lang.String queryName, java.lang.String params)
void	openConnection()
void	runUpdate(java.lang.String query)
void	runUpdate(java.lang.String queryName, java.lang.String params)
void	runUpdates(OrderedMap updates)
void	runUpdates(java.lang.String[] queries)

Methods inherited from class java.lang.Object

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

Constructor Detail

QueryRunner

public QueryRunner()

QueryRunner

public QueryRunner(IDatabaseConnectionManager connManager)

QueryRunner

public QueryRunner(java.lang.String connManagerName)

QueryRunner

public QueryRunner(java.lang.String connManagerName,
                   java.lang.String queryManagerName)

Method Detail

openConnection

public void openConnection()

closeConnection

public void closeConnection()

finalize

public void finalize()
              throws java.sql.SQLException

Make sure that we close our connection when we are garbage collected.

Throws:

java.sql.SQLException

createItemId

public java.lang.String createItemId()

getResultSet

public java.sql.ResultSet getResultSet(java.lang.String query)

getSingleResult

public java.lang.String getSingleResult(java.lang.String query)

runUpdate

public void runUpdate(java.lang.String query)

runUpdates

public void runUpdates(java.lang.String[] queries)

runUpdate

public void runUpdate(java.lang.String queryName,
                      java.lang.String params)

runUpdates

public void runUpdates(OrderedMap updates)

getResultSet

public java.sql.ResultSet getResultSet(java.lang.String queryName,
                                       java.lang.String params)

getSingleResult

public java.lang.String getSingleResult(java.lang.String queryName,
                                        java.lang.String params)