oracle.lite.resource

Class Query

java.lang.Object

oracle.lite.resource.SqlUpdate

oracle.lite.resource.Query

public class Query
extends SqlUpdate

Helper class to query database objects. An instance of this class obtains the java.sql.Statement from the ResourceManager and executes the SQL query.

Constructor Summary

Constructors

Constructor and Description
Query(java.lang.String sql) Construct a Query object
Query(java.lang.String sql, java.lang.Object[] par) Construct a Query object with bind parameters

Method Summary

Methods

Modifier and Type	Method and Description
void	close() Close the query and result-set objects
void	executeQuery(java.lang.Object[] par) Execute the Query with new bind parameters.
void	executeQuery(java.lang.String sql) Execute a SQL query.
int	executeUpdate(java.lang.String sql) Execute a non-query SQL statement
Address	getAddress(Device dev) Create a oracle.lite.resource.Address object from the query result.
Application	getApplication() Create a oracle.lite.resource.Application object from the query result.
java.sql.Blob	getBlob(int idx) Retrieve the blob value from the query result.
Device	getDevice(User usr) Create a oracle.lite.resource.Device object from the query result.
DeviceCommand	getDeviceCommand(Device dev) Create a oracle.lite.resource.dm.DeviceCommand object from the query result.
Group	getGroup() Create a oracle.lite.resource.Group object from the query result.
java.io.InputStream	getInputStream(int idx) Retrieve the java.io.InputStream value from the query result.
int	getInt(int idx) Retrieve the 'int' value from the query result.
Language	getLanguage() Create a oracle.lite.resource.Language object from the query result.
Log	getLog() Create a oracle.lite.resource.Log object from the query result.
long	getLong(int idx) Retrieve the 'long' value from the query result.
Platform	getPlatform() Create a oracle.lite.resource.Platform object from the query result.
Provider	getProvider() Create a oracle.lite.resource.Provider object from the query result.
QueueData	getQueueData(Device dev) Create a oracle.lite.resource.dm.QueueData object from the query result.
Role	getRole() Create a oracle.lite.resource.Role object from the query result.
java.lang.String	getString(int idx) Retrieve the string value from the query result.
java.sql.Timestamp	getTimestamp(int idx) Retrieve the java.sql.Timestamp value from the query result.
User	getUser() Create a oracle.lite.resource.User object from the query result.
boolean	next() Move to the next cursor

Methods inherited from class oracle.lite.resource.SqlUpdate

bind, close, executeUpdate, executeUpdate, executeUpdate

Methods inherited from class java.lang.Object

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

Constructor Detail

Query

public Query(java.lang.String sql)
      throws java.sql.SQLException

Construct a Query object

Parameters:

sql - SQL statement to be executed (optional)

Throws:

lava.sql.SQLException

java.sql.SQLException

Query

public Query(java.lang.String sql,
     java.lang.Object[] par)
      throws java.sql.SQLException

Construct a Query object with bind parameters

Parameters:

sql - SQL statement to be executed

par - SQL statement bind parameters

Throws:

lava.sql.SQLException

java.sql.SQLException

Method Detail

close

public void close()

Close the query and result-set objects

executeQuery

public void executeQuery(java.lang.Object[] par)
                  throws java.sql.SQLException

Execute the Query with new bind parameters.

Parameters:

par - Bind parameters

Throws:

lava.sql.SQLException

java.sql.SQLException

executeQuery

public void executeQuery(java.lang.String sql)
                  throws java.sql.SQLException

Execute a SQL query.

Parameters:

sql - SQL statement to be executed

Throws:

lava.sql.SQLException

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sql)
                  throws java.sql.SQLException

Execute a non-query SQL statement

Parameters:

sql - SQL statement to be executed

Throws:

lava.sql.SQLException

java.sql.SQLException

getAddress

public Address getAddress(Device dev)
                   throws java.sql.SQLException

Create a oracle.lite.resource.Address object from the query result.

Returns:

oracle.lite.resource.Address object

Throws:

lava.sql.SQLException

java.sql.SQLException

getApplication

public Application getApplication()
                           throws java.sql.SQLException

Create a oracle.lite.resource.Application object from the query result.

Returns:

