<sql id="roleClos">
id,role_name as roleName,note
<sql>
select ??<include refid="roleClos"></include>
?from role ?where role_name like concat('%', #{rn},'%')
and note like concat('%', #{note},'%')
<sql id="roleAlias">
${ali}.id,${ali}.role_name ,${ali}.note
</sql>
select ??
<inlcule refid="roleAlias">
<properte name="ali" ?value="r">
</include>
from role ?r
?where role_name like concat('%', #{rn},'%')
and note like concat('%', #{note},'%')
