mybatis经常会使用到的细节

1、resultMap用法

<resultMap id="userVoResultMap" type="com.betawoo.admin.commons.result.UserVo"><id column="user_id" property="userId" jdbcType="VARCHAR"/><result column="user_account" property="userAccount" jdbcType="VARCHAR"/><result column="user_name" property="userName" jdbcType="VARCHAR"/><result column="user_type" property="userType" jdbcType="VARCHAR"/><result column="status" property="status" jdbcType="TINYINT"/><result column="org_id" property="orgId" jdbcType="INTEGER"/><result column="create_date" property="createDate" jdbcType="TIMESTAMP"/><result column="mobile_no" property="mobileNo" jdbcType="VARCHAR"/><result column="organizationName" property="orgName" jdbcType="VARCHAR"/><collection property="rolesList" ofType="Role"><id column="roleId" property="id"/><result column="roleName" property="name"/></collection></resultMap><select id="findUserVoById" resultMap="userVoResultMap" parameterType="java.lang.String">SELECTt.user_id,t.user_account,t.user_name,t.user_type,t.`status`,t.org_id,t.create_date,t.mobile_no,s.`name` AS organizationName,o.id AS roleId,o.`name` AS roleNameFROMum_user_info tLEFT JOINum_user_role r ON t.user_id = r.user_idLEFT JOINum_role o ON r.role_id = o.idLEFT JOINum_organization s ON s.id = t.org_id<where>t.user_id = #{id}</where></select>

2、mybatis大于、小于处理（更多详见此处说明）

用 转义字符>和<