权限

权限管理

今天进行权限的管理
首先导入spring包

   <dependency>
      <groupId>org.springframework.security</groupId>
      <artifactId>spring-security-web</artifactId>
      <version>${spring.security.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework.security</groupId>
      <artifactId>spring-security-config</artifactId>
      <version>${spring.security.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework.security</groupId>
      <artifactId>spring-security-core</artifactId>
      <version>${spring.security.version}</version>
    </dependency>
    <dependency>
      <groupId>org.springframework.security</groupId>
      <artifactId>spring-security-taglibs</artifactId>
      <version>${spring.security.version}</version>
    </dependency>

添加依赖

    <param-value>classpath*:applicationContext.xml,classpath*:spring-security.xml</param-value>

新建表

实现类

	@Override
	public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
        UserInfo userInfo=userInfoDao.findByUserName(username);
        List<Role> roles= roleDao.findRoleByUserId(userInfo.getId());
		User user=new User(userInfo.getUsername(),"{noop}"+userInfo.getPassword(),getAuthority(roles));
		return user;
	}
	private Collection<?extends GrantedAuthority> getAuthority(List<Role> roles){
		List<SimpleGrantedAuthority> list=new ArrayList<>();
		for(Role role:roles){
			list.add(new SimpleGrantedAuthority("ROLE_"+role.getRolename()));
		}
		return  list;
	}
}

sql语句

<select id="findRoleByUserId" parameterType="int" resultType="com.zhongruan.bean.Role">
    select * from role where id in(select roleid from user_role where userid=#{id})
</select>

   <select id="findByUserName" parameterType="String" resultType="com.zhongruan.bean.UserInfo">
      select * from userinfo where username=#{username}
   </select>

登录

成功