del_member.java

用J2EE开发的网站,可以应用到图书馆,图书超市

package ksnb;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;

public class del_member extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";

    //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);
        HttpSession session=request.getSession();
        MemberSql ms=new MemberSql();
        String id=request.getParameter("Id");
        System.out.println("adf"+request.getParameter("Id"));
        int Id=Integer.parseInt(id);
        String s="delete from Shop_Member_Info where Id= '" + Id+ "'";
        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);

    }

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