In this tutorial we’ll demonstrate some of the powerful Object Relational Mapping (ORM) features of SQLite Database Model by building a simple Java application that stores and manipulates some data about cars, their engines and their wheels in a SQLite 3 database all without writing a single line of SQL.
The tutorial is split into three parts. In part 1 we explore how we need to prepare our objects for SQLite Database Model to map them to database tables. In part 2 we discuss the how to set up your “DatabaseModel” which will provide the interface between your application and the SQLite database. Lastly, in part 3 we will explore the powerful methods that SQLite Database Model provides to store objects in SQLite database tables, query those tables and manipulate your data.
It is highly recommended that you get a copy of the demo project from the downloads section to work with as you go through this tutorial.
- Defining your Object Models
- Creating the Database Model
- Registering Your Objects With SQLite Database Model
- Creating Generic & Custom Object Models
- Upgrading Your Database to a New Version
- Seeding Your Database With Default Records
- Using SQLite Database Model to Store, Query and Manipulate Your Data