OrmLite provides some handy functionality for “persisting Java objects to a database.” It also avoids the complexity and overhead of more standard ORM packages.

The main function

  • Set up your own class by adding annotations.
  • Powerful abstract database access Object (DAO) classes.
  • Easily build a variety of queries with flexible QueryBuilder.
  • Supports MySQL, Postgres, Microsoft SQL Server, H2, Derby, HSQLDB, Sqllite and can be extended to other databases relatively easily.
  • Provisional Support for DB2, Oracle, ODBC, and Netezza. If your database is not supported, contact the author.
  • SQL statements that process the “compile” repeated query task.
  • “Foreign” objects are supported through object type attributes, and only the ids of foreign objects are stored in the database.
  • Basic support for database transactions.
  • Automatically generates SQL for creating and dropping database tables.
  • Support for Spring configuration.
  • Configuration tables and fields without annotations are supported.
  • Supports native calls to the Android SQLite database API.

Development of the document

Official website: ormlite.com/ open source address: github.com/j256