From 092bf21368ea824e9dc22467166960219165dc00 Mon Sep 17 00:00:00 2001
From: zuoxiao <470321431@qq.com>
Date: 星期五, 21 二月 2025 17:32:59 +0800
Subject: [PATCH] 1.我的界面每个item添加点击效果。 2.更新本地数据添加二次确认。
---
app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java | 17 ++++++++++++++++-
1 files changed, 16 insertions(+), 1 deletions(-)
diff --git a/app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java b/app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java
index aad77d8..464f24b 100644
--- a/app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java
+++ b/app/src/main/java/com/dayu/pipirrapp/dao/DivideDao.java
@@ -9,14 +9,16 @@
import com.dayu.pipirrapp.bean.db.DivideBean;
import com.dayu.pipirrapp.bean.db.MarkerBean;
+import com.dayu.pipirrapp.bean.db.SearchResultBean;
import java.util.List;
import io.reactivex.rxjava3.core.Completable;
import io.reactivex.rxjava3.core.Single;
+import io.reactivex.rxjava3.core.Maybe;
/**
- * DivideDao -
+ * DivideDao -鍒嗘按鎴�
*
* @author zuoxiao
* @version 1.0
@@ -50,4 +52,17 @@
@Query("select * from DivideBean")
Single<List<DivideBean>> findAllToSingle();
+
+ @Query("SELECT * FROM DivideBean")
+ Maybe<List<DivideBean>> getAll(); // 鏀逛负杩斿洖Maybe<List<DivideBean>>
+
+ @Query("SELECT * FROM DivideBean WHERE divideName LIKE '%' || :name || '%'")
+ Single<List<DivideBean>> findByDivideNameLike(String name);
+
+ @Query("SELECT divideName as name, 'divide' as type, lat, lng, address, divideId as id FROM DivideBean " +
+ "WHERE divideName LIKE '%' || :keyword || '%' " +
+ "UNION " +
+ "SELECT name, 'marker' as type, lat, lng, address, id FROM MarkerBean " +
+ "WHERE name LIKE '%' || :keyword || '%'")
+ Single<List<SearchResultBean>> searchAllByKeyword(String keyword);
}
--
Gitblit v1.8.0