com.raritantechnologies.eCommerceAdmin
Class QueryRunner

java.lang.Object
  com.raritantechnologies.eCommerceAdmin.QueryRunner

public class QueryRunner

extends java.lang.Object

Utility class for executing SQL queries in an eCommerce application.

Developed by Raritan Technologies Inc..

Author:

Alan Connell

Field Summary

static java.lang.String

EMPTY_TOKEN

Constructor Summary

QueryRunner()

Method Summary

void	closeConnection()
void	finalize()
java.sql.ResultSet	getResultSet(java.lang.String query)
java.sql.ResultSet	getResultSet(java.lang.String queryName, java.lang.String params)
java.sql.ResultSet	getResultSet(java.lang.String queryName, java.lang.String params, boolean allowBlankParams)
java.lang.String	getSingleResult(java.lang.String query)
java.lang.String	getSingleResult(java.lang.String queryName, java.lang.String params)
java.lang.String	getSingleResult(java.lang.String queryName, java.lang.String params, boolean allowBlankParams)
static void	printDiagnosticResults(java.lang.String query)
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

Field Detail

EMPTY_TOKEN

public static final java.lang.String EMPTY_TOKEN

See Also:

Constant Field Values

Constructor Detail

QueryRunner

public QueryRunner()

Method Detail

closeConnection

public void closeConnection()

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)

getResultSet

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

getSingleResult

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

getSingleResult

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

printDiagnosticResults

public static void printDiagnosticResults(java.lang.String query)

finalize

public void finalize()
              throws java.sql.SQLException

Throws:

java.sql.SQLException