MyBatis联合查询（一对一）一

package dao;

import domain.Person;
import org.apache.ibatis.session.SqlSession;
import util.MySqlSession;

import java.util.List;

public class PersonDao {
    //主函数
    public static void main(String[] args) {

        PersonDao personDao = new PersonDao();
//        Person person = personDao.selectOne(1);
        List<Person> personList = personDao.selectList();
        System.out.println(personList);
//        System.out.println(person.getPid());
//        System.out.println(person.getPname());
//        System.out.println(person.getIdCard().getAddress());
    }
    //SqlSession对象
    SqlSession sqlSession = MySqlSession.getSqlSession(true);

    public Person selectOne(int pid) {
        return sqlSession.selectOne("selectOne", pid);
    }

    public List<Person> selectList() {
        return sqlSession.selectList("selectList");
    }
}

<?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="dao.PersonDao">

    <resultMap id="selectFunction" type="domain.Person">
        <id property="pid" column="pid"></id>
        <result property="pname" column="pname"></result>
        <association property="idCard" javaType="domain.IdCard" select="selectCardId" column="cardId"></association>
    </resultMap>
    <select id="selectCardId" resultType="domain.IdCard">
        select * from idcard where cardId = #{cardId}
    </select>
    <select id="selectOne" resultMap="selectFunction">
        select pid,pname,cardId from person where pid = #{pid}
    </select>

    <select id="selectList" resultMap="selectFunction">
        select pid,pname,cardId from person
    </select>
</mapper>