resultMap

返回Map類型

屬性
可以是固有屬性、也可以定義擴展屬性

關聯
可以是其他表的字段，也可以關聯其他select查詢語句

<resultMap id="BaseResultMap" type="cn.com.hwasunsoft.lims.biz.model.extra.AssayOrderExt"><id column="ID" jdbcType="VARCHAR" property="id"/><result column="REG_NO" jdbcType="VARCHAR" property="regNo"/><result column="REG_WAY" jdbcType="VARCHAR" property="regWay"/><result column="REG_PEOPLE" jdbcType="VARCHAR" property="regPeople"/><result column="REG_TIME" jdbcType="TIMESTAMP" property="regTime"/><result column="REG_TEL" jdbcType="VARCHAR" property="regTel"/><result column="CUSTOMER_ID" jdbcType="VARCHAR" property="customerId"/><result column="SAMP_BIZ_MODE_ID" jdbcType="VARCHAR" property="sampBizModeId"/><result column="TEST_OBJECT_MODEL_ID" jdbcType="VARCHAR" property="testObjectModelId"/><result column="TEST_OBJECT_ID" jdbcType="VARCHAR" property="testObjectId"/><result column="LAB_ID" jdbcType="VARCHAR" property="labId"/><result column="ASSAY_TIME_LIMIT" jdbcType="NUMERIC" property="assayTimeLimit"/><result column="SAMPLE_SUBMIT_WAY" jdbcType="NUMERIC" property="sampleSubmitWay"/><result column="CONFIRMATION_STATUS" jdbcType="NUMERIC" property="confirmationStatus"/><result column="SAMPLING_WAY" jdbcType="NUMERIC" property="samplingWay"/><result column="NEED_SAMPLE_PREPARATION" jdbcType="NUMERIC" property="needSamplePreparation"/><result column="SAMP_REG_AMOUNT" jdbcType="NUMERIC" property="sampRegAmount"/><result column="TESTED_UNIT_ID" jdbcType="VARCHAR" property="testedUnitId"/><result column="SAMP_STAT" jdbcType="VARCHAR" property="sampStat"/><result column="ORDER_NAME" jdbcType="VARCHAR" property="orderName"/><result column="ORDER_REMARK" jdbcType="VARCHAR" property="orderRemark"/><result column="ORDER_NO" jdbcType="VARCHAR" property="orderNo"/><result column="DAILY_PLAN_NO" jdbcType="VARCHAR" property="dailyPlanNo"/><result column="CONTRACT_INFO_ID" jdbcType="VARCHAR" property="contractInfoId"/><result column="CONTRACT_CODE" jdbcType="VARCHAR" property="contractCode"/><result column="ORDER_DATE" jdbcType="TIMESTAMP" property="orderDate"/><result column="CUST_PHONE" jdbcType="VARCHAR" property="custPhone"/><result column="SAMPLE_DELIVERER_NAME" jdbcType="VARCHAR" property="sampleDelivererName"/><result column="SAMPLE_DELIVERER_PHONE" jdbcType="VARCHAR" property="sampleDelivererPhone"/><result column="ORDER_TYPE" jdbcType="NUMERIC" property="orderType"/><result column="SETTLEMENT_WAY" jdbcType="NUMERIC" property="settlementWay"/><result column="ASSAY_BIZ_CODE" jdbcType="VARCHAR" property="assayBizCode"/><result column="AUDIT_STATUS" jdbcType="NUMERIC" property="auditStatus"/><result column="SETTLE_STATUS" jdbcType="NUMERIC" property="settleStatus"/><result column="ASSAY_COST_COUNT" jdbcType="NUMERIC" property="assayCostCount"/><result column="ATTACHMENT" jdbcType="VARCHAR" property="attachment"/><result column="RECORD_STATUS" jdbcType="NUMERIC" property="recordStatus"/><result column="CREATE_TIME" jdbcType="TIMESTAMP" property="createTime"/><result column="MODIFY_TIME" jdbcType="TIMESTAMP" property="modifyTime"/><result column="CONSOLIDATED_REPORT" jdbcType="NUMERIC" property="consolidatedReport"/><!-- ######################################### 擴展屬性 ###################################################--><!--采樣方式--><result column="SAMPLE_SUBMIT_WAY" jdbcType="NUMERIC" property="sampleSubmitWayEnum"typeHandler="cn.com.hwasunsoft.lims.core.enums.handler.CommonEnumHandler"/><!--記錄狀態--><result column="RECORD_STATUS" jdbcType="NUMERIC" property="recordStatusEnum"typeHandler="cn.com.hwasunsoft.lims.core.enums.handler.CommonEnumHandler"/><!--確認狀態--><result column="CONFIRMATION_STATUS" jdbcType="NUMERIC" property="confirmationStatusEnum"typeHandler="cn.com.hwasunsoft.lims.core.enums.handler.CommonEnumHandler"/><!--結算方式--><result column="SETTLEMENT_WAY" jdbcType="NUMERIC" property="settlementWayEnum"javaType="cn.com.hwasunsoft.lims.biz.enums.AccountingWayEnum"typeHandler="cn.com.hwasunsoft.lims.core.enums.handler.CommonEnumHandler"/><!--審核狀態--><result column="AUDIT_STATUS" jdbcType="NUMERIC" property="auditStatusEnum"typeHandler="cn.com.hwasunsoft.lims.core.enums.handler.CommonEnumHandler"/><!--結算狀態--><result column="SETTLE_STATUS" jdbcType="NUMERIC" property="settleStatusEnum"typeHandler="cn.com.hwasunsoft.lims.core.enums.handler.CommonEnumHandler"/><!--綜合報告顯示(1是,0否)--><result column="CONSOLIDATED_REPORT" jdbcType="NUMERIC" property="consolidatedReportEnum"typeHandler="cn.com.hwasunsoft.lims.core.enums.handler.CommonEnumHandler"/><association column="CUSTOMER_ID" jdbcType="VARCHAR" property="customer" select="getCustomer"/><association column="TEST_OBJECT_ID" jdbcType="VARCHAR" property="testObject" select="getTestObject"/><association column="CONTRACT_INFO_ID" jdbcType="VARCHAR" property="contractInfo" select="getContractInfo"/><association column="LAB_ID" jdbcType="VARCHAR" property="lab" select="getLab"/><association column="ASSAY_TASK_INFO_ID" jdbcType="VARCHAR" property="assayTaskInfo"javaType="cn.com.hwasunsoft.lims.biz.model.AssayTaskInfo"><result column="ASSAY_TASK_INFO_ID" jdbcType="VARCHAR" property="id"/><result column="sample_No" jdbcType="VARCHAR" property="sampleNo"/><result column="ASSAY_RESULT_AUDITOR" jdbcType="VARCHAR" property="assayResultAuditor"/></association><association column="sample_id" jdbcType="VARCHAR" property="assayOrderSample"javaType="cn.com.hwasunsoft.lims.biz.model.AssayOrderSample"><result column="sample_id" jdbcType="VARCHAR" property="id"/><result column="sample_No" jdbcType="VARCHAR" property="sampleNo"/><result column="LAB_ID" jdbcType="VARCHAR" property="labId"/><result column="SAMP_BIZ_MODE_ID" jdbcType="VARCHAR" property="sampBizModeId"/><result column="TEST_OBJECT_ID" jdbcType="VARCHAR" property="testObjectId"/></association><association column="SAMP_BIZ_MODE_ID" jdbcType="VARCHAR" property="sampleBusinessModel"javaType="cn.com.hwasunsoft.lims.biz.model.SampleBusinessModel"><result column="SAMP_BIZ_MODE_ID" jdbcType="VARCHAR" property="id"/><result column="SAMP_BIZ_MODE_NAME" jdbcType="VARCHAR" property="sampBizModeName"/></association> </resultMap><select id="getCustomer" parameterType="java.lang.String"resultType="cn.com.hwasunsoft.lims.biz.model.Customer">select * from INS_CUSTOMER where ID=#{id} </select> <select id="getTestObject" parameterType="java.lang.String"resultType="cn.com.hwasunsoft.lims.biz.model.TestObject">select * from DIC_TEST_OBJECT where ID=#{id} </select>

總結

以上是生活随笔為你收集整理的Mybatis的resultMap的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。