com.ebay.carad.os.vitalsigns.dao
Interface ISqlDAO

All Known Implementing Classes:

SqlDAO

public interface ISqlDAO

Defines an interface for executing arbitrary SQL against a database. Used to assist in accessing raw data for arbitrary reports, or as a data source from which data can be pulled to be logged as a DataPoint for a "data in timeline" type report.

Version:

$Id$

Author:

Jeremy Kraybill, Jeremy Thomerson

Method Summary

java.util.List	findBySqlQuery(java.lang.String query) Executes an arbitrary SQL select statement against the configured connection, and returns the result as a List of Maps (via Commons DbUtils).
int	updateWithSQL(java.lang.String query) Executes an arbitrary SQL UPDATE or INSERT statement against the configured connection.

Method Detail

findBySqlQuery

java.util.List findBySqlQuery(java.lang.String query)

Executes an arbitrary SQL select statement against the configured connection, and returns the result as a List of Maps (via Commons DbUtils).

Parameters:

query - the SQL query to run

Returns:

a list of maps

updateWithSQL

int updateWithSQL(java.lang.String query)

Executes an arbitrary SQL UPDATE or INSERT statement against the configured connection.

Parameters:

query - the SQL query to run

Returns:

the number of affected rows