FONForum

// Build a SQL statement to Person objects that are over a certain age and order
// the results by last name
String sql = "SELECT * FROM com.javasrc.josql.Person WHERE age >= :age ORDER BY lastName";

// Build a Query object and ask it to parse the SQL
Query query = new Query();
query.parse( sql );

// Set our bind variables: the person's age
query.setVariable( "age", new Integer( 18 ) );

// Execute the query and extract the results
QueryResults res = query.execute( this.people );
List sortedPeopleThatCanVote = req.getResults();