映射
<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”)