managerrole.java

用jdbc写的一个存储过程的代码

package com.bluedot.web.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 com.bluedot.domain.Fun;
import com.bluedot.domain.Role;
import com.bluedot.service.PriviligeManager;
import com.bluedot.service.PriviligeManagerImpl;

public class ManagerRole extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		// 状态1：点击左侧菜单选项过来的。
		String roleId = request.getParameter("roleId");

		if (roleId != null && roleId.length() > 0) {
			String rId = request.getParameter("flag");

			if (rId.equals(roleId)) {
				// 状态2：改变某一个角色的功能。
				request.setAttribute("flag", rId);
				String[] changeId = request.getParameterValues("changeId");
				PriviligeManager m = new PriviligeManagerImpl();
				try {
					m.changeRoleWithItsFuns(Integer.parseInt(roleId), changeId);
				} catch (Exception e) {
					response.sendRedirect("error.jsp");
				}
				
				
				List<Role> list = m.findAllRoles();
				List<Fun> list2 = m.findAllFuns();

				request.setAttribute("list", list);
				request.setAttribute("list2", list2);
				request.setAttribute("flag", roleId + "");
				request.getRequestDispatcher("managerFun.jsp").forward(request,
						response);
				
			} else {
				// 状态3：改变下拉菜单。
				PriviligeManager m = new PriviligeManagerImpl();
				List<Role> list = m.findAllRoles();
				List<Fun> list2 = m.findAllFuns();

				request.setAttribute("list", list);
				request.setAttribute("list2", list2);
				request.setAttribute("flag", roleId + "");
				request.getRequestDispatcher("managerFun.jsp").forward(request,
						response);
			}

		} else {
			PriviligeManager m = new PriviligeManagerImpl();
			List<Role> list = m.findAllRoles();
			List<Fun> list2 = m.findAllFuns();

			request.setAttribute("list", list);
			request.setAttribute("list2", list2);
			request.setAttribute("flag", list.get(0).getId() + "");
			request.getRequestDispatcher("managerFun.jsp").forward(request,
					response);
		}

	}

}