毕业设计：基于Jsp的电信运营采集系统

package servlet; import java.io.IOException; import java.util.ArrayList; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import bean.AllBean; import bean.InsertUpdateDelBean; public class DelServlet extends HttpServlet { /** * Constructor of the object. */ public DelServlet() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=gb2312"); request.setCharacterEncoding("gb2312"); String sql = ""; String str = ""; InsertUpdateDelBean ib = new InsertUpdateDelBean(); AllBean ab = new AllBean(); String adminid = request.getParameter("adminid"); String business = request.getParameter("business"); String users = request.getParameter("users"); String handle = request.getParameter("handle"); String proposal = request.getParameter("proposal"); String charge = request.getParameter("charge"); if(adminid != null && !adminid.equals("")){ str = "/admin/adminlist.jsp"; sql = "delete from admin where id="+adminid; if(adminid.equals("1")){ request.setAttribute("message", "初始系统管理员不能删除！"); }else{ ib.insertANDupdateANDdel(sql); request.setAttribute("message", "操作成功！"); } } if(business != null && !business.equals("")){ str = "/admin/business_list.jsp"; sql = "delete from business where id="+business; ib.insertANDupdateANDdel(sql); sql = "delete from handle where businessid="+business; ib.insertANDupdateANDdel(sql); request.setAttribute("message", "操作成功！"); } if(users != null && !users.equals("")){ str = "/admin/userlist.jsp"; sql = "delete from users where id="+users; ib.insertANDupdateANDdel(sql); sql = "delete from charge where usersid="+users; ib.insertANDupdateANDdel(sql); sql = "delete from handle where usersid="+users; ib.insertANDupdateANDdel(sql); sql = "delete from proposal where usersid="+users; ib.insertANDupdateANDdel(sql); request.setAttribute("message", "操作成功！"); } if(handle != null && !handle.equals("")){ str = "/admin/handle_list.jsp"; sql = "delete from handle where id="+handle; ib.insertANDupdateANDdel(sql); request.setAttribute("message", "操作成功！"); } if(proposal != null && !proposal.equals("")){ str = "/admin/proposal_list.jsp"; sql = "delete from proposal where id="+proposal; ib.insertANDupdateANDdel(sql); request.setAttribute("message", "操作成功！"); } if(charge != null && !charge.equals("")){ str = "/admin/charge.jsp"; sql = "delete from charge where id="+charge; ib.insertANDupdateANDdel(sql); request.setAttribute("message", "操作成功！"); } RequestDispatcher rd = request.getRequestDispatcher(str); rd.forward(request,response); } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } }