Overview of inline methods
When you use the inline programming
style, you can code
your SQL queries, update statements, or CALL statements inline in
your applications. An SQL statement appears as a parameter in the
invocation of a method.
Overview of data access object (DAO) interfaces and annotated methods
When you create annotated methods, you can code your SQL
queries, update statements, or CALL statements in annotations on methods
that you define in your own interfaces. You can define data access
object (DAO) interfaces with your annotated methods.
Using beans in pureQuery
Although pureQuery methods can
deal with input parameters
and return values defined as unstructured types (primitive wrapper
objects such as Integer and Float objects, Map objects),
you can map relational data to Java™ objects
best by using beans.
Running SQL statements with databases
You can use inline or annotated methods to run SQL queries,
Data Definition Language (DDL) statements, and Data Manipulation Language
(DML) statements with databases. You can also run SQL CALL statements
against databases where the corresponding stored procedures are deployed.
Using SQL to query in-memory Java collections in pureQuery
You can use annotated or inline methods
to query in-memory Java collections,
such as arrays,
classes that implement java.lang.Iterable, and classes that implement
java.util.Iterator.
Mapping ambiguous columns in query results
If
you do not use AS clauses in SQL queries that produce
joins or unions, or that contain calculated columns, query results
might contain columns with non-unique names or without names. pureQuery
cannot map such columns to properties in the beans that you want to
contain the query results. You can map the columns manually with a
specific set() method.
Using XML configuration files with the pureQuery Generator utility
When you generate an implementation class
for an interface
that defines annotated methods, you can use an XML file to specify
or override the SQL statements that those methods use. You can also
use the same XML file to override how the columns in a database object,
such as a table or view, map to the properties of a bean.
pureQuery Javadoc
The Javadoc contains information about the classes and
interfaces in pureQuery.