ID_,NAME_,CODE_,ROLE_TYPE_,ENABLED_,DESCRIPTION_,UPDATE_TIME_,IS_DELE_,VERSION_,CREATE_BY_,UPDATE_BY_,CREATE_ORG_ID_
SELECT
DELETE FROM uc_role WHERE IS_DELE_='1'
SELECT r.ID_,r.NAME_,r.CODE_,r.ROLE_TYPE_ from uc_user_role ur INNER JOIN uc_user u on ur.USER_ID_=u.ID_
INNER JOIN uc_role r on ur.ROLE_ID_=r.ID_ and ur.USER_ID_= #{userId} WHERE r.IS_DELE_!='1' AND ur.IS_DELE_!='1'
SELECT DISTINCT r.* ,u.* FROM uc_role r INNER JOIN uc_user_role ur
ON r.ID_ = ur.ROLE_ID_ INNER JOIN uc_user u ON u.ID_ = ur.USER_ID_ WHERE u.ACCOUNT_ = #{account}
AND r.IS_DELE_!='1' AND u.IS_DELE_!='1' AND ur.IS_DELE_!='1'
select r.* from uc_role r INNER JOIN uc_org_role o ON r.ID_ = o.ROLE_ID_
where r.IS_DELE_!='1' AND o.IS_DELE_!='1'
and o.ORG_ID_ = #{orgId}
and o.CODE_ = #{orgCode}
and r.CODE_ = #{roleCode}
and r.ID_ = #{roleId}
and o.IS_INHERIT_ = #{isInherit}
SELECT
SELECT count(1) FROM uc_role
WHERE CODE_ = #{code}