|
<%@ 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>
|
<%-- <link rel="stylesheet" href="${ctx}/pp/css/baobiaoyangshi.css"> --%>
|
<script src="../../js/jquery-3.4.1.min.js"></script>
|
<link rel="stylesheet" href="../../css/quanxiang.css">
|
|
<style>
|
body,html{
|
width:99%;
|
height:95%
|
}
|
|
|
|
|
</style>
|
</head>
|
<%@include file="../mysqlconnect.jsp"%>
|
<body style='background-color:#D5EAFF'>
|
|
<input id="erjibianhao" name='erjibianhao' type="text" style="display:none;" value="">
|
|
<div class='menu' id='menu' >
|
<%
|
String id1=request.getParameter("adminid");
|
|
String anquanma=request.getParameter("anquanma");
|
System.out.println(id1);
|
String cn="cn";
|
int mid=0;
|
//连接数据库
|
Class.forName(driverClass);{
|
Connection con=DriverManager.getConnection( urlglass,user,password);
|
|
//通过connection数据库链接对象 创建一个statement对象数据库操作对象
|
Statement stmts=con.createStatement();
|
//执行sql语句
|
String anquan="select * from anquanbiao where anquanma = '"+request.getParameter("anquanma")+"' ";
|
ResultSet rss = stmts.executeQuery(anquan);
|
int coun=0;
|
while(rss.next())
|
{
|
coun++;
|
}
|
if(coun==0){
|
|
out.print("<script type='text/javascript'>alert('请先登录后操作');window.parent.location.href='../index.jsp'; </script>");
|
}
|
con.close();
|
}
|
|
|
Class.forName(driverClass);{
|
Connection con=DriverManager.getConnection( urlglass,user,password);
|
|
CallableStatement cs = con.prepareCall("{call mokuaichaxun()}");
|
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 quanxiancaidanchaxun(?,?)}");
|
|
css.setInt(1, mid);
|
css.setString(2, cn);
|
ResultSet rss = css.executeQuery();
|
while(rss.next()){
|
String caidanname=rss.getString(1);
|
String yemian=rss.getString(2);
|
String caidanid=rss.getString(3);
|
|
//out.println("<li><a onclick='tiaoz('"+yemian+"')' >"+caidanname+"</a></li>");
|
|
|
/* out.println("<li onclick='goUrl('shezhi2.jsp?erjibianhao="+caidanid+"')' >"+caidanname+"</li>"); */
|
|
out.print("<li class='admin' id='admin' onclick='goUrl(\"shezhi2.jsp?adminid="+request.getParameter("adminid")+"&yuyan="+request.getParameter("yuyan")+"&anquanma="+request.getParameter("anquanma")+"&erjibianhao1="+caidanid+"\",this)'>"+caidanname+" </li>");
|
out.println("<li class='item_divider'></li>");
|
}
|
out.println("</ul>");
|
|
/* */
|
}
|
con.close();
|
|
|
}
|
%>
|
|
|
|
<script>
|
//帮助跳转
|
|
//权限跳转
|
/* function goUrl(url, str,e) {
|
$('.test li').css('color','black');
|
$(e).css('color','white');
|
window.parent.document.getElementById("gongneng").src = url;
|
$("#toptitile").html(str);
|
}
|
*/
|
//展示模块列表动画效果
|
$(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)'
|
});
|
})
|
}
|
})
|
})
|
|
|
|
|
|
function goUrl(obj) {
|
|
window.parent.document.getElementById("gongneng").src = obj;
|
|
|
}
|
|
|
</script>
|
|
</body>
|
</html>
|
