Untitled

import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class dbStudent extends HttpServlet {


    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException, ClassNotFoundException, SQLException {
        response.setContentType("text/html;charset=UTF-8");
        try (PrintWriter out = response.getWriter()) {
            String title="Student Data";
            /* TODO output your page here. You may use following sample code. */
            out.println("<!DOCTYPE html>");
            out.println("<html>");
            out.println("<head>");
            out.println("<title>DB STUDENT</title>");
            out.println("</head>");
            out.println("<body>");
            out.println("<h1>STUDENT RECORD</h1>");

             String asd = request.getParameter("search");
             String dd = request.getParameter("Delete");

            try {
                 Connection con = null;
                Class.forName("com.mysql.jdbc.Driver");
                con = DriverManager.getConnection("jdbc:mysql://localhost:3306/awd","root", "");

                Statement stUser = con.createStatement();
                ResultSet rsUser = stUser.executeQuery("SELECT * FROM clerk WHERE name like '"+asd+"'");

                Statement user = con.createStatement();
               // ResultSet rsUsers = stUser.executeQuery("DELETE FROM clerk WHERE nama ='" + dd + "'");;

                int i=user.executeUpdate("DELETE FROM clerk WHERE name="+dd);
                out.println("Data Deleted Successfully!");

               if(rsUser.next()) {
                   do{
                     String name = rsUser.getString("name");
                    String ic = rsUser.getString("ic");
                    String address = rsUser.getString("address");
                    String trainer = rsUser.getString("trainer");
                    String license = rsUser.getString("license");
                    String trainingfee = rsUser.getString("training_fee");
                    String traininghours = rsUser.getString("training_hours");
                    String totalpayment = rsUser.getString("total_payment");

                    out.println("<center>");
                    out.println("<h3>The information you have registered</h3>");
                    out.println("<table bgcolor='#FFE4B5' border='0' cellspacing='1' cellpadding='10'>");
                    out.println("<tr>");
                    out.println("<td>Name : </td><td>:</td><td>"+ name + "</td>");
                    out.println("</tr>");
                    out.println("<tr>");
                    out.println("<td>Number I/C :</td><td>:</td><td>" + ic + "</td>");
                    out.println("</tr>");
                    out.println("<tr>");
                    out.println("<td>Address :</td><td>:</td><td>" + address + "</td>");
                    out.println("</tr>");
                    out.println("<tr>");
                    out.println("<td>Trainer : </td><td>:</td><td>" + trainer+ "</td>");
                    out.println("</tr>");
                    out.println("<tr>");
                    out.println("<td>License : </td><td>:</td><td>" + license+ "</td>");
                    out.println("</tr>");
                    out.println("<tr>");
                    out.println("<td>Training Fee : </td><td>:</td><td>" + trainingfee+ "</td>");
                    out.println("</tr>");
                    out.println("<tr>");
                    out.println("<td>Training Hours : </td><td>:</td><td>" + traininghours+ "</td>");
                    out.println("</tr>");
                    out.println("<tr>");
                    out.println("<td>Total Payment : </td><td>:</td><td>" + totalpayment+ "</td>");
                    out.println("</tr>");

                    out.println("</center>");
                    out.println("</table>");
                    out.println("<br>");

                   }
                   while (rsUser.next())
               }
               else{
                   System.out.println("no data");
               }


            } catch (SQLException exc) {
                exc.printStackTrace();
            }

            out.println("</body>");
            out.println("</html>");
        }
    }

    // <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 {
        try {
            processRequest(request, response);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(dbStudent.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(dbStudent.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    /**
     * 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 {
        try {
            processRequest(request, response);
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(dbStudent.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(dbStudent.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

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

}