From b72f8f8d58417eb6fb29672d8ac17cfafa46775c Mon Sep 17 00:00:00 2001
From: zhitong.yu <xynz17@163.com>
Date: 星期六, 11 五月 2024 10:51:31 +0800
Subject: [PATCH] 增加:主界面选择系统页面，统计实时刷新，低电量人员数据显示
---
src/main/java/com/hxzk/mapper/DaoHangDao.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/hxzk/mapper/DaoHangDao.java b/src/main/java/com/hxzk/mapper/DaoHangDao.java
index c71223d..6accfec 100644
--- a/src/main/java/com/hxzk/mapper/DaoHangDao.java
+++ b/src/main/java/com/hxzk/mapper/DaoHangDao.java
@@ -2,9 +2,33 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hxzk.pojo.TbDaohang;
+import com.hxzk.pojo.TbDaohangUser;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
+
+import java.util.List;
public interface DaoHangDao extends BaseMapper<TbDaohang> {
@Update("update tb_daohang set ishow = '0' where parents = #{parents}")
public void upDaoHangIshow(String parents);
+
+ @Select("select * from tb_daohang where parent > 0")
+ public List<TbDaohang> findTest1();
+
+ @Select("select * from tb_daohang where parents = #{parents}")
+ public List<TbDaohang> findTest2(String parents);
+
+
+ @Select("select * from tb_daohang_user where parents = #{parents} and username = #{username}")
+ public List<TbDaohangUser> findTest3(@Param("parents") String parents, @Param("username")String username);
+
+ @Select("select * from tb_daohang_user where username = #{username}")
+ public List<TbDaohang> find1(String username);
+
+ @Select("select * from tb_daohang_user where level = '1' and ishow = '1' and username = #{username}")
+ public List<TbDaohang> find2(String username);
+
+ @Select("select * from tb_daohang_user where parents = #{parents} and ishow = '1' and username = #{username}")
+ public List<TbDaohang> find3(@Param("parents")String parents,@Param("username")String username);
}
--
Gitblit v1.9.3