A Simple Example Project demonstrating how JDXA ORM for Android can use an autoincrement column of a SQLite database table to automatically generate primary key values for new objects
This project shows a simple Android app using JDXA ORM to exchange object data with an on-device SQLite relational database. In particular, it shows the use of an autoincrement column for automatically generating primary key values for new objects.
- The object model consists of one POJO class (Employee).
- The declarative mapping specification (in the file .../res/raw/autoincrement_example.jdx) is simple, intuitive, non-intrusive, and succinct.
- The SQLTYPE specification of 'INTEGER PRIMARY KEY AUTOINCREMENT' for an attribute is used to define an autoincrement column.
- The RDBMS_GENERATED statement identifies the attribute whose value is automatically generated by the database.
- API calls for CRUD operations are simple.
- JDX can automatically assign the autoincrement value to the designated attribute of a domain model object when it is persisted.
- JDXA provides handy utility methods for displaying an object or a list of objects.
http://www.softwaretree.com/blog/2016/03/13/generating-unique-ids-for-primary-key-values-using-jdxa-orm/Please also check the related blog at
To run this app in your own setup, please do the following:
- Clone this project on your desktop.
- Get the JDXA SDK download instructions from this link.
- You may download just the mini version of the SDK.
- Add the libraries (JDXAndroid-nn.n.jar and sqldroid.jar) from the SDK to the app/libs directory and build the project.
- Run the app.
About JDXA ORM
JDXA is a simple yet powerful, non-intrusive, flexible, and lightweight Object-Relational Mapping (ORM) product that simplifies and accelerates the development of Android apps by providing intuitive, object-oriented access to on-device relational (e.g., SQLite) data.
Adhering to some well thought-out KISS (Keep It Simple and Straightforward) principles, JDXA boosts developer productivity and reduces maintenance hassles by eliminating endless lines of tedious SQL code.
Some of the powerful and practical features of JDXA include:
Declarative mapping specification between an object model and a relational model is done textually using a simple grammar (no XML complexity).
Full flexibility in domain object modeling – one-to-one, one-to-many, and many-to-many relationships as well as class-hierarchies supported.
POJO (Plain Old Java Objects) friendly non-intrusive programming model, which does not require you to change your Java classes in any way:
- No need to subclass your domain model classes from any base class
- No need to clutter your source code with annotations
- No source code generation (No need for DAO classes)
- No pre-processing or post-processing of your code
Support for persistence of JSON objects.
A small set of intuitive APIs for object persistence.
Automatic generation of relational schema from an object model.
A highly optimized metadata-driven ORM engine that is lightweight, dynamic, and flexible.
JDXA ORM is a product of Software Tree. To get more information and a free trial version of JDXA SDK, please visit http://www.softwaretree.com.
JDXA is used with the SQLDroid open source library. SQLDroid is provided under the licensing terms mentioned here.