Untitled

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            /* TODO output your page here. You may use following sample code. */

            String message = request.getParameter("msg");

            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>Products Table</title>");

            if(message != null){
                out.println("<script>alert('" + message + "');</script>");
            }

            out.println("</head>");
            out.println("<body>");

            out.println("<h1>Add Product </h1>");
            out.println("<form name='productForm' method='post' action='insert_proc'>");
            out.println("Category:  <input type='text' name='category'/> <br>");
            out.println("Description: <input type='text' name='desc' /> <br>");
            out.println("Image: <input type='text' name='image' /> <br>");
            out.println("Price: <input type='text' name='price' /> <br>");
            out.println("<input type='submit' value='Submit' /> <br>");
            Connection conn = db.GetConnection();
            if(conn != null){
                //out.println("Connected");

                ResultSet rs = db.GetRecords(conn);
                FillTable(rs, out);
                db.Disconnect(conn);
            }
            else{
                out.println("Error connecting");
            }

            out.println("</form>");
            out.println("</body>");
            out.println("</html>");
        }
    }//end of process request

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>

    protected void FillTable(ResultSet rs, PrintWriter out){
        //out.println("test");
         try {
            rs.first();
            out.println("<table border='1'>");
            out.println("<tr>");
            out.println("<th>Category</th><th>Description</th><th>Image</th><th>Price</th>");
            out.println("</tr>");
            do{
                out.println("<tr>");
                out.println("<td>"  + rs.getString("Category") + "</td>");
                out.println("<td>" + rs.getString("Description") + "</td>");
                out.println("<td>" + rs.getString("Image") + "</td>");
                out.println("<td>" + rs.getDouble("Price") + "</td>");

            }while(rs.next());

            out.println("</table>");
        } catch (SQLException ex) {
            Logger.getLogger(ProductServlet.class.getName()).log(Level.SEVERE, null, ex);
        }


    }//end of fill table