| | |
| | | |
| | | private Timestamp updateTime; |
| | | |
| | | private String authName; |
| | | |
| | | |
| | | public MenuAuthEntity() { |
| | | } |
| | | |
| | |
| | | public void setUpdateTime(Timestamp updateTime) { |
| | | this.updateTime = updateTime; |
| | | } |
| | | public String getAuthName() { |
| | | return authName; |
| | | } |
| | | |
| | | public void setAuthName(String authName) { |
| | | this.authName = authName; |
| | | } |
| | | |
| | | } |
| | |
| | | |
| | | private Timestamp updateTime; |
| | | |
| | | private String resName; |
| | | |
| | | private String server; |
| | | |
| | | |
| | | |
| | | public RoleResEntity() { |
| | | } |
| | | |
| | |
| | | public void setUpdateTime(Timestamp updateTime) { |
| | | this.updateTime = updateTime; |
| | | } |
| | | |
| | | public String getResName() { |
| | | return resName; |
| | | } |
| | | |
| | | public void setResName(String resName) { |
| | | this.resName = resName; |
| | | } |
| | | public String getServer() { |
| | | return server; |
| | | } |
| | | |
| | | public void setServer(String server) { |
| | | this.server = server; |
| | | } |
| | | |
| | | } |
| | |
| | | </select> |
| | | |
| | | <select id="selectByPage" resultType="com.lf.server.entity.sys.MenuAuthEntity"> |
| | | select * from lf.sys_menu_auth |
| | | select a.*,b.name as authName from lf.sys_menu_auth a inner join lf.sys_auth b |
| | | on a.authid = b.id |
| | | <where> |
| | | <if test="menuid != null"> |
| | | menuid = #{menuid} |
| | | a.menuid = #{menuid} |
| | | </if> |
| | | </where> |
| | | order by id |
| | |
| | | </select> |
| | | |
| | | <select id="selectByPage" resultType="com.lf.server.entity.sys.RoleResEntity"> |
| | | select * from lf.sys_role_res |
| | | select a.*,b.name as resName from lf.sys_role_res a inner join lf.sys_res b |
| | | on a.resid = b.id |
| | | <where> |
| | | <if test="roleid != null"> |
| | | roleid = #{roleid} |
| | | a.roleid = #{roleid} |
| | | </if> |
| | | </where> |
| | | order by id |