From 872026f91c8312c9dcb3c5f827ecdef2743602f9 Mon Sep 17 00:00:00 2001 From: feige <791364011@qq.com> Date: 星期一, 03 三月 2025 23:18:06 +0800 Subject: [PATCH] 修改了格式 --- zhang-content/src/main/java/com/ruoyi/mapper/ZfAncestorMapper.java | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/zhang-content/src/main/java/com/ruoyi/mapper/ZfAncestorMapper.java b/zhang-content/src/main/java/com/ruoyi/mapper/ZfAncestorMapper.java index 5ea78e6..8d296ff 100644 --- a/zhang-content/src/main/java/com/ruoyi/mapper/ZfAncestorMapper.java +++ b/zhang-content/src/main/java/com/ruoyi/mapper/ZfAncestorMapper.java @@ -14,10 +14,16 @@ import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; +import java.util.List; + @Mapper public interface ZfAncestorMapper extends BaseMapper<ZfAncestor> { - @Select("select * , zf_role.name as roleName from zf_ancestor, zf_clan,zf_role where zf_ancestor.clan_id = zf_clan.clan_id and zf_ancestor.role_id = zf_role.id ${ew.customSqlSegment}") + @Select("select * , zf_role.name as roleName from zf_ancestor inner join zf_clan on zf_ancestor.clan_id = zf_clan.clan_id inner join zf_role on zf_ancestor.role_id = zf_role.id ${ew.customSqlSegment}") Page<AncestorClan> selectInfo(Page page, @Param(Constants.WRAPPER) Wrapper<Object> queryWrapper); + + @Select("select * , zf_role.name as roleName from zf_ancestor inner join zf_clan on zf_ancestor.clan_id = zf_clan.clan_id inner join zf_role on zf_ancestor.role_id = zf_role.id ${ew.customSqlSegment}") + List<AncestorClan> selectAllInfo( @Param(Constants.WRAPPER) Wrapper<Object> queryWrapper); + } -- Gitblit v1.9.1