在前两天我们实现了项目的搭建以及数据库的增删改查还实现了对搜索功能的模糊查询以及用户列表的分页式管理,还不太明白的可以看看这两篇博客https://blog.csdn.net/qq_43510659/article/details/107537596
https://blog.csdn.net/qq_43510659/article/details/107513607
首先数据库中新建tb_role表以及user_role表分别用来存储角色信息以及用户和角色的对应关系
bean包中新建一个Role类和UserRole类是数据库中tb_role表和user_role表对应的实体类
Role类
public class Role {
private int id;
private String rolename;
private String roledesc;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getRolename() {
return rolename;
}
public void setRolename(String rolename) {
this.rolename = rolename;
}
public String getRoledesc() {
return roledesc;
}
public void setRoledesc(String roledesc) {
this.roledesc = roledesc;
}
@Override
public String toString() {
return "Role{" +
"id=" + id +
", rolename='" + rolename + '\'' +
", roledesc='" + roledesc + '\'' +
'}';
}
}
UserRole类
public class UserRole {
private int id;
private int userId;
private int roleId;
public UserRole(){
}
public UserRole(int id, int userId, int roleId) {
this