第六章，selectAllUserAndRoles 方法2层嵌套查询一个用户对应的角色和权限 about book HOT 3 OPEN

DEBUG [main] - ==>  Preparing: select u.id, u.user_name, u.user_password, u.user_email, u.user_info, u.head_img, u.create_time, r.id role_id, r.role_name role_role_name, r.enabled role_enabled, r.create_by role_create_by, r.create_time role_create_time, p.id role_privilege_id, p.privilege_name role_privilege_privilege_name, p.privilege_url role_privilege_privilege_url from sys_user u inner join sys_user_role ur on u.id = ur.user_id inner join sys_role r on ur.role_id = r.id inner join sys_role_privilege rp on rp.role_id = r.id inner join sys_privilege p on p.id = rp.privilege_id 
DEBUG [main] - ==> Parameters: 
TRACE [main] - <==    Columns: id, user_name, user_password, user_email, user_info, head_img, create_time, role_id, role_role_name, role_enabled, role_create_by, role_create_time, role_privilege_id, role_privilege_privilege_name, role_privilege_privilege_url
TRACE [main] - <==        Row: 1, admin, 123456, [email protected], <<BLOB>>, <<BLOB>>, 2016-06-07 01:11:12.0, 1, 管理员, 1, 1, 2016-04-01 17:02:14.0, 1, 用户管理, /users
TRACE [main] - <==        Row: 1, admin, 123456, [email protected], <<BLOB>>, <<BLOB>>, 2016-06-07 01:11:12.0, 1, 管理员, 1, 1, 2016-04-01 17:02:14.0, 3, 系统日志, /logs
TRACE [main] - <==        Row: 1, admin, 123456, [email protected], <<BLOB>>, <<BLOB>>, 2016-06-07 01:11:12.0, 1, 管理员, 1, 1, 2016-04-01 17:02:14.0, 2, 角色管理, /roles
TRACE [main] - <==        Row: 1, admin, 123456, [email protected], <<BLOB>>, <<BLOB>>, 2016-06-07 01:11:12.0, 2, 普通用户, 1, 1, 2016-04-01 17:02:34.0, 4, 人员维护, /persons
TRACE [main] - <==        Row: 1001, test, 123456, [email protected], <<BLOB>>, <<BLOB>>, 2016-06-07 00:00:00.0, 2, 普通用户, 1, 1, 2016-04-01 17:02:34.0, 4, 人员维护, /persons
TRACE [main] - <==        Row: 1, admin, 123456, [email protected], <<BLOB>>, <<BLOB>>, 2016-06-07 01:11:12.0, 2, 普通用户, 1, 1, 2016-04-01 17:02:34.0, 5, 单位维护, /companies
TRACE [main] - <==        Row: 1001, test, 123456, [email protected], <<BLOB>>, <<BLOB>>, 2016-06-07 00:00:00.0, 2, 普通用户, 1, 1, 2016-04-01 17:02:34.0, 5, 单位维护, /companies
DEBUG [main] - <==      Total: 7
用户数：2
用户名：admin
角色名：管理员
权限名：用户管理
权限名：系统日志
权限名：角色管理
角色名：普通用户
权限名：人员维护
权限名：单位维护
用户名：test
角色名：普通用户
权限名：人员维护
权限名：单位维护