javaweb权限管理模块.rar

package com.right.servlet; import java.io.IOException; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.jdbc.util.JdbcUtils; /** * Servlet implementation class InitMenuServlet */ @WebServlet("/InitMenuServlet") public class InitMenuServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public InitMenuServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 获取当前登录用户 String username = (String)request.getSession().getAttribute("username"); String sql = "select * from `right` " + "where rightId in (" + "select rightId from roleright where roleId=(" + "select roleId from user where username=?)) and parentId='root'"; // 获取该用户主菜单 List<Map<String,Object>> mainMenu = JdbcUtils.executeQuery(sql, username); // 获取该用户的子菜单 sql = "select * from `right` where " + "rightId in (" + "select rightId from roleright where roleId=(" + "select roleId from user where username=?)) and parentId<>'root'"; List<Map<String,Object>> childMenu = JdbcUtils.executeQuery(sql, username); // 把主子菜单存在在request对象中 request.setAttribute("mainMenu", mainMenu); request.setAttribute("childMenu", childMenu); request.getRequestDispatcher("index.jsp").forward(request, response); } }