映射

<mapper namespace="cn.xiniu.core.dao.basicUser.UserInfoDao">
    <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>

接口

public List<UserInfo> find2(UserInfoQuery userInfoQuery);
<select id="find2" parameterType="UserInfoQuery" resultMap="userInfo">

1parameterType=”UserInfoQuery”:
表示接口方法find2传入的参数是UserInfoQuery对象,该对象所属的类是任意的,和UserInfo类没有关联。

2 resultMap=”userInfo”:
select 查询后的字段按resultMap的配置,封装为一个对象(type=”UserInfo”)

posted on 2017-09-20 14:50  2637282556  阅读(168)  评论(0编辑  收藏  举报