Servlet+jsp+AJax的分页及增删改查

package cn.bjit.servlet; import java.io.IOException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import net.sf.json.JSONArray; import net.sf.json.JSONObject; import cn.bjit.dao.RoleDao; import cn.bjit.dao.UserDao; import cn.bjit.dao.impl.RoleDaoImpl; import cn.bjit.dao.impl.UserDaoImpl; import cn.bjit.domain.Role; import cn.bjit.domain.User; import cn.bjit.domain.User_Role; import cn.bjit.service.impl.RoleServiceImpl; import cn.bjit.service.impl.UserServiceImpl; import cn.bjit.util.Constants; import cn.bjit.util.PageBean; /** * * @author yx * */ public class UserServlet extends HttpServlet { @Override protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); String result = request.getParameter("action"); if ("login".equals(result)) { this.doLogin(request, response); } else if ("list".equals(result)) { this.doPageList(request, response); } else if ("addUI".equals(result)) { this.doAddUI(request, response); } else if ("add".equals(result)) { this.doAdd(request, response); } else if ("editUI".equals(result)) { this.doEditUI(request, response); } else if ("edit".equals(result)) { this.doEdit(request, response); } else if ("delete".equals(result)) { this.doDel(request, response); } else { this.doList(request, response); } } /**删除*/ private void doDel(HttpServletRequest request, HttpServletResponse response) throws IOException{ String strId = request.getParameter("id"); Map<String,Object> map=new HashMap<String,Object>(); UserServiceImpl userService = new UserServiceImpl(); UserDao userDao = new UserDaoImpl(); userService.setUserDao(userDao); if(userService.deleteUser(Integer.parseInt(strId))) map.put(Constants.RESULT_CODE, Constants.RESULT_CODE_SUCCESS); else map.put(Constants.RESULT_CODE, Constants.RESULT_CODE_FAILURE); response.getWriter().print(JSONObject.fromObject(map)); } /**修改*/ private void doEdit(HttpServletRequest request, HttpServletResponse response) throws IOException { Map<String,Object> map=new HashMap<String,Object>(); User user=new User(); user.setUserId(Integer.parseInt(request.getParameter("userId"))); user.setUserName(request.getParameter("userName")); user.setRoleId(Integer.parseInt(request.getParameter("roleId"))); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); try { user.setBirth(format.parse(request.getParameter("birth"))); } catch (ParseException e) { e.printStackTrace(); } UserServiceImpl userService = new UserServiceImpl(); UserDao userDao = new UserDaoImpl(); userService.setUserDao(userDao); if(userService.updateUser(user)){ map.put(Constants.RESULT_CODE, Constants.RESULT_CODE_SUCCESS); }else{ map.put(Constants.RESULT_CODE, Constants.RESULT_CODE_FAILURE); } response.getWriter().print(JSONObject.fromObject(map)); } /**去修改页面*/ private void doEditUI(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { UserServiceImpl userService = new UserServiceImpl(); UserDao userDao = new UserDaoImpl(); userService.setUserDao(userDao); RoleServiceImpl roleService = new RoleServiceImpl(); RoleDao roleDao = new RoleDaoImpl(); roleService.setRoleDao(roleDao); String strId = request.getParameter("id"); request.setAttribute("user", userService.findUserById(Integer.parseInt(strId))); request.setAttribute("currPageNo", request.getParameter("currPageNo"));//得到当前页 request.setAttribute("roleList", roleService.findAll()); request.getRequestDispatcher("/SaveOrEdit.jsp").forward(request, response); } /**执行添加*/ private void doAdd(HttpServletRequest request, HttpServletResponse response) throws IOException { Map<String,Object> map=new HashMap<String,Object>(); User user=new User(); user.setUserName(request.getParameter("userName")); user.setRoleId(Integer.parseInt(request.getParameter("roleId"))); SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd"); try { user.setBirth(format.parse(request.getParameter("birth"))); } catch (ParseException e) { e.printStackTrace(); } UserServiceImpl userService = new UserServiceImpl(); UserDao userDao = new UserDaoImpl(); userService.setUserDao(userDao); if(userService.addUser(user)){ map.put(Constants.RESULT_CODE, Constants.RESULT_CODE_SUCCESS); }else{ map.put(Constants.RESULT_CODE, Constants.RESULT_CODE_FAILURE); } response.getWriter().print(JSONObject.fromObject(map)); } /**去添加页面*/ private void doAddUI(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { RoleServiceImpl roleService = new RoleServiceImpl(); RoleDao roleDao = new RoleDaoImpl(); roleService.setRoleDao(roleDao); List<Role> roleList = roleService.findAll(); request.setAttribute("roleList", roleList); request.setAttribute("user", null); request.getRequestDispatcher("/SaveOrEdit.jsp").forward(request, response); } private void doList(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.getRequestDispatcher("/list.jsp").forward(request, response); } /**分页*/ private void doPageList(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); String pageIndex = request.getParameter("currPageNo"); String userName = request.getParameter("searchName"); UserServiceImpl userService = new UserServiceImpl(); UserDao userDao = new UserDaoImpl(); userService.setUserDao(userDao); int totalRecords = userService.getTotalRecords(userName);// 获取总记录数 if (pageIndex == null || pageIndex == "") { pageIndex = "1"; } PageBean pageBean = new PageBean(); pageBean.setPageSize(3); // 设置每页显示3条信息 pageBean.setCurrPageNo(Integer.parseInt(pageIndex)); // 设置当前页 pageBean.setTotalRecords(totalRecords);// 设置总记录数 // 调用分页的方法 List<User_Role> list = userService.pageList(pageBean.getCurrPageNo(), pageBean.getPageSize(), userName); Map<String, Object> map = new HashMap<String, Object>(3); map.put("pageBean", JSONObject.fromObject(pageBean)); // 对象转json map.put("data", JSONArray.fromObject(list)); // list转json map.put(Constants.RESULT_CODE, Constants.RESULT_CODE_SUCCESS); JSONObject strMapJson = JSONObject.fromObject(map); // map转json response.getWriter().print(strMapJson); } /**登录*/ private void doLogin(HttpServletRequest request, HttpServletResponse response) throws IOException { request.setCharacterEncoding("UTF-8"); String uname = request.getParameter("username"); String pwd = request.getParameter("password"); UserServiceImpl impl = new UserServiceImpl(); UserDao userDao = new UserDaoImpl(); impl.setUserDao(userDao); User user = impl.findByNameAndPwd(new User(uname, pwd)); if (user.getUserName() != null && !user.getUserName().equals("")) { //request.getSession().setAttribute("user", user); response.sendRedirect(request.getContextPath() + "/userServlet"); } } }