[FIXED] Sending/Receiving GET Request with Parameters

Issue

I have a situation in which I want to select all records from a database given a specific id. The request is first sent from JavaScript, which is received by a Servlet which accesses a DAO that in turn queries a database. The data will then, obviously, make its way back to the front-end. I'm just a little cloudy on passing these parameters along so that the database is queried correctly.

I am currently getting a 500 error which is due to my parameters not being passed along correctly.

Starting at the JavaScript with the initial request:

let xhr = new XMLHttpRequest();
xhr.open('GET', 'http://localhost:8080/project1attempt/reimbursement? 
employee_id=' + x._id, true);
xhr.send();

Receiving the parameters at the Servlet is my biggest point of confusion, therefore the code here is incomplete (rs is a Reimbursement Service):

protected void doGet(HttpServletRequest req, HttpServletResponse resp) 
throws ServletException, IOException {

    resp.setContentType("application/json");
    int id = ;
    List<Reimbursement> reimbursements = rs.findAllReimbursements(id);
    String json = new ObjectMapper().writeValueAsString(reimbursements);
    resp.getWriter().write(json);
}

And the query:

public List<Reimbursement> findAllReimbursements(int id) {
    List<Reimbursement> reimbursements = new ArrayList<>();

    try
        (Connection c = manager.getConnection()) {

        String sql = "SELECT reimbursement_id, date, description, amount, 
typing_id, employee_id" +
                "FROM reimbursements" +
                "WHERE reimbursement_id = ?";

        PreparedStatement ps = c.prepareStatement(sql);
        ps.setInt(1, id);
        ResultSet rs = ps.executeQuery();

        Reimbursement r = null;
        while (rs.next()) {
            r = new Reimbursement();
            r.setId(rs.getInt("reimbursement_id"));
            r.setDate(rs.getDate("date"));
            r.setDescription(rs.getString("description"));
            r.setAmount(rs.getDouble("amount"));
            r.setTypingId(rs.getInt("typing_id"));
            r.setEmployeeId(rs.getInt("employee_id"));
            reimbursements.add(r);
        }
        return reimbursements;
    } catch (SQLException e) {
        throw new BlabApplicationDataException("Could not connect to 
Reimbursement Repository" + id);
    }
 }

Solution

You can use getParameter method of HttpServletRequest to get the URL parameter you need.

Probably, this is the line you are looking for.

String idStr = req.getParameter('employee_id');
if(idStr != null) { 
   int id = Integer.parseInt(idStr);
} 

Answered By - Johna