JSP serverlet 增删查改

package com.TsingHua.TestServlet.servlet; import java.io.IOException; import java.io.PrintWriter; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.omg.CORBA.Request; import com.TsingHua.TestServlet.bean.PagingModel; import com.TsingHua.TestServlet.bean.User; import com.TsingHua.TestServlet.service.IUserSerive; import com.TsingHua.TestServlet.service.impl.UserService; import com.TsingHua.TestServlet.tool.MyUtil; public class UserServlet extends HttpServlet { IUserSerive userService = null; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String methodName = request.getParameter("method"); if(methodName != null&& methodName != ""){ if(methodName.equals("login")){ login(request, response); }else if(methodName.equals("findAllUsers")){ findAllUsers(request, response); }else if(methodName.equals("detail")){ detail(request, response); }else if(methodName.equals("delete")){ delete(request, response); }else if(methodName.equals("addUI")){ request.getRequestDispatcher("/register.jsp").forward(request, response); }else if(methodName.equals("register")){ register(request, response); }else if(methodName.equals("update")){ update(request, response); } else{ request.setAttribute("message","口令出错"); request.getRequestDispatcher("/message.jsp").forward(request, response); } } } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } public void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { userService = new UserService(); String name = request.getParameter("userName"); String password = request.getParameter("password"); if(!name.equals("")&&name!=null&&!password.equals("")&&password != ""){ int i = userService.findUserByNameAndPassword(name, password); if(i > 0){ request.getRequestDispatcher("/servlet/UserServlet?method=findAllUsers").forward(request, response); }else{ request.setAttribute("message", "登录失败，请重新确认"); request.getRequestDispatcher("/message.jsp").forward(request, response); } } } public void findAllUsers(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String showpage = request.getParameter("showpage"); if(showpage==""|| showpage == null){ showpage = "1"; } userService = new UserService(); int allRecord = userService.findAllCounts(); int pageIndex = Integer.parseInt(showpage); int pageSize = 3; List<User> list = userService.findAllUser(pageIndex, pageSize); PagingModel pagingModel = new PagingModel(); pagingModel.setPerR(pageSize); pagingModel.setCurrentP(showpage); pagingModel.setAllR(allRecord); pagingModel.setAllP(); pagingModel.setPageInfo(); pagingModel.setPageLink("servlet/UserServlet?method=findAllUsers"); request.setAttribute("list", list); request.setAttribute("pagingModel", pagingModel); request.getRequestDispatcher("/userlist.jsp").forward(request, response); } public void detail(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request.getParameter("id"); if(id != ""&& id!=null){ int userId = Integer.parseInt(id); userService = new UserService(); User user = userService.findUserById(userId); request.setAttribute("user", user); request.getRequestDispatcher("/detail.jsp").forward(request, response); }else{ request.setAttribute("message", "出错啦"); request.getRequestDispatcher("message.jsp").forward(request, response); } } public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request.getParameter("id"); if(id != ""&& id!=null){ int userId = Integer.parseInt(id); userService = new UserService(); userService.deleteUserById(userId); request.getRequestDispatcher("/servlet/UserServlet?method=findAllUsers").forward(request, response); }else{ request.setAttribute("message", "删除失败，请确认"); request.getRequestDispatcher("message.jsp").forward(request, response); } } public void register(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String name = request.getParameter("name"); String password = request.getParameter("password"); String sex = request.getParameter("sex"); String birthday = request.getParameter("birthday"); String email = request.getParameter("email"); User user = new User(); user.setName(name); user.setPassword(password); user.setSex(sex); user.setBirthday(MyUtil.string2Date(birthday)); user.setEmail(email); userService = new UserService(); int i = userService.insertUser(user); if(i > 0){ request.setAttribute("message", "注册成功"); request.getRequestDispatcher("/message.jsp").forward(request, response); } } public void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request.getParameter("id"); String name = request.getParameter("name"); String password = request.getParameter("password"); String sex = request.getParameter("sex"); String birthday = request.getParameter("birthday"); String email = request.getParameter("email"); int userId = Integer.parseInt(id); User user = new User(); user.setId(userId); user.setName(name); user.setPassword(password); user.setSex(sex); user.setBirthday(MyUtil.string2Date(birthday)); user.setEmail(email); userService = new UserService(); int i = userService.updateUser(user); if(i > 0){ request.setAttribute("message", "更新成功"); request.getRequestDispatcher("/message.jsp").forward(request, response); } } }