/* * To change this template, choose Tools | Templates * and open the template in the editor. */package servlet;import db.DBConnetion;import java.io.*;import java.net.*;import javax.servlet.*;import javax.servlet.http.*;/** * * @author Administrator */public class DeleteServlet extends HttpServlet {       /**     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.    * @param request servlet request    * @param response servlet response    */    protected void processRequest(HttpServletRequest request, HttpServletResponse response)    throws ServletException, IOException {        response.setContentType("text/html;charset=UTF-8");        PrintWriter out = response.getWriter();        try {                    String name = request.getParameter("name");            String sql = "delete UserInfo where name ='"+name+"'";            db.DBConnetion conn = new DBConnetion();            conn.updateQeary(sql);            out.println("刪除成功"+"<br>");            out.println("<a href='resultShow.jsp'>返回</a>");        } finally {             out.close();        }    }     // <editor-fold defaultstate="collapsed" desc="HttpServlet 方法。單擊左側的 + 號以編緝代碼。">    /**     * Handles the HTTP <code>GET</code> method.    * @param request servlet request    * @param response servlet response    */    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    */    protected void doPost(HttpServletRequest request, HttpServletResponse response)    throws ServletException, IOException {        processRequest(request, response);    }    /**     * Returns a short description of the servlet.    */    public String getServletInfo() {        return "Short description";    }    // </editor-fold>}