Mybatis的xml实用的一些技巧

1.结果映射技巧

    <resultMap id="myMap" type="com.shixin.vo.MyVO">
        <id column="id" property="id" />
        <result column="name" property="name" />
        <result column="type" property="type" />
        <collection property="subList" ofType="com.shixin.vo.SubVO">
            <id column="subId" property="subId" />
            <result column="subName" property="subName" />
            <result column="subType" property="subType" />
        </collection>
    </resultMap>

对应的java类

@Data
public class MyVO {
    private Integer id;
    private String name;
    private String type;
    //三级分类vo List
    private List<SubVO&g