最简单的servlet增删改查示例小项目

package servlets; import java.io.IOException; import java.io.PrintWriter; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import services.UserService; import vo.Page; import vo.User; public class AddUserServlet extends HttpServlet { /** * Constructor of the object. */ public AddUserServlet() { 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 { this.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 { String method = request.getParameter("method"); System.out.println(method+"----------------------"); if(method.equals("login")){ String code = request.getParameter("code"); String pwd = request.getParameter("pwd"); UserService us = new UserService(); User u = us.login(code, pwd); if(u!=null){ request.getSession().setAttribute("userinfo", u); request.getSession().setAttribute("users", us.getLastUser()); request.getRequestDispatcher("/index.jsp").forward(request,response); }else{ request.getSession().setAttribute("result", "loginfail"); request.getRequestDispatcher("/loginfail.jsp").forward(request,response); } }else if(method.equals("adduser")){ String pwd = request.getParameter("pwd"); String code = request.getParameter("code"); String name = request.getParameter("name"); String phone = request.getParameter("phone"); User u = new User(); u.setCode(code); u.setName(name); u.setPhone(phone); u.setPwd(pwd); UserService us = new UserService(); User getUser = us.checkUsercode(u); if(getUser!=null && getUser.getCode()!=null){ request.setAttribute("userexitstr", "用户已存在，编号为："+getUser.getCode()+"名称："+getUser.getName()+"手机号："+getUser.getPhone()); request.getRequestDispatcher("/fail.jsp").forward(request,response); }else{ boolean flag = us.addUser(u); if(flag){ request.setAttribute("result", "添加用户成功<a href='useradd.jsp'>继续添加</a>"); request.getRequestDispatcher("/success.jsp").forward(request,response); }else{ request.setAttribute("result", "添加用户失败<a href='useradd.jsp'>重新添加</a>"); request.getRequestDispatcher("/fail.jsp").forward(request,response); } } }else if(method.equals("querylist")){ String code = request.getParameter("code")==null?"":request.getParameter("code").toString(); String name = request.getParameter("name")==null?"":request.getParameter("name").toString(); String phone = request.getParameter("phone")==null?"":request.getParameter("phone").toString(); String pageNum = request.getParameter("pageNum"); User u = new User(); u.setCode(code); u.setName(name); u.setPhone(phone); UserService us = new UserService(); Page page = new Page(); if(pageNum==null || pageNum.equals("")){ pageNum = "0"; } page.setPageNum(pageNum); page.setPageCount("5"); request.setAttribute("userlist", us.getUsers(u, page)); request.setAttribute("count", us.getUsersCount(u)); request.setAttribute("code", code); request.setAttribute("name", name); request.setAttribute("phone", phone); request.setAttribute("page", page); request.getRequestDispatcher("/userlist.jsp").forward(request,response); }else if(method.equals("quit")){ request.getSession().removeAttribute("userinfo"); request.getRequestDispatcher("/loginfail.jsp").forward(request,response); }else if(method.equals("updateuser")){ String pwd = request.getParameter("pwd"); String code = request.getParameter("code"); String name = request.getParameter("name"); String phone = request.getParameter("phone"); String id = request.getParameter("id"); User u = new User(); u.setCode(code); u.setName(name); u.setPhone(phone); u.setPwd(pwd); u.setId(id); UserService us = new UserService(); User getUser = us.checkUsercode(u); // if(getUser!=null && getUser.getCode()!=null){ // request.setAttribute("userexitstr", "用户已存在，编号为："+getUser.getCode()+"名称："+getUser.getName()+"手机号："+getUser.getPhone()); // request.getRequestDispatcher("/updateuser.jsp").forward(request,response); // }else{ boolean flag = us.updateUser(u); if(flag){ request.setAttribute("result", "修改用户成功<a href='<%=basePath%>servlet/AddUserServlet?method=querylist&pageNum=0'>返回列表页</a>"); request.getRequestDispatcher("/success.jsp").forward(request,response); }else{ request.setAttribute("result", "修改用户失败<a href='<%=basePath%>servlet/AddUserServlet?method=querylist&pageNum=0'>返回列表页</a>"); request.getRequestDispatcher("/fail.jsp").forward(request,response); } //} }else if(method.equals("deleteuser")){ String[] ids = request.getParameterValues("userids"); System.out.println(ids.length+"-------------------"); if(ids!=null && ids.length>0){ for(int i=0;i<ids.length;i++){ UserService us = new UserService(); us.deleteUser(ids[i]); } } request.setAttribute("result", "删除用户成功<a href='<%=basePath%>servlet/AddUserServlet?method=querylist&pageNum=0'>返回列表页</a>"); request.getRequestDispatcher("/success.jsp").forward(request,response); }else if(method.equals("resetpwd")){ String id = request.getParameter("userid"); UserService us = new UserService(); us.resetpwd(id); Page page = new Page(); //System.out.println(request.getParameter("pageNum")+"============="); page.setPageNum(request.getParameter("pageNum")); page.setPageCount("5"); String code = request.getParameter("code")==null?"":request.getParameter("code").toString(); String name = request.getParameter("name")==null?"":request.getParameter("name").toString(); String phone = request.getParameter("phone")==null?"":request.getParameter("phone").toString(); User u = new User(); u.setCode(code); u.setName(name); u.setPhone(phone); request.setAttribute("userlist", us.getUsers(u, page)); request.setAttribute("count", us.getUsersCount(u)); request.setAttribute("resetpwd", "success"); request.getRequestDispatcher("/userlist.jsp").forward(request,response); }else if(method.equals("queryuser")){ String id = request.getParameter("id"); UserService us = new UserService(); request.setAttribute("user", us.getUserById(id)); request.getRequestDispatcher("/updateuser.jsp").forward(request,response); }else if(method.equals("queryusersee")){ String id = request.getParameter("id"); UserService us = new UserService(); request.setAttribute("user", us.getUserById(id)); request.getRequestDispatcher("/usersee.jsp").forward(request,response); } } /** * Initialization of the servle