The code (including the sql query):

String dept = request.getParameter("deptVal");
DBSelect dbSelect = new DBSelect();
HashMap<String,Object>hMap=new HashMap<String,Object>();
hMap.put("dept", dept);
String query="select * from employee where department = :dept";
List<EmployeeDB> employeeList = dbSelect.getRecordsForParamQuery(query,hMap,EmployeeDB.class, recStart, recCount,"id");

The result:


Name: Last name: Years employed: Department:
MarkPeters2Finances
MarkBuckly9Finances
BorisKaminsky9Finances
MilesDavis12Finances
<< >>