The code (including the sql query)

ConnectionPool connPool = ConnectionPool.getInstance(jdbcDriver, jdbcURL, user, password);
DBSelect dbSelect = new DBSelect();
//This method, by default, returns 10 records if the third parameter is left 0 (here recCount is set to 5)
// the id parameter indicates the column to use for sorting (necessary for paging)

List<EmployeeDB> employeeList = dbSelect.getRecordsForSingleTable(EmployeeDB.class, 1, 5,"id");


The result:


Name: Last name: Years employed: Department:
BorisKaminsky9Finances
JanePoll15Business analysis
AliceWood5Business analysis
JeffreyMann5Business analysis
MarkBuckly9Finances
<<   >>