一对一配置
<resultMap id="BaseResultMap" type="com.sgai.cps.cm.entity.CmSurveyR2Topic" >
<!-- SEQUENCE --><id column="SID" property="sid" jdbcType="DECIMAL" />
<!-- 调查问卷SID -->
<result column="SURVEY_SID" property="surveySid" jdbcType="DECIMAL" />
<!-- 题目SID -->
<result column="TOPIC_SID" property="topicSid" jdbcType="DECIMAL" />
<!-- 计分方式 1-最高分 2-最低分 3-求和 -->
<result column="CAL_STYLE" property="calStyle" jdbcType="VARCHAR" />
<!-- 题目分值 -->
<result column="TOPIC_SCORE" property="topicScore" jdbcType="DECIMAL" />
<!-- 创建人 -->
<result column="CREATED_BY" property="createdBy" jdbcType="VARCHAR" />
<!-- 创建时间 -->
<result column="CREATED_DT" property="createdDt" jdbcType="TIMESTAMP" />
<!-- 更新人 -->
<result column="UPDATED_BY" property="updatedBy" jdbcType="VARCHAR" />
<!-- 更新时间 -->
<result column="UPDATED_DT" property="updatedDt" jdbcType="TIMESTAMP" />
<!-- 乐观锁版本号 -->
<result column="VERSION" property="version" jdbcType="DECIMAL" />
<association property="cmSurveyTopic" column="cmSurveyTopic" javaType="com.sgai.cps.cm.entity.CmSurveyTopic">
<id property="sid" column="cid" />
<result property="topicCat" column="TOPIC_CAT"/>
<result property="topicTitle" column="TOPIC_TITLE"/>
<result property="topicType" column="TOPIC_TYPE"/>
<result property="topicState" column="TOPIC_STATE"/>
<result property="rightAnwser" column="RIGHT_ANWSER"/>
<result property="remark" column="REMARK"/>
</association>
</resultMap>
说明:
property | 对象属性的名称 |
javaType | 对象属性的类型 |
column | 所对应的外键字段名称 |