au.com.cybersearch2.classyjpa.query

Class SqlQuery

java.lang.Object

au.com.cybersearch2.classyjpa.query.SqlQuery

public class SqlQuery
extends Object

SqlQuery Implements javax.persistence.Query invoked using an Android SQLite interface. The SQL is executed with OrmLite JDBC when not running on Android.

Author:

Andrew Bowley 10/07/2014

Field Summary

Fields

Modifier and Type	Field and Description
static String	TAG

Constructor Summary

Constructors

Constructor and Description
SqlQuery(PersistenceAdmin persistenceAdmin, QueryInfo queryInfo) Create SqlQuery object

Method Summary

Methods

Modifier and Type	Method and Description
Object	getResultObject() Execute query and return a single Object result
List<?>	getResultObjectList() Execute query and return results as a list of Objects
List<?>	getResultObjectList(int startPosition, int maxResults) Execute query and return results as a list of Objects
boolean	setParam(int position, Object value) Set parameter value referenced by position
boolean	setParam(String param, Object value) Set parameter referenced by name
String	toString() Returns a string representation of the object.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

TAG

public static final String TAG

See Also:

Constant Field Values

Constructor Detail

SqlQuery

public SqlQuery(PersistenceAdmin persistenceAdmin,
        QueryInfo queryInfo)

Create SqlQuery object

Parameters:

persistenceAdmin - JPA Support

queryInfo - Native query information

Method Detail

getResultObjectList

public List<?> getResultObjectList()

Execute query and return results as a list of Objects

Returns:

Object list

getResultObjectList

public List<?> getResultObjectList(int startPosition,
                          int maxResults)

Execute query and return results as a list of Objects

Returns:

Object list

getResultObject

public Object getResultObject()

Execute query and return a single Object result

Returns:

Object or null if nothing returned by query

setParam

public boolean setParam(int position,
               Object value)

Set parameter value referenced by position

Parameters:

position - Starts at 1

value - Object

Returns:

boolean - true if position is valid, otherwise false

setParam

public boolean setParam(String param,
               Object value)

Set parameter referenced by name

Parameters:

param -

value - Object

Returns:

boolean - true if name is valid, otherwise false

toString

public String toString()

Returns a string representation of the object.

Overrides:

toString in class Object

See Also:

Object.toString()