roleservlet.java

一个jsp的oa系统,里面有很多亮点学习!

package com.oa.lp.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.oa.lp.dao.RoleDAO;
import com.oa.lp.database.DataBase;
import com.oa.lp.model.Role;
import com.oa.lp.util.PageList;
import com.oa.lp.util.Pages;


public class RoleServlet extends TopServlet{
   static final long serialVersionUID = 1L;

   
   protected void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	
	   //接参
	   String method = request.getParameter("method")==null?"":request.getParameter("method");
	   String roleId = request.getParameter("roleId")==null?"0":request.getParameter("roleId");
	   String roleName = request.getParameter("roleName");
	   String roleDesci = request.getParameter("roleDesci");
	   String roleState = request.getParameter("roleState")==null?"0":request.getParameter("roleState");
	   //封装对象
	   Role role = new Role();
	   if(roleId.length()>0){
		   role.setRoleId(Integer.parseInt(roleId));
	   }
	   if(roleState.length()>0){
		   role.setRoleState(Integer.parseInt(roleState));
	   }
	   role.setRoleName(roleName);
	   role.setRoleDesci(roleDesci);
	  
	   Connection conn=null;
	try {
		
		conn = DataBase.getConnection();
		RoleDAO roleDao = new RoleDAO();
		roleDao.setConn(conn);
		
		if(method.equals("list")){
			//角色列表
			//构造分页对象
			Pages page = new Pages("/RoleServlet?method=list",request);
			page.setPageSize(10);//设置分页大小
			PageList pageList = roleDao.listAllRole(page);
			request.setAttribute("pageList", pageList);
			this.forward(request, response,"/system/role/list.jsp");
		}else if(method.equals("add")){
			//新增角色
			roleDao.addRole(role);
			this.sendRedirect(request,response,"/RoleServlet?method=list");
			
		}else if(method.equals("update")){
			//更新角色
			roleDao.updateRole(role);
			this.sendRedirect(request, response,"/RoleServlet?method=list");
		}else if(method.equals("edit")){
			//通过角色ID查找角色
			request.setAttribute("role",roleDao.getById(Integer.parseInt(roleId)));
			this.forward(request, response,"/system/role/role.jsp");
		}else if(method.equals("del")){
			//删除角色
			if(roleDao.delRole(role.getRoleId())){
				//删除成功
			}else{
				//删除失败
			}
			this.sendRedirect(request, response, "/RoleServlet?method=list");
		}else if(method.equals("addLoad")){
			this.forward(request, response,"/system/role/role.jsp");
		}
		//事务提交
		DataBase.commit();
		
	} catch (Exception e) {
		e.printStackTrace();
	}finally{
		if(conn!=null){
			//关闭连接
			DataBase.releaseConnection(conn);
		}
	}
	   
}
   
   
}