mybaties配置多个resultMap,实现返回不同的实体

最新推荐文章于 2023-06-26 15:48:50 发布

转载最新推荐文章于 2023-06-26 15:48:50 发布 · 1.9k 阅读

4 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/feiZhou/p/9344092.html

文章标签：

#java #数据库

本文通过具体的 MyBatis resultMap 配置示例，详细解释了如何映射数据库字段到实体类属性的过程。包括基本属性映射及扩展属性映射，并展示了根据不同方法返回不同实体类型的具体实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<resultMap id="userInfo" type="userInfo">
        <result property="userID" column="UserID" />
        <result property="loginID" column="LoginID" />
        <result property="password" column="Password" />
        <result property="isDelete" column="IsDelete" />
        <result property="isLock" column="IsLock" />
        <result property="pwdUpdateDate" column="PwdUpdateDate" />
        <result property="pwdExpiryDate" column="PwdExpiryDate" />
        <result property="pwdErrorTimes" column="PwdErrorTimes" />
        <result property="remark" column="Remark" />
        <result property="employeeID" column="EmployeeID" />
        <result property="createDate" column="CreateDate" />
        <result property="createBy" column="CreateBy" />
        <result property="modifyDate" column="ModifyDate" />
        <result property="modifyBy" column="ModifyBy" />
    </resultMap>


        <resultMap id="userInfoEtd" type="UserInfoEtd">
        <result property="userID" column="UserID" />
        <result property="loginID" column="LoginID" />
        <result property="password" column="Password" />
        <result property="isDelete" column="IsDelete" />
        <result property="isLock" column="IsLock" />
        <result property="pwdUpdateDate" column="PwdUpdateDate" />
        <result property="pwdExpiryDate" column="PwdExpiryDate" />
        <result property="pwdErrorTimes" column="PwdErrorTimes" />
        <result property="remark" column="Remark" />
        <result property="employeeID" column="EmployeeID" />
        <result property="createDate" column="CreateDate" />
        <result property="createBy" column="CreateBy" />
        <result property="modifyDate" column="ModifyDate" />
        <result property="modifyBy" column="ModifyBy" />
        <!--  下面是扩展的属性，对应type已经改为扩展类-->
        <result property="positionName" column="positionName" />
    </resultMap>

不同的方法返回不同的实体


      --返回实体为userInfo
    <select id="getByIds" resultMap="userInfo" parameterType="ArrayList">
        select 
        ....对应resultMap="userInfo"映射的字段
        from  UserInfo

    </select>


      --返回实体为userInfoEtd
    <select id="getUsersByDepartmentID" parameterType="String" resultMap="userInfoEtd">
    SELECT
        EmployeeInfo.UserID,
        DataDictionaryDetail.Value AS PositionName
        FROM
        多表联合
    </select>