📄 menu.jsp

📁 B2C的J2EE开发的 MVC +DAO 设计
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page import="ldsj.gjm.menudb.menudb"%>
<%@ page import="ldsj.gjm.pojo.menuBean" %>
<%@ page import="java.sql.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<html>
  <%
    ArrayList initList=new ArrayList();
    System.out.println("menu");
    menudb aa=new menudb(); 
    Connection con=aa.getMenuDB();
    String sql="select * from menu where userLevel=? and menuLevel=? order by menuLine";
    PreparedStatement ps=con.prepareStatement(sql);
    ps.setString(1,"public");
    ps.setInt(2,1);
    ResultSet rs=null;
     rs=ps.executeQuery();  
    while(rs.next())
    {
     String menu_name=rs.getString(2);
     int menuLevel=rs.getInt("menuLevel");
     String headmenu=rs.getString("headMenu");
     String menupath=rs.getString("menuPath");
     menuBean mb=new menuBean();
     mb.setMenuInfo_ch(menu_name);
     mb.setHeadMenu(headmenu);
     mb.setMenuLevel(menuLevel);
     mb.setMenuPath(menupath);
     initList.add(mb);
    }
    session.setAttribute("initList",initList);
  %>
  <%
     ArrayList firstList=new ArrayList();
     String right=(String)session.getAttribute("UserRight");
     System.out.println("right="+right);
    System.out.println("menu");
    menudb bb=new menudb(); 
    Connection con2=bb.getMenuDB();
    String sql2="select * from menu where userLevel=? and menuLevel=? order by menuLine";
    PreparedStatement ps2=con.prepareStatement(sql2);
    ps2.setString(1,right);
    ps2.setInt(2,1);
    ResultSet rs2=null;
    rs2=ps2.executeQuery();  
   
    while(rs2.next())
    {
     String menu_name=rs2.getString(2);
     int menuLevel=rs2.getInt("menuLevel");
     String headmenu=rs2.getString("headMenu");
     String menupath=rs2.getString("menuPath");
     String menuInfo_en=rs2.getString("menuInfo_en");
     System.out.println("menuInfo_en="+menuInfo_en);
     menuBean mb=new menuBean();
     mb.setMenuInfo_en(menuInfo_en);
     mb.setMenuInfo_ch(menu_name);
     mb.setHeadMenu(headmenu);
     mb.setMenuLevel(menuLevel);
     mb.setMenuPath(menupath);
     firstList.add(mb);
    
    }
    System.out.println(firstList.size());
    request.getSession().setAttribute("firstlist",firstList);
  %>

  <head>
   
  </head>
  
<body>
   <c:if test="${UserRight==null}">
      <c:forEach var="aa" items="${initList}">
       <a href="${aa.menuPath}"><c:out value="${aa.menuInfo_ch}"></c:out></a>&nbsp;&nbsp;&nbsp;&nbsp;
      </c:forEach>
   </c:if>
   <c:if test="${UserRight!=''}">
      <c:forEach var="aa" items="${firstlist}">
       <a href="${aa.menuPath}?menuInfo_en=${aa.menuInfo_en}"><c:out value="${aa.menuInfo_ch}"></c:out></a>&nbsp;&nbsp;&nbsp;&nbsp;
      </c:forEach>
   </c:if>
   <br><br>
  <c:if test="${not empty(secondlist)}">
  <c:forEach var="bb" items="${secondlist}">
    <a href="${bb.menuPath}"><c:out value="${bb.menuInfo_ch}"></c:out></a>&nbsp;&nbsp;&nbsp;&nbsp;
    </c:forEach>
  </c:if>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -