http://localhost:8080/MyProject/get_employee_list?emp_id=4&name=Henry

public List<GetEmployeeLists> getEmployeeList(Integer emp_id,String empName) throws DaoException {

List<GetEmployeeLists> empAttrList = new ArrayList<GetEmployeeLists>();
        try {
            ds = jdbcTemplate.getDataSource();
            conn = ds.getConnection();
            pstmt = conn.prepareStatement(selectSQL);
            logger.debug("sql query :" + selectSQL);
            System.out.println(selectSQL);
            pstmt.setInt(1, emp_id);
            pstmt.setString(2, "%"+empName+"%");
            logger.debug("sql parameters, emp_id:" +  emp_id + "Employee Name: "+empName);
            rs = pstmt.executeQuery();
            while(rs.next()) {

                GetEmployeeLists    addList  = new GetEmployeeLists();
                addList.setEmpId(emp_id);
                addList.setEmpId(rs.getInt("emp_id"));
                addList.setCompanyID(rs.getInt("company_id"));
                addList.setName(rs.getString("name"));
                empAttrList.add(addList);

            }
        } catch(Throwable th) {
            throw new DaoException(th.getMessage(), th);
        }


private String selectSQL = "SELECT EMP_ID,NAME,COMPANY_ID FROM cvterm WHERE emp_id = ? AND  NAME LIKE ?";

private String selectSQL = "SELECT EMP_ID,LOWER(NAME),COMPANY_ID FROM cvterm WHERE emp_id = ? AND  NAME LIKE ?";