UltraLite Static Java User's Guide
Data Access Using Pure Java
This section describes how to add SQL statements to your UltraLite application.
For information on SQL features that can and cannot be used in UltraLite application, see Overview of SQL support in UltraLite.
The SQL statements to be used in your application must be added to the reference database. The UltraLite generator writes out an interface that defines these SQL statements as public static final strings. You invoke the statements in your application by implementing the interface and referencing the SQL statement by its identifier, or by referencing it directly from the interface.
The SQL statements to be included in the UltraLite application, and the structure of the UltraLite database itself, are defined by adding the SQL statements to the reference database for your application.
For information on reference databases, see Preparing a reference database.
Each SQL statement stored in the reference database is associated with a project. A project is a name, defined in the reference database, which groups the SQL statements for one application. You can store SQL statements for multiple applications in a single reference database by defining multiple projects.
For information on creating projects, see Creating an UltraLite project.
The data access statements you are going to use in your UltraLite application must be added to your project.
For information on adding SQL statements to your database, see Adding SQL statements to an UltraLite project.