guoyuji
2023-10-08 7dbbcd0e54b4094e9f2b620197147e69911669c6
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html >
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>北玻</title>
<script src="../js/jquery-3.4.1.min.js"></script>
<link rel="stylesheet" href="../css/quanxiang.css">
<link rel="shortcut icon" href="../img/3.ico" />
<script>
    //展示模块列表动画效果
    $(function() {
        //1.获取菜单元素
        var dv = $(".menu div");
        dv.click(function() {
            
            var die = $(this);
            //2.获取span的id名称
            var jiantou = $(this).children("span").attr("id");
            if (die.next("ul").is(":hidden")) {
                $("ul").hide(500);
                die.next("ul").show(500);
                $('#' + jiantou + '').animate({}, function() {
                    $(this).css({
                        //旋转角度
                        /* 'transform': 'rotate(90deg)' */
                    });
                })
            } else {
                //3.点击隐藏菜单
                die.next("ul").hide(500);
                $('#' + jiantou + '').animate({}, function() {
                    $(this).css({
                        'transform': 'rotate(0deg)'
                    });
                })
            }
        })
    })
     
</script>
</head>
 
 
<%@include file="mysqlconnect.jsp"%>
<body  style='background-color:#D5EAFF;overflow-y:hidden'>
    <!--主页面左侧菜单栏实现-->
    
    <div class="menu" >
        <%
String id=request.getParameter("adminid");
String anquanma=request.getParameter("anquanma");
System.out.println(id);
String cn=request.getParameter("yuyan");
int mid=0;
//连接数据库
 
Class.forName(driverClass);{
    Connection con=DriverManager.getConnection( urlglass,user,password);
    
    CallableStatement cs = con.prepareCall("{call mokuai(?,?,?)}");
    id=request.getParameter("adminid");
    cn="cn";
       cs.setString(1, id);
       cs.setString(2, cn);
       cs.setString(3, request.getRemoteAddr());
       ResultSet rs = cs.executeQuery();
    while(rs.next())
    {
        
                  mid=rs.getInt(1);
                 String mokuainame=rs.getString(2);
                 out.println("<div class='menu_title'>"+mokuainame+"<span class='indicator' id='indicator'>▼</span></div><ul class='test'>");
                
                 CallableStatement css = con.prepareCall("{call caidan(?,?,?,?)}");
                 css.setString(1, id);
                 css.setInt(2, mid);
                 css.setString(3, cn);
               css.setString(4, request.getRemoteAddr());
                 ResultSet rss = css.executeQuery();
                 while(rss.next()){
                     String caidanname=rss.getString(1);
                     String yemian=rss.getString(2);
                     //out.println("<li><a onclick='tiaoz('"+yemian+"')' >"+caidanname+"</a></li>");
                     out.println("<li  onclick="+"tiaoz('"+yemian+"',"+mid+")"+" >"+caidanname+"</li>");
                     out.println("<li class='item_divider'></li>");
                 } 
                 out.println("</ul>"); 
                  
        
    }
    con.close(); 
    
         
}
%>
        
    </div>
    <script>
    window.onload=function(){
        if(localStorage.getItem("newPage")!=null){
            let url=localStorage.getItem("newPage");
            url=url+'&'+window.parent.location.search.substr(1);
            window.parent.document.getElementById("main").src = url;    
        }
        
    }
     function tiaoz(n,mid){
         if(mid!=90){
             localStorage.setItem("newPage",n);
         }
         
         n=n+'&'+window.parent.location.search.substr(1);
         
         
         if (mid==90) {
              window.open(n, '_blank'); // 在新窗口中打开指定 URL
            }else{
                 window.parent.document.getElementById("main").src = n;
                
            }
         }
    </script>
</body>
</html>