MyBatis的关联映射（一对一查询）

最新推荐文章于 2024-08-26 16:40:46 发布

gzj20031112

最新推荐文章于 2024-08-26 16:40:46 发布

阅读量44

点赞数

文章标签： mybatis java 开发语言

本文链接：https://blog.csdn.net/gzj20031112/article/details/130904528

版权

本文详细介绍了在MyBatis中实现一对一查询的全过程，包括数据库准备、实体类定义、接口与XML配置文件的编写，以及如何进行嵌套查询。通过示例代码展示了Person与IdCard的关联映射，并提供了测试用例及运行结果。

摘要由CSDN通过智能技术生成

一对一查询

数据库准备

USE mybatis;
CREATE TABLE  tb_idcard( 
     id INT PRIMARY KEY AUTO_INCREMENT,
     CODE VARCHAR(18));
INSERT INTO tb_idcard(CODE) VALUES('152221198711020624');
INSERT INTO tb_idcard(CODE) VALUES('152201199008150317');
CREATE TABLE  tb_person( 
     id INT PRIMARY KEY AUTO_INCREMENT,
     name VARCHAR(32),
     age INT,
     sex VARCHAR(8),
     card_id INT UNIQUE,     
     FOREIGN KEY(card_id) REFERENCES tb_idcard(id));
 
INSERT INTO tb_person(name,age,sex,card_id) VALUES('Rose',22,'女',1);
INSERT INTO tb_person(name,age,sex,card_id) VALUES('jack',23,'男',2);

实体类

Person.java

用户配置接口

IdCardMapper.java

PersonMapper.java

package com.biem.mapper;
 
public interface PersonMapper {
}

用户配置文件

IdCardMapper.xml

PersonMapper.xml

<?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.biem.mapper.PersonMapper">
 
 
</mapper>

嵌套查询方式

IdCardMapper.java添加

public IdCard findCodeById(Integer id);

PersonMapper.java添加

public Person findPersonById(Integer id);

IdCardMapper.xml添加

<select id="findCodeById" parameterType="Integer" resultType="IdCard">
        select * from tb_idcard where id=#{id}
</select>

PersonMapper.xml添加

<resultMap id="IdCardWithPersonResult" type="Person">
        <id property="id" column="id"></id>
        <result property="name" column="name"/>
        <result property="age" column="age"/>
        <result property="sex" column="sex"/>
        <association property="card" column="card_id" javaType="IdCard"
                     select="com.biem.mapper.IdCardMapper.findCodeById"/>
 </resultMap>
 
 <select id="findPersonById" parameterType="Integer" resultMap="IdCardWithPersonResult">
        select * from tb_person where id = #{id}
 </select>

PersonTest.java

package com.biem.test;
 
import com.biem.mapper.PersonMapper;
import com.biem.pojo.Person;
import com.biem.util.MybatisUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
 
public class PersoTest {
        @Test
        public void testFindPersonById(){
            SqlSession session = MybatisUtil.openSession();
            PersonMapper mapper = session.getMapper(PersonMapper.class);
            Person person = mapper.findPersonById(1);
            System.out.println(person);
            session.close();
        }
    }