Mybatis中的一对一

小咪咪 2023-02-21 12:25 5阅读 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标签，要不然程序会报错