Mybatis中的一对一关系映射

数据表之间存在一对一、一对多和多对多的关系。

嵌套查询

       在生活中存在多个一对一的情况，身份证和人就是一对一。项目要求，在查询每个人的时候，同时将每一个人的idcard查询出来。如果在不使用一对一映射的条件下：可以先将每个人的信息进行查询，让入到List<Map<String,Object>> 集合中。然后遍历集合，查询集合中每个人的身份证id，根据id查询身份证信息，然后将身份信息放入list集合中。

1. 在数据库中建立一对一的映射关系

1.1 person表，存储这person 的 id（主键），姓名，年龄，性别，身份证id（外键）

                                                     

1.2 idCard表，存储着身份证信息，id（主键），身份证号码

                                            

1.3 建立IdCard 类

package com.wx.domain;

public class IdCard {
	private Integer id;
	private String code;
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getCode() {
		return code;
	}
	public void setCode(String code) {
		this.code = code;
	}
	@Override
	public String toString() {
		return "IdCard [id=" + id + ", code=" + code + "]";
	}
	
}

1.4 建立Person类

package com.wx.domain;

public class Person {
	private Integer id;
	private String name;
	private Integer age;
	private String sex;
	private Integer card_id;
	private IdCard idCard;
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Integer getAge() {
		return age;
	}
	public void setAge(Integer age) {
		this.age = age;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public Integer getCard_id() {
		return card_id;
	}
	public void setCard_id(Integer card_id) {
		this.card_id = card_id;
	}
	
	
	public IdCard getIdCard() {
		return idCard;
	}
	public void setIdCard(IdCard idCard) {
		this.idCard = idCard;
	}
	@Override
	public String toString() {
		return "Person [id=" + id + ", name=" + name + ", age=" + age
				+ ", sex=" + sex + ", card_id=" + card_id + ", idCard="
				+ idCard + "]";
	}
	
	
}	

1.5 建立IdCardMapper.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.wx.mapper.IdCardMapper">
	<select id="searchIdCard" parameterType="Integer" resultType="idCard">
		select * from tb_idcard where id =#{id}
	</select>
</mapper>

1.6 建立 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.wx.mapper.PersonMapper">
	<select id="findPersonById" parameterType="Integer" resultMap="IdCardWithPersonResult">
		select * from tb_person where id = #{id}
	</select>
	<resultMap type="person" id="IdCardWithPersonResult">
		<id property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="age" column="age"/>
		<result property="sex" column="sex"/>
		<result property="card_id" column="card_id"/>
		<!-- 一对一：association使用select属性引入另外一条sql语句 -->
		<association property="idCard" column="card_id" javaType="idCard" select="com.wx.mapper.IdCardMapper.searchIdCard"></association>
	</resultMap>
</mapper>

1.7 在java类中调用findPersonById方法

List<Map<String,Object>> list3 = session.selectList("com.wx.mapper.PersonMapper.findPersonById", 1);
System.out.println(list3);

1.8 输出结果

[Person [id=1, name=aq, age=23, sex=man, card_id=1, idCard=IdCard [id=1, code=2015132101]]]

嵌套查询方式要执行多条sql语句，如果数据量大的话，会导致性能低，不友好。

嵌套结果

将personMapper.xml文件进行修改

        <select id="findPersonById2" parameterType="Integer"                           
                resultMap="IdCardWithPersonResult2">
		select * from tb_person where id = #{id}
	</select>
	<resultMap type="person" id="IdCardWithPersonResult2">
		<id property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="age" column="age"/>
		<result property="sex" column="sex"/>
		<result property="card_id" column="card_id"/>
		<!-- 一对一 -->
		<association property="idCard" javaType="idCard" >
			<id property="id" column="id"/>
			<result property="code" column="code"/>
		</association>
	</resultMap>

然后调用该方法。