MyBatis一对一关系的实现配置释义

最新推荐文章于 2021-02-20 10:20:00 发布

chpllp

最新推荐文章于 2021-02-20 10:20:00 发布

阅读量197

点赞数

分类专栏： MyBatis

本文链接：https://blog.csdn.net/chpllp/article/details/81453236

版权

MyBatis 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

具体工程代码参考：https://download.csdn.net/download/chpllp/10586096

<?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.java1234.mappers.StudentMapper">
	<!--  对象级联
	<resultMap type="Student" id="StudentResult">
		<id property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="age" column="age"/>
		
		<result property="address.id" column="addressId"/>  //此处column使用外键
		<result property="address.sheng" column="sheng"/>
		<result property="address.shi" column="shi"/>
		<result property="address.qu" column="qu"/>
	</resultMap>
	-->
	
	<!--
	<resultMap type="Address" id="AddressResult">
		<result property="id" column="id"/>
		<result property="sheng" column="sheng"/>
		<result property="shi" column="shi"/>
		<result property="qu" column="qu"/>
	</resultMap>
	<resultMap type="Student" id="StudentResult">
		<id property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="age" column="age"/>
		<association property="address" resultMap="AddressResult"/>
	</resultMap>
	-->
	
	<!--
	<resultMap type="Student" id="StudentResult">
		<id property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="age" column="age"/>
		<association property="address" javaType="Address">
			<result property="id" column="id"/>
			<result property="sheng" column="sheng"/>
			<result property="shi" column="shi"/>
			<result property="qu" column="qu"/>
		</association>
	</resultMap>
	-->
	<!-- 上述三种配置为对象级联，不需要创建AddressMapper.java和AddressMapper.xml两个文件-->
	<!-- 开发中推荐使用下面的配置 -->
	<resultMap type="Student" id="StudentResult">
		<id property="id" column="id"/>
		<result property="name" column="name"/>
		<result property="age" column="age"/>
		<!-- 下面的column="addressId"是t_address表的外键 -->
		<association property="address" column="addressId" select="com.java1234.mappers.AddressMapper.findById"/>
	</resultMap>         
	
	<select id="findStudentWithAddress" parameterType="Integer" resultMap="StudentResult">
		select * from t_student t1,t_address t2 where t1.addressId=t2.id and t1.id=#{id}
	</select>
	
	<insert id="add" parameterType="Student"  >
		insert into t_student values(null,#{name},#{age})
	</insert>

	<update id="update" parameterType="Student">
		update t_student set name=#{name},age=#{age} where id=#{id}
	</update>
	
	<delete id="delete" parameterType="Integer">
		delete from t_student where id=#{id}
	</delete> 
	
	<select id="findById" parameterType="Integer" resultType="Student">
		select * from t_student where id=#{id}
	</select>
	
	<select id="find" resultMap="StudentResult">
		select * from t_student
	</select>
	
</mapper>