Object Queries

To retrieve data from a local database, use one of the static Object Query methods in the MBO class.

Object Query methods are generated based on the object queries defined by the modeler in Unwired WorkSpace. Object Query methods carry query names, parameters, and return types defined in Unwired WorkSpace. Object Query methods return either an object, or a collection of objects that match the specified search criteria.

The following examples demonstrate how to use the Object Query methods of the Customer MBO to retrieve data.

This method retrieves all customers:

public static com.sybase.collections.ObjectList findAll()

com.sybase.collections.ObjectList customers = Customer.findAll();

This method retrieves all customers in a certain page:

public static com.sybase.collections.ObjectList findAll(int skip, int take)

com.sybase.collections.ObjectList customers = Customer.findAll(10, 5);

Suppose the modeler defined the following Object Query for the Customer MBO in Sybase Unwired Workspace:

name – findByFirstName
parameter – String firstName
query definition – SELECT x.* FROM Customer x WHERE x.fname = :firstName
return type – Sybase.Collections.GenericList

The preceding Object Query results in this generated method:

public static com.sybase.collections.ObjectList findByFirstName(String firstName)

com.sybase.collections.ObjectList customers = Customer.findByFirstName("fname")