MyBatis联合查询（一对一）二

最新推荐文章于 2024-01-18 10:19:20 发布

「已注销」

最新推荐文章于 2024-01-18 10:19:20 发布

阅读量51

点赞数

本文链接：https://blog.csdn.net/m0_51945027/article/details/113956804

版权

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();
        for (Person person : personList) {
            System.out.println(person);
        }
//        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="selectByPid" type="domain.Person">
        <id property="pid" column="pid"></id>
        <result property="pname" column="pname"></result>
        <association property="idCard" javaType="domain.IdCard">
            <id property="cardId" column="cardId"></id>
            <result property="address" column="address"></result>
        </association>
    </resultMap>
    <select id="selectOne" resultMap="selectByPid">
        select * from person p inner join idcard i on p.cardid = i.cardid where p.pid = #{pid}
    </select>
    <select id="selectList" resultMap="selectByPid">
        select * from person p inner join idcard i on p.cardid = i.cardid
    </select>


<!--    <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>