oracle.lite.resource.Application object

Throws:

lava.sql.SQLException

java.sql.SQLException

getBlob

public java.sql.Blob getBlob(int idx)
                      throws java.sql.SQLException

Retrieve the blob value from the query result.

Parameters:

idx - Column index

Returns:

Blob data

Throws:

java.sql.SQLException

getDevice

public Device getDevice(User usr)
                 throws java.sql.SQLException

Create a oracle.lite.resource.Device object from the query result.

Parameters:

usr - Owner of the device

Returns:

oracle.lite.resource.Device object

Throws:

lava.sql.SQLException

java.sql.SQLException

getDeviceCommand

public DeviceCommand getDeviceCommand(Device dev)
                               throws java.sql.SQLException

Create a oracle.lite.resource.dm.DeviceCommand object from the query result.

Returns:

oracle.lite.resource.dm.DeviceCommand object

Throws:

lava.sql.SQLException

java.sql.SQLException

getGroup

public Group getGroup()
               throws java.sql.SQLException

Create a oracle.lite.resource.Group object from the query result.

Returns:

oracle.lite.resource.Group object

Throws:

lava.sql.SQLException

java.sql.SQLException

getInputStream

public java.io.InputStream getInputStream(int idx)
                                   throws java.sql.SQLException

Retrieve the java.io.InputStream value from the query result.

Parameters:

idx - Column index

Throws:

lava.sql.SQLException

java.sql.SQLException

getInt

public int getInt(int idx)
           throws java.sql.SQLException

Retrieve the 'int' value from the query result.

Parameters:

idx - Column index

Throws:

lava.sql.SQLException

java.sql.SQLException

getLanguage

public Language getLanguage()
                     throws java.sql.SQLException

Create a oracle.lite.resource.Language object from the query result.

Returns:

oracle.lite.resource.Language object

Throws:

lava.sql.SQLException

java.sql.SQLException

getLog

public Log getLog()
           throws java.sql.SQLException

Create a oracle.lite.resource.Log object from the query result.

Returns:

oracle.lite.resource.QueueData object

Throws:

lava.sql.SQLException

java.sql.SQLException

getLong

public long getLong(int idx)
             throws java.sql.SQLException

Retrieve the 'long' value from the query result.

Parameters:

idx - Column index

Throws:

lava.sql.SQLException

java.sql.SQLException

getPlatform

public Platform getPlatform()
                     throws java.sql.SQLException

Create a oracle.lite.resource.Platform object from the query result.

Returns:

oracle.lite.resource.Platform object

Throws:

lava.sql.SQLException

java.sql.SQLException

getProvider

public Provider getProvider()
                     throws java.sql.SQLException

Create a oracle.lite.resource.Provider object from the query result.

Returns:

oracle.lite.resource.Provider object

Throws:

lava.sql.SQLException

java.sql.SQLException

getQueueData

public QueueData getQueueData(Device dev)
                       throws java.sql.SQLException

Create a oracle.lite.resource.dm.QueueData object from the query result.

Returns:

oracle.lite.resource.dm.QueueData object

Throws:

lava.sql.SQLException

java.sql.SQLException

getRole

public Role getRole()
             throws java.sql.SQLException

Create a oracle.lite.resource.Role object from the query result.

Returns:

oracle.lite.resource.Role object

Throws:

lava.sql.SQLException

java.sql.SQLException

getString

public java.lang.String getString(int idx)
                           throws java.sql.SQLException

Retrieve the string value from the query result.

Parameters:

idx - Column index

Throws:

lava.sql.SQLException

java.sql.SQLException

getTimestamp

public java.sql.Timestamp getTimestamp(int idx)
                                throws java.sql.SQLException

Retrieve the java.sql.Timestamp value from the query result.

Parameters:

idx - Column index

Throws:

lava.sql.SQLException

java.sql.SQLException

getUser

public User getUser()
             throws java.sql.SQLException

Create a oracle.lite.resource.User object from the query result.

Returns:

oracle.lite.resource.User object

Throws:

lava.sql.SQLException

java.sql.SQLException

next

public boolean next()
             throws java.sql.SQLException

Move to the next cursor

Throws:

lava.sql.SQLException

java.sql.SQLException