Examples of running SQL statements
The following examples demonstrate several uses of pureQuery to run SQL statements.
Running a simple query to produce an Iterator of objects
This example shows how you might use pureQuery to find all customers in a particular sales region.
Running a complex query to produce a list of objects
This example shows you how you might use pureQuery to find the project that has the most staff members in a company.
Inserting a record into a table
This example shows how you might use pureQuery to insert a record for a new employee into a table of employee records.
Related concepts
:
Using inline methods to run SQL statements
Using data access objects to run SQL statements
Overview of inline methods
Overview of data access object (DAO) interfaces and annotated methods
Related reference
:
Support for SQL statements that run with databases
Feedback