QueryResultSet

Example

The following example shows how to execute a query on multiple MBOs using a join:

com.sybase.persistence.Query query = new  com.sybase.persistence.Query();

query.select("c.fname,c.lname,s.order_date,s.region");
query.from(" Customer ", "c");
query.join(" SalesOrder ", "s", " s.cust_id ", "c.id");
AttributeTest ts = new AttributeTest();
ts.setAttribute("lname");
ts.setTestValue(" Devlin");
ts.setOperator(AttributeTest.EQUALS)
query.setTestCriteria(ts);
QueryResultSet qrs = <MyPkg>DB.executeQuery(query);
while(qrs.next())
{
     System.out.println(qrs.getString(columnIndex));
     System.out.println(qrs.getStringByName(columnName));
}