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:
TomDavis45Business analysis
MilesDavis12Finances
IvanTrump1Human Resources
MiaMiles3Human Resources
JamesKiley23Human Resources
<<   >>