10,606
社区成员
发帖
与我相关
我的任务
分享
package com.example.Entity;
public class SysRole {
private Integer id;
private String name;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
package com.example.Entity;
import java.util.List;
public class SysUser {
private Integer id;
private String username;
private String password;
private List<SysRole> roles;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
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 List<SysRole> getRoles() {
return roles;
}
public void setRoles(List<SysRole> roles) {
this.roles = roles;
}
}
@Select("select u.* ,r.name from Sys_User u LEFT JOIN sys_role_user on u.id= sys_role_user.Sys_User_id LEFT JOIN Sys_Role r on sys_role_user.Roles_id=r.id where username=#{username}")
SysUser findByUserName(String username);