'lxw'

he wei

2022-09-02 d69b38ae695ff86d265e84fb44e1b21217a97d5f

'lxw'

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

@@ -1,10 +1,11 @@
package com.whyc.mapper;

import com.whyc.pojo.Permit;
import org.apache.ibatis.annotations.Param;

import java.util.List;

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

 src/main/resources/mapper/PermitMapper.xml

@@ -3,11 +3,10 @@
<mapper namespace="com.whyc.mapper.PermitMapper">


    <select id="getPermitsByUname" resultType="java.util.List">
    <select id="getPermitsByUname" resultType="Permit">
        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>