Limit and sort
Sometimes, you only need a few records to page through a resultset. This style of data usage is usually found in web applications. An example could be paging through a catalog of products.
The "finder" methods, such as
where() return an instance of a
LazyList. This class has a method called
limit(int). It will limit a number of results in the resultset when your programs starts to:
Offsetting start of a page
Once you got a first page, you might want to get a next one. This is done with the offset method, found on the same
LazyList class like so:
The code snippet above will find and return 40 records, starting with the 21st record, inclusive.
Ordering results (putting all together Fluent Interfaces style )
Usually, you would limit, offset and order results in one statement:
Sometimes this style of programming is called Fluent Interfaces and is credited to Martin Fowler. This style of API is concise, readable and self explanatory.
Paginating for the web
orderBy themselves are quite simple and powerful methods, ActiveJDBC also provides a convenience class called
Paginator especially designed for web applications:
1 2 3
The instances of this class are lightweight and usually attached to a session. It can be queried for a current page displayed:
and for page count like this:
Using this class in a context of a web application makes it easy to build paging through resultsets.
How to comment
The comment section below is to discuss documentation on this page.
If you have an issue, or discover bug, please follow instructions on the Support page