From 28e7d24ad81f9afe1037b72d8cfc3c27ba948f28 Mon Sep 17 00:00:00 2001
From: whyczh <hzjl@qq.com>
Date: 星期四, 15 四月 2021 17:02:30 +0800
Subject: [PATCH] 多表查询
---
src/main/java/com/example/lxw/mapper/User_InfMapper.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/example/lxw/mapper/User_InfMapper.java b/src/main/java/com/example/lxw/mapper/User_InfMapper.java
index a7b4695..f3806d6 100644
--- a/src/main/java/com/example/lxw/mapper/User_InfMapper.java
+++ b/src/main/java/com/example/lxw/mapper/User_InfMapper.java
@@ -2,11 +2,14 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.lxw.pojo.User_inf;
+import com.example.lxw.pojo.vo.UserInfo;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;
import java.util.List;
+import java.util.Map;
/**
* @author lxw
@@ -19,4 +22,15 @@
* @return
*/
public List<User_inf> searchByBaojiUsr();
+
+ /**
+ * 杩斿洖鎵�鏈夌殑鐢ㄦ埛
+ * @return
+ */
+
+ public List<UserInfo> searchByBaojiUsr2();
+
+ @Select("SELECT tb_user_inf.*,tb_user_battgroup_baojigroup_usr.baoji_group_id from tb_user_inf LEFT JOIN tb_user_battgroup_baojigroup_usr ON tb_user_inf.uId=tb_user_battgroup_baojigroup_usr.uId order by tb_user_inf.uid")
+ public List<Map<String,Object>> searchByBaojiUsr3();
+
}
--
Gitblit v1.9.1