mybatis经常会使用到的细节

╰半橙微兮° 2022-06-03 06:13 215阅读 0赞

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">
    	SELECT
    		t.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 roleName
    	FROM
    		um_user_info t
    		LEFT JOIN
    		um_user_role r ON t.user_id = r.user_id
    		LEFT JOIN
    		um_role o ON r.role_id = o.id
    		LEFT JOIN
    		um_organization s ON s.id = t.org_id
    	<where>
    		t.user_id = #{id}
    	</where>
    </select>

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

用 转义字符**>**和**<**

[Link 1]: http://blog.csdn.net/zheng0518/article/details/10449549