MyBatis 基本类型映射List 高级映射构造方法映射

最新推荐文章于 2023-04-12 21:29:00 发布

小吴小吴bug全无

最新推荐文章于 2023-04-12 21:29:00 发布

阅读量744

点赞数

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

本文链接：https://blog.csdn.net/qq_22903677/article/details/103183381

版权

SpringBoot 同时被 3 个专栏收录

16 篇文章 1 订阅

订阅专栏

java

16 篇文章 0 订阅

订阅专栏

mybatis

1 篇文章 0 订阅

订阅专栏

MyBatis 基本类型映射List 高级映射构造方法映射

高级映射内部类

<resultMap id="questionBankQuestionOptionsMap" type="com.xx.vo.QuestionBankQuestionOptionsVO">
    <id column="question_bank_question_id" property="questionBankQuestionId"></id>
    <result column="question_bank_question_subject" property="questionBankQuestionSubject"></result>
    <result column="question_bank_question_classification" property="questionBankQuestionClassification"></result>
    <result column="question_bank_question_analysis" property="questionBankQuestionAnalysis"></result>
    <collection property="questionBankQuestionOptions" ofType="com.xx.entity.examination.QuestionBankQuestionOptions">
        <id column="question_bank_question_options_id" property="questionBankQuestionOptionsId"></id>
        <result column="question_bank_question_options_content" property="questionBankQuestionOptionsContent"></result>
        <result column="question_bank_question_options_right" property="questionBankQuestionOptionsRight"></result>
    </collection>
</resultMap>

构造方法映射

<resultMap id="ExaminationCountVOMap" type="com.xx.vo.ExaminationCountVO">
    <constructor>
        <idArg column="examinationId"  javaType="Integer"/>
        <arg column="examinationStartTime" javaType="java.time.LocalDateTime"/>
        <arg column="examinationEndTime" javaType="java.time.LocalDateTime"/>
        <arg column="examinationName" javaType="String"/>
        <arg column="paperNum"  javaType="Integer"/>
        <arg column="allNum"  javaType="Integer"/>
        <arg column="partInNum"  javaType="Integer"/>
        <arg column="passNum"   javaType="Integer"/>
    </constructor>
</resultMap>

list 内部映射对象

<resultMap id="questionBankQuestionOptionsBOMap" type="com.xx.bo.QuestionBankQuestionOptionsBO">
<id column="question_bank_id" property="questionBankId"></id>
<!-- 内部类的映射--->
<collection property="questionClassificationQuestions"ofType="com.xx.bo.QsBO$QuestionClassificationQuestion">
    <id column="question_bank_question_classification" property="questionClassificationQuestion"></id>
     <association property="masterLibraryUser" javaType="com.xx.entity.MasterLibraryUser">
            <result column="user_id" property="userId"/>
            <result column="name" property="name"/>
            <result column="username" property="username"/>
            <result column="sex" property="sex"/>
            <result column="id_card" property="idCard"/>
            <result column="email" property="email"/>
        </association>
</collection>
</resultMap>

基本类型映射

<resultMap type="Answer" id="answer">
    <id property="id" column=""/>
    <result property="answer" column=""/>
    <collection property="oid" ofType="int">
        <constructor>
            <arg column=""/>
        </constructor>
    </collection>
    <collection property="name" ofType="string">
        <constructor>
            <arg column=""/>
        </constructor>
    </collection>
</resultMap>