I am using JDBC to connect to a database and using a select query. I am fetching the data into an Arraylist and showing the data into a JSP page in table format.
All things going good but I am unable to retrieve the data from the Arraylist to show it on my JSP page.
(In the code i have removed the import's)
Any help will be appreciated.
public class Search extends HttpServlet {
    ArrayList<Object> list = new ArrayList<Object>();
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        try{
            Integer n =Integer.parseInt(request.getParameter("empno"));
            Class.forName("com.mysql.jdbc.Driver");
            Connection con =(Connection)DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root", "root");
            PreparedStatement ps = con.prepareStatement("select * from astintech where EmpNo = ?");
            ps.setInt(1, n);
            ResultSet rs = ps.executeQuery();
             if(rs.next())
             {
                {
                    String empno = rs.getString(1);
                    String ename = rs.getString(2);
                    String job = rs.getString(3);
                    String loc = rs.getString(4);
                    list.add(empno);
                    list.add(ename);
                    list.add(job);
                    list.add(loc);
                    System.out.println("list::" +list); 
                }
                request.setAttribute("nList", list);
                System.out.println("valid User no.");
                RequestDispatcher rd = request.getRequestDispatcher("Welcome.jsp");
                rd.include(request, response);
            }
            else
            {   
                System.out.println("invalid User no.");
                RequestDispatcher rd = request.getRequestDispatcher("Error.jsp");
                rd.include(request, response);
            }
        }catch(NumberFormatException nfe)
        {
            System.out.println("ONLY INTEGER VALUE ALLOWED");
            System.out.println("PLEASE ENTER ONLY INTEGER");
            RequestDispatcher rd = request.getRequestDispatcher("NumberFormatException.jsp");
            rd.include(request, response);
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        finally
        {
            out.close();
        }
    }
}
 
    