10月22日 Spring Cloud 周一

最新推荐文章于 2024-11-08 10:54:48 发布

helloworld_1996

最新推荐文章于 2024-11-08 10:54:48 发布

阅读量129

点赞数

CC 4.0 BY-SA版权

分类专栏： 2018

本文链接：https://blog.youkuaiyun.com/helloworld_1996/article/details/83280331

2018 专栏收录该内容

337 篇文章

订阅专栏

本文详细介绍了用户权限管理系统的SQL查询语句，包括用户信息、角色及权限的关联查询，以及前端页面的实现代码，展示了如何通过Ajax进行数据交互。

SELECT  u.userid,u.username,u.usersex,u.userage, GROUP_CONCAT(R.rolename) AS rolename,GROUP_CONCAT(p.powername) as powername from t_user u 
	left join t_ur ur on u.userid = ur.userid
	left join t_role r on ur.roleid = r.roleid
	left join t_rp rp on r.roleid = rp.roleid
	left join t_power p on rp.powerid = p.powerid
	GROUP BY U.userid
	
	
SELECT  u.userid,u.username,r.rolename from t_user u 
	left join t_ur ur on u.userid = ur.userid
	left join t_role r on ur.roleid = r.roleid
	where u.userid = 3
	
	select roleid,rolename from t_role
	
	select userid,roleid from t_ur where userid = 1
	
	select u.userid,u.username,u.usersex,u.userage,GROUP_CONCAT(r.rolename),GROUP_CONCAT(p.powername) from t_user u 
	left join t_ur ur on u.userid = ur.userid
	left join t_role r on ur.roleid = r.roleid
	left join t_rp rp on rp.roleid = r.roleid
	left join t_power p on rp.powerid = p.powerid
	group by u.userid

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script type="text/javascript" src="static/jquery-1.8.2.min.js"></script>
<script type="text/javascript">
	$.ajaxSettings.async = false;
	$(function (){
	})
	function function1(){
		var a = $("form").serialize();
		alert(a);
		$.post(
			"updateRole",
			$("form").serialize(),
			function (message){
				if(message>=0){
					location="list";
				}
			},"json"
		)
	}
	function function2(){
		var id = $("#userid").val();
		$.post(
			"getRole",
			{id:id},
			function (message){
				$(".ck").attr("checked",false);
				for(var i in message){
					var roleId = message[i].roleid;
					$(":checkbox[value="+roleId+"]").attr("checked",true);
				}
			},"json"
		)
	}
</script>
</head>
<body>
	<form action="">
	<select name="userid" onchange="function2()" id="userid">
	<#list userList as u>
		<option value="${u.userid}" >${u.username}</option>
	</#list>
	</select><br>
	<#list roleList as r>
		<input type="checkbox" value="${r.roleid}" name="rolename" class="ck">${r.rolename}
	</#list><br>
	<input type="button" value="提交" onclick="function1()">
	</form>
</body>
</html>

当人们做不到一些事情的时候，他们就会对你说你也同样不能。
《当幸福来敲门》