<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.example.demo.mapper.RoleMapper"><select id="selectRoleUsersPage" resultType="com.example.demo.po.Role">
SELECT
a.*,b.user_name
FROM role a
LEFT JOIN user b
ON a.user_id = b.id
<where><if test="par.userId != null">
a.user_id = #{par.userId}</if><if test="par.userName != null and par.userName!=''">
and b.user_name like '%${par.userName}%'</if></where>
ORDER BY a.create_time desc
</select></mapper>