目录
mybatis-config.xml中添加这个user.xml
权限控制使用RBAC模式
RBAC,是一种基于角色的权限控制方案。
RBAC模型的优势
- 简化了用户和权限的关系
就是因为多了一个角色属性,通过角色可以对用户进行分组,分组完了就可以很方便的管理用户;易扩展 易于维护
MySQL表设计
表结构文件链接:https://pan.baidu.com/s/1MW74w72cYgC_OuucSl1Tsw
提取码:9sy3
Java后端
添加user对应的实体类
public class User {
private Long userId;
private String username;
private String password;
private Long employeeId;
private Integer salt;
@Override
public String toString() {
return "User{" +
"userId=" + userId +
", username='" + username + '\'' +
", password='" + password + '\'' +
", employeeId=" + employeeId +
", salt=" + salt +
'}';
}
public Long getUserId() {
return userId;
}
public void setUserId(Long userId) {
this.userId = userId;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Long getEmployeeId() {
return employeeId;
}
public void setEmployeeId(Long employeeId) {
this.employeeId = employeeId;
}
public Integer getSalt() {
return salt;
}
public void setSalt(Integer salt) {
this.salt = salt;
}
}
添加user.xml,添加通过名字查找User的SQL代码
<?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="user">
<select id="selectByUsername" resultType="com.wu.oa.entity.User">
select