- mybatis/mybatis-plus打印SQL的配置
mybatis-plus:
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
- Mybatis使用collection标签,会导致分页不准确
1.一个用户对应多个角色,SQL查询返回5条记录
2.resultMap配置角色collection
3.最终返回2条记录
[
{
"userId": 1,
"userName": "张三",
"roleList": [
{
"id": 2,
"name": "总经理"
},
{
"id": 3,
"name": "部门经理"
},
{
"id": 5,
"name": "班长"
}
]
},
{
"userId": 2,
"userName": "李四",
"roleList": [
{
"id": 2,
"name": "总经理"
},
{
"id": 3,
"name": "部门经理"
}
]
}
]
4.如果使用分页则有可能会不准确
标签:name,userId,roleList,mybatis,id,随记 From: https://www.cnblogs.com/xiaohuang001/p/18065669