From 5b602b536c5be89b2cbfd211025236fb41ba2fa3 Mon Sep 17 00:00:00 2001
From: zuoxiao <470321431@qq.com>
Date: 星期一, 18 十二月 2023 17:46:00 +0800
Subject: [PATCH] 充值记录分页加载 补卡用户列表分页加载 通信模块添加日志方便分析长时间链接后不能通讯问题
---
app/src/main/java/com/dayu/recharge/dao/UserCardDao.java | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/app/src/main/java/com/dayu/recharge/dao/UserCardDao.java b/app/src/main/java/com/dayu/recharge/dao/UserCardDao.java
index 5e14cd2..4e1dc5f 100644
--- a/app/src/main/java/com/dayu/recharge/dao/UserCardDao.java
+++ b/app/src/main/java/com/dayu/recharge/dao/UserCardDao.java
@@ -28,9 +28,16 @@
@Delete
void delete(UserCardBean passWord);
- @Query("select * from UserCardBean ")
+ @Query("select * from UserCardBean order by date desc")
List<UserCardBean> findAll();
@Query("select * from UserCardBean where date>=:beginTime and date<=:endTime")
List<UserCardBean> findByTime(long beginTime, long endTime);
+ @Query("select * from UserCardBean where userName like :data or userID like :data or phone like :data")
+ List<UserCardBean> findByData(String data);
+
+ @Query("select * from UserCardBean order by date desc LIMIT :limit OFFSET :offset")
+ List<UserCardBean> findAll(int offset,int limit);
+ @Query("select COUNT(*) from UserCardBean")
+ int getUserTotale();
}
--
Gitblit v1.8.0