Slim SQL Client

SQL SQL Client is a java library, writen in Java 8 and under APACHE licence.

Introduction

The main goal is to provide automatic DAO abilities over POJO entities by simply extending the GenericDao superclass.

Features

• Out of the box SQL CRUD(create, read, update, delete and many more queries) by easily extending class GenericDao.

Example:

public class OrdersDao extends GenericDao<Order> {
	public static final String TABLE_NAME = "orders";
	public OrdersDao() throws Exception {
		super(Order.class);
	}
	@Override
	public String getTableName() {
		return TABLE_NAME;
	}
}

• Pagination - selecting pages of records using one line of code.
  • by page index.
  • from record id.
  • by record id for which you would like to paginate only new records.

Example:

paginationParams.setPageIndex(int pageIndex); // quering by page index
- or -
paginationParams.setHeighestThen(int entityId);  // quering for entities newer than entityId. Can be used to show "x new items" bar.
- or -
paginationParams.setEntityHightId(int entityId); // quering a page down from entity with id entityId. Can be used to load older pages when user scrolls down.
// "id" is the column on which this example paginates.
OrderssSQLPager.getResults(paginationParams, OrdersDao, OrdersDao.getTableName(), "id")

Page size is easily configurable.

• Very easy for maintenance and extensions.

Running it

Current MySql Connector is implemented using JDBC. You'll need to update the environment fields in class EnvConstants with your sql server name, password and username.

This library is a demo for Customers and Orders Model. In order to run it make sure that a corresponding Model exists(The fields' names can be taken from Order and Customer classes).

Final note:

The library uses Annotations and Reflections and so do not recommended for Android applications usage since these patterns perform slow on Android.

TODO:

1. Enable creating db scheme from entities.
2. Related to (1), set fk and pk and index in annotation.
3. Observables queries.