登录后根据用户名查询该用户的权限

lxw

2022-09-01 fac6a178e60cc78178b70556c260dde47e806cc0

登录后根据用户名查询该用户的权限

 src/main/java/com/whyc/controller/PermitGroupController.java

@@ -44,6 +44,12 @@
        return  groupService.getAllGroup();
    }

    @ApiOperation(value = "登录后根据用户名查询该用户的权限")
    @GetMapping("getPermitsByUname")
    public Response getPermitsByUname(){
        return  permitService.getPermitsByUname();
    }

    @ApiOperation(value = "添加权限组")
    @GetMapping("addGroup")
    public Response addGroup(@RequestParam String groupName){

 src/main/java/com/whyc/mapper/PermitMapper.java

@@ -2,5 +2,9 @@

import com.whyc.pojo.Permit;

import java.util.List;

public interface PermitMapper extends CustomMapper<Permit>{
    // //登录后根据用户名查询该用户的权限
    List getPermitsByUname(String name);
}

 src/main/java/com/whyc/service/PermitService.java

@@ -2,12 +2,23 @@

import com.whyc.dto.Response;
import com.whyc.mapper.PermitMapper;
import com.whyc.pojo.DocUser;
import com.whyc.util.ActionUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class PermitService {
    @Autowired(required = false)
    private PermitMapper mapper;


    //登录后根据用户名查询该用户的权限
    public Response getPermitsByUname() {
        DocUser docUser= ActionUtil.getUser();
        List list=mapper.getPermitsByUname(docUser.getName());
        return new Response().setII(1,list.size()>0?true:false,list,"返回");
    }
}

 src/main/resources/mapper/PermitMapper.xml

New file
@@ -0,0 +1,13 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.PermitMapper">


    <select id="getPermitsByUname" resultType="java.util.List">
        select distinct tb_permit.* from db_doc.tb_permit,db_doc.tb_user_group,db_doc.tb_permit_group
        where tb_user_group.group_id=tb_permit_group.group_id
        and tb_permit_group.permit_id=tb_permit.permit_id
        and tb_permit_group.category_id=tb_permit.category_id
        and tb_user_group.uname=#{name}
    </select>
</mapper>