Mybatis实现查询相册数据列表流程讲解

@Data
public class AlbumListItemVO implements Serializable {
    private Long id;
    private String name;
    private String description;
    private Integer sort;
}

<!-- List<AlbumListItemVO> list(); -->
<select id="list" resultMap="ListResultMap">
    SELECT
    	<include refid="ListQueryFields"/>
    FROM
    	pms_album
    ORDER BY
    	sort DESC, id DESC
</select>
<sql id="ListQueryFields">
	id, name, description, sort
</sql>
<resultMap id="ListResultMap" type="cn.tedu.csmall.product.pojo.vo.AlbumListItemVO">
    <id column="id" property="id" />
    <result column="name" property="name" />
    <result column="description" property="description" />
    <result column="sort" property="sort" />
</resultMap>

@Test
void list() {
    List<?> list = mapper.list();
    log.debug("查询列表完成，结果中的数据的数量：{}", list.size());
    for (Object item : list) {
        log.debug("{}", item);
    }
}