Mybatis中的一对一

最新推荐文章于 2021-11-19 19:43:14 发布

小小平不平凡

最新推荐文章于 2021-11-19 19:43:14 发布

阅读量230

点赞数 1

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/sinat_34241861/article/details/107045278

版权

mybatis 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

实际场景

Action类中有一个属性是ActionAuxiliaryDate类型，两者为一对一关系

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.taobao.rigel.rap.mapper.ActionMapper">
	<resultMap id="ActionMap" type="com.taobao.rigel.rap.model.Action">
		<id column="id" property="id"/>
		<result column="name" property="name"/>
		<result column="description" property="description"/>
		<result column="request_type" property="requestType"/>
		<result column="request_url" property="requestUrl"/>
		<result column="disable_cache" property="disableCache"/>
		<result column="response_template" property="responseTemplate"/>
		<result column="protocol_no" property="protocolNo"/>
		<result column="submit" property="submit"/>
		<result column="owner" property="owner"/>
		<result column="version" property="version"/>
		<result column="request_bean" property="requestBean"/>
		<result column="response_bean" property="responseBean"/>
		<result column="request_interface" property="requestInterface"/>
		<result column="request_method" property="requestMethod"/>
		<result column="group_id" property="groupId"/>
		<result column="artifact_id" property="artifactId"/>
		<result column="interface_type" property="interfaceType"/>
		<result column="paramsMap" property="paramsMap"/>
		<result column="pbfile" property="pbFile"/>
		<result column="serviceid" property="serviceid"/>
		<association property="dateTime" javaType="com.taobao.rigel.rap.model.ActionAuxiliaryDate">
			<result property="id" column="id"/>
			<result property="actionId" column="action_id"/>
			<result property="createDate" column="create_date"/>
			<result property="updateDate" column="update_date"/>
		</association>
	</resultMap>
	<select id="findByPrimaryKey" resultMap="ActionMap">
		select * from tb_action a, tb_action_auxiliary_date d where a.id=#{id} and a.id = d.action_id
	</select>
</mapper>

注意：association标签中关联类的id属性不可以采用id标签，要不然程序会报错