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

来源:互联网 发布:为什么电脑软件不见了 编辑:程序博客网 时间:2024/05/27 20:51
<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>
阅读全文
0 0
原创粉丝点击