net.aditsu.depeche

Class SQLQuery

java.lang.Object

java.util.AbstractCollection<E>

java.util.AbstractList<Record>

net.aditsu.depeche.BaseQuery

net.aditsu.depeche.SQLQuery

All Implemented Interfaces:

Serializable, Iterable<Record>, Collection<Record>, List<Record>, IQuery

Direct Known Subclasses:

Query, RawQuery

public abstract class SQLQuery
extends BaseQuery

SQL-based query

Author:

aditsu

See Also:

Serialized Form

Method Summary

Methods

Modifier and Type	Method and Description
void	addParams(List<Serializable> params) Adds a set of parameters for this query, to be executed in a batch
int[]	executeBatch() Executes this query as a batch (INSERT/UPDATE/DELETE) and returns the numbers of affected rows for each set of parameters
Record	getOneRecord(Conn conn) Runs this query as a SELECT (if needed) using the given connection and returns a single record; it throws an exception if the number of results is not 1
abstract List<Serializable>	getParams() Returns this query's parameters
Provider	getProvider() Returns the provider used by this query
ProviderRef	getProviderRef() Returns the provider reference used by this query
Record	getRecord(Conn conn) Runs this query as a SELECT (if needed) using the given connection and returns a single record, or null if there are no results; it throws an exception if there are multiple results
abstract String	getSelectSQL() Returns the SQL string for running this query as a SELECT query
abstract String	getUpdateSQL() Returns the SQL string for running this query as a generic update query
SQLQuery	select() Runs this query as a SELECT (and caches the results)
SQLQuery	select(Conn conn) Runs this query as a SELECT using the given connection (and caches the results)
int	update() Runs this query as an UPDATE and returns the number of rows affected
int	update(Conn conn) Runs this query as an UPDATE using the given connection and returns the number of rows affected

Methods inherited from class net.aditsu.depeche.BaseQuery

clearData, get, getColumn, getColumn, getColumn, getColumn, getColumnInfo, getLocalQuery, getOneRecord, getRecord, hasRun, size

Methods inherited from class java.util.AbstractList

add, add, addAll, clear, equals, hashCode, indexOf, iterator, lastIndexOf, listIterator, listIterator, remove, set, subList

Methods inherited from class java.util.AbstractCollection

addAll, contains, containsAll, isEmpty, remove, removeAll, retainAll, toArray, toArray, toString

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.util.List

add, add, addAll, addAll, clear, contains, containsAll, equals, hashCode, indexOf, isEmpty, iterator, lastIndexOf, listIterator, listIterator, remove, remove, removeAll, retainAll, set, subList, toArray, toArray

Method Detail

getProviderRef

public ProviderRef getProviderRef()

Returns the provider reference used by this query

getProvider

public Provider getProvider()

Returns the provider used by this query

select

public SQLQuery select(Conn conn)

Runs this query as a SELECT using the given connection (and caches the results)

Returns:

this query

select

public SQLQuery select()

Runs this query as a SELECT (and caches the results)

Specified by:

select in interface IQuery

Specified by:

select in class BaseQuery

Returns:

this query

getSelectSQL

public abstract String getSelectSQL()

Returns the SQL string for running this query as a SELECT query

getUpdateSQL

public abstract String getUpdateSQL()

Returns the SQL string for running this query as a generic update query

getParams

public abstract List<Serializable> getParams()

Returns this query's parameters

update

public int update()

Runs this query as an UPDATE and returns the number of rows affected

update

public int update(Conn conn)

Runs this query as an UPDATE using the given connection and returns the number of rows affected

getOneRecord

public Record getOneRecord(Conn conn)

Runs this query as a SELECT (if needed) using the given connection and returns a single record; it throws an exception if the number of results is not 1

getRecord

public Record getRecord(Conn conn)

Runs this query as a SELECT (if needed) using the given connection and returns a single record, or null if there are no results; it throws an exception if there are multiple results

addParams

public void addParams(List<Serializable> params)

Adds a set of parameters for this query, to be executed in a batch

executeBatch

public int[] executeBatch()

Executes this query as a batch (INSERT/UPDATE/DELETE) and returns the numbers of affected rows for each set of parameters