遇到这种情况的实体类,需要在mapper.xml文件里使用
resultMap标签以及其他子标签.
先贴代码:
实体类:
private Long id;// 用户id private String username;// 用户名 private String password;// 密码 private ListuserRoles;// 用户权限集合
Mapper 接口
ListgetUserByUsername(@Param("username") String username);
UserMapper .xml
SELECT u.id, u.username, u.`password`, r.role_name,r.id FROM `t_role` r, t_user u, t_user_roles ur WHERe r.id = ur.role_id AND u.id = ur.user_id AND u.username = #{username}
结果:
[
{
"id": null,
"username": "user",
"password": "user001",
"userRoles": [
{
"id": 1,
"roleName": "ROLE_USER"
}
],
"roleMenus": null,
"authorities": null,
"enabled": true,
"accountNonExpired": true,
"credentialsNonExpired": true,
"accountNonLocked": true
}
]



