JAVA: Arraylist that displays loggedin user data

I wrote a code that seemed ok when i had only one entry in the system but when i added more data for the code to handle everything upends. DataTables display errors and then list all entries in the mysql database.

Here is my code

CreditsDao.java

public static List<Credits> getAllCredits(int id) throws SQLException {

    List<Credits> creditlist=new ArrayList<>();

    try{
        Connection con= OrganizerDao.getConnection();
        PreparedStatement ps=con.prepareStatement("select users.id AS organizerid, credits.invoiceid, " +
                "credits.amountin AS creditamount, attendees.name AS payee, credits.purpose, gateway.name AS gatewayname " +
                "from credits LEFT JOIN users on credits.userid=users.id LEFT JOIN attendees on credits.attendeeid=attendees.id " +
                "LEFT JOIN gateway on credits.gateway=gateway.id");

        ResultSet rs=ps.executeQuery();
        while(rs.next()){

            Credits credits = new Credits();

            credits.setOrganizerid(rs.getInt("organizerid"));
            credits.setInvoiceid(rs.getInt("invoiceid"));
            credits.setCreditamount(rs.getDouble("creditamount"));
            credits.setPayee(rs.getString("payee"));
            credits.setPurpose(rs.getString("purpose"));
            credits.setGatewayname(rs.getString("gatewayname"));

            creditlist.add(credits);

        }
        con.close();
    }catch(Exception e){e.printStackTrace();}

    return creditlist;

}

CreditsServlet.java

    protected void doGet(HttpServletRequest request,
                     HttpServletResponse response) throws ServletException, IOException {

    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();

    HttpSession session = request.getSession();

    try {

        if(session.getAttribute("organizer")!=null) {
            listTrans(request, response);

        }else{
        out.println("<div class=\"alert alert-danger\" role=\"alert\">");
        out.println("<center>Oh snap! Change a few things and try submitting again.</center>");
        out.println("</div>");

        request.getRequestDispatcher("login.jsp").include(request, response);
    }
    } catch (SQLException e) {
        e.printStackTrace();
    }


}

private void listTrans(HttpServletRequest request, HttpServletResponse response)
        throws SQLException, IOException, ServletException {


    int id = Integer.parseInt(request.getParameter("id"));

    List<Credits> creditlist = OrganizerDao.getAllCredits(id);
    for (Credits credits : creditlist) {
        if (credits.getOrganizerid() == id) {

            request.setAttribute("creditlist", creditlist);

        }

        request.getRequestDispatcher("credits.jsp").include(request, response);

    }


}

Credits.jsp

<table>
     <thead>
      <tr>
      <th>Invoice</th>
      <th>Amount</th>
      <th>Payee</th>
      <th>Purpose</th>
      <th>Payment Gateway</th>
     </tr>
     </thead>
     <tbody>
     <c:forEach var="credits" items="${creditlist}">

      <tr>
       <td><c:out value="${credits.invoiceid}"/></td>
       <td><c:out value="${credits.creditamount}"/></td>
       <td><c:out value="${credits.payee}"/></td>
       <td><c:out value="${credits.purpose}"/></td>
       <td><c:out value="${credits.gatewayname}"/></td>

        </tr>

        </c:forEach>
        </tbody>
     </table>

This affects all code wriiten this way. Any help or direction would be greatly appreciated.

screenshot of error. When i click ok it displays all information in the table.