Sormula is a ORM OpenSource framework, very similar to the JPA/Hibernate.
The code of the project in this page can be found in here: https://github.com/uaihebert/SormulaCrud
Sormula has a class named Database that works like the JPA EntityManagerFactory, the Database class will be like a bridge between the database and your model classes. To execute the SQL actions we will use the Table class that works like the JPA EntityManager, but the Table class is typed.
To run Sormula in a code you will need to create a Database instance:
To create a Database instance all that we need is a Java Connection.
To read data from the database is very easy, like below:
You only need to create a Database instance and a Table instance to execute all kind of SQL actions.
How can we map a class attribute name different from the database table column name? Take a look below:
We can use annotations to do the database mapping in our classes, very close to the JPA style.
To update, delete or create data in the database you can do like below:
About Sormula we can say that:
Has a good documentation
Easy to set up
It is not found in the maven repository, it will make harder to attach the source code if needed
Has a lot of checked exceptions, you will need to do a try/catch for the invoked actions