mapper.xml中association的使用

association是一对一的映射，对应的是javaType

collection是一对多映射，对应的是ofType

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zsh.demo.mapper.SysUserMapper">
    <resultMap id="userType" type="com.zsh.demo.entity.SysUser">
        <id column="id" property="id"></id>
        <result column="username" property="username"></result>
        <result column="password" property="password"></result>
        <result column="nickname" property="nickname"></result>
        <result column="email" property="email"></result>
        <result column="phone" property="phone"></result>
        <result column="address" property="address"></result>
        <result column="create_time" property="createTime"></result>
        <result column="avatar_url" property="avatarUrl"></result>
        <association property="sysPerson"  javaType="com.zsh.demo.entity.SysPerson">
            <id column="id" property="id"></id>
            <result column="user_id" property="userId"></result>
            <result column="sex" property="sex"></result>
        </association>
    </resultMap>
    <select id="findAll" resultMap="userType">
        select * from sys_user u join sys_person p on u.id=p.user_id
    </select>
</mapper>