直接对比
1、以前Mapper多表查询类似如下
resultType="com.lazy.develop.model.UserRolePage">
SELECT
u.id,
u.login_name AS loginName,
u.`password`,
u.create_time AS createTime,
r.role_name AS roleName
FROM
`user` u
JOIN role r ON u.`level` = r.id
u.create_time >= #{startTime,jdbcType=TIMESTAMP}
AND u.create_time <= #{endTime,jdbcType=TIMESTAMP}
AND u.level > #{level,jdbcType=BIGINT}
这种情况多数,我们需要2个model(UserRolQuery和UserRolePage)
2、用Record.class(用map封装的)时如下
resultType="com.lazy.develop.model.Record">
SELECT
u.id,
u.login_name AS loginName,
u.`password`,
u.create_time AS createTime,
r.role_name AS roleName
FROM
`user` u