<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},'%')
网友评论