i have problem with passing array object from servlet to jsp. When i try to pass it to jsp i get NullPointerException but if i print that object in servlet i have all data.
Servlet :
ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM APP.CUSTOMER");
CustomerBean customer = null;
List<CustomerBean> list = new ArrayList<CustomerBean>();
while (rs.next()) {
customer = new CustomerBean();
customer.setCustomer_id(rs.getInt("CUSTOMER_ID"));
customer.setName(rs.getString("NAME"));
customer.setPhone(rs.getString("PHONE"));
customer.setEmail(rs.getString("EMAIL"));
customer.setCity(rs.getString("CITY"));
list.add(customer);
}
request.getSession().setAttribute("list", list);
RequestDispatcher disp;
disp = getServletContext( ).getRequestDispatcher("index.jsp");
disp.forward(request, response);
JSP :
<%
// retrieve your list from the request, with casting
ArrayList<CustomerBean> list = (ArrayList<CustomerBean>) request.getAttribute("list");
// print the information about every category of the list
for(CustomerBean list1 : list) {
out.println(list1.getCustomer_id());
out.println(list1.getName());
out.println(list1.getPhone());
out.println(list1.getEmail());
out.println(list1.getCity());
}
%>
UPDATE
Now when i have a list of data, how to display only 1 row clicking on href in new jsp. I have something like that but when i click id isnt passing :
for(CustomerBean list1 : list) {
out.println("<td>"+list1.getCustomer_id()+"</td>");
out.println("<td>"+list1.getName()+"</td>");
out.println("<td>"+list1.getPhone()+"</td>");
out.println("<td>"+list1.getEmail()+"</td>");
out.println("<td>"+list1.getCity()+"</td>");
out.println("<td><a href='details.jsp?customer_id='+list1.getCustomer_id()>details</a></td>");
out.println("</tr>");
}