detelemember.java

来自「用J2EE开发的网站,可以应用到图书馆,图书超市」· Java 代码 · 共 46 行

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
public class deteleMember extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GB2312";

    //Initialize global variables
    public void init() throws ServletException {
    }

    //Process the HTTP Get request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws
            ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        PrintWriter out = response.getWriter();
        HttpSession session=request.getSession();

        MemberSql ms=new MemberSql();
        String author=request.getParameter("name");
        String s="delete from Shop_Member_Info where Account= '" + author+ "'";

        int i;
        i=ms.Delete_Query(s);
        if(i>0)
        {
            session.setAttribute("info","删除成功,无此会员");

        }
        else
        {
            session.setAttribute("info","删除失败");
        }
        RequestDispatcher rd=request.getRequestDispatcher("ok.jsp");
        rd.forward(request,response);
        out.close();
    }

    //Clean up resources
    public void destroy() {
    }
}