au.com.cybersearch2.classyjpa.query

Class NativeQuery

java.lang.Object

au.com.cybersearch2.classyjpa.query.QueryBase

au.com.cybersearch2.classyjpa.query.NativeQuery

All Implemented Interfaces:

javax.persistence.Query

public class NativeQuery
extends QueryBase

NativeQuery Implements javax.persistence.Query using native query. Only a subset of PersistenceUnitAdmin API 1.0 methods supported.

Author:

Andrew Bowley 30/05/2014

Field Summary

Fields

Modifier and Type	Field and Description
static String	TAG

Constructor Summary

Constructors

Constructor and Description
NativeQuery(SqlQuery sqlQuery) Create a NativeQuery object

Method Summary

Methods

Modifier and Type	Method and Description
int	executeUpdate() Execute an update or delete statement.
List<Object>	getResultList() Execute a SELECT query and return the query results as a List.
Object	getSingleResult() Execute a SELECT query that returns a single result.
javax.persistence.Query	setParameter(int position, Calendar value, javax.persistence.TemporalType type) Bind an instance of java.util.Calendar to a positional parameter.
javax.persistence.Query	setParameter(int position, Date value, javax.persistence.TemporalType type) Bind an instance of java.util.Date to a positional parameter.
javax.persistence.Query	setParameter(int position, Object value) Bind an argument to a positional parameter.
javax.persistence.Query	setParameter(String param, Calendar value, javax.persistence.TemporalType type) Bind an instance of java.util.Calendar to a named parameter.
javax.persistence.Query	setParameter(String param, Date value, javax.persistence.TemporalType type) Bind an instance of java.util.Date to a named parameter.
javax.persistence.Query	setParameter(String param, Object value) Bind an argument to a named parameter.

Methods inherited from class au.com.cybersearch2.classyjpa.query.QueryBase

getFirstResult, getFlushMode, getHints, getLockMode, getMaxResults, getParameter, getParameter, getParameter, getParameter, getParameters, getParameterValue, getParameterValue, getParameterValue, isBound, setFirstResult, setFlushMode, setHint, setLockMode, setMaxResults, setParameter, setParameter, setParameter, unwrap

Methods inherited from class java.lang.Object

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

Field Detail

TAG

public static final String TAG

See Also:

Constant Field Values

Constructor Detail

NativeQuery

public NativeQuery(SqlQuery sqlQuery)

Create a NativeQuery object

Parameters:

sqlQuery - Query invoked using Android SQLite interface

Method Detail

executeUpdate

public int executeUpdate()

Execute an update or delete statement. NOT implemented.

Returns:

0

getResultList

public List<Object> getResultList()

Execute a SELECT query and return the query results as a List.

Returns:

List of objects

getSingleResult

public Object getSingleResult()

Execute a SELECT query that returns a single result.

Returns:

Object

Throws:

javax.persistence.NoResultException - if there is no result

setParameter

public javax.persistence.Query setParameter(String param,
                                   Object value)

Bind an argument to a named parameter.

Parameters:

param - The parameter name

value - Object

Returns:

The same query instance

Throws:

IllegalArgumentException - if parameter name does not correspond to parameter in query string

setParameter

public javax.persistence.Query setParameter(int position,
                                   Object value)

Bind an argument to a positional parameter.

Parameters:

position - Starts at 1

value - Object

Returns:

The same query instance

Throws:

IllegalArgumentException - if position does not correspond to positional parameter of query

setParameter

public javax.persistence.Query setParameter(String param,
                                   Date value,
                                   javax.persistence.TemporalType type)

Bind an instance of java.util.Date to a named parameter.

Parameters:

param - The parameter name

value - Date

type - Not used

Returns:

The same query instance

Throws:

IllegalArgumentException - if parameter name does not correspond to parameter in query string

setParameter

public javax.persistence.Query setParameter(String param,
                                   Calendar value,
                                   javax.persistence.TemporalType type)

Bind an instance of java.util.Calendar to a named parameter.

Parameters:

param - The parameter name

value - Calendar

type - Not used

Returns:

The same query instance

Throws:

IllegalArgumentException - if parameter name does not correspond to parameter in query string

setParameter

public javax.persistence.Query setParameter(int position,
                                   Date value,
                                   javax.persistence.TemporalType type)

Bind an instance of java.util.Date to a positional parameter.

Parameters:

position - Starts at 1

value - Date

type - Not used

Returns:

The same query instance

Throws:

IllegalArgumentException - if position does not correspond to positional parameter of query

setParameter

public javax.persistence.Query setParameter(int position,
                                   Calendar value,
                                   javax.persistence.TemporalType type)

Bind an instance of java.util.Calendar to a positional parameter.

Parameters:

position - Starts at 1

value - Calendar

type - Not used

Returns:

The same query instance

Throws:

IllegalArgumentException - if position does not correspond to positional parameter of query