From 768f1d38c5357e214e6cff018e57ef7bcb64ee60 Mon Sep 17 00:00:00 2001
From: tj <1378534974@qq.com>
Date: 星期四, 27 二月 2025 13:53:23 +0800
Subject: [PATCH] 1
---
app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt b/app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt
index 8df5a2b..64e658e 100644
--- a/app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt
+++ b/app/src/main/java/com/example/firstapp/database/dao/CodeDao.kt
@@ -41,4 +41,11 @@
@Query("SELECT * FROM Code order by time desc")
abstract fun getAllCodesDesc(): List<Code>
+
+ @Query("""
+ SELECT * FROM Code
+ WHERE type LIKE '%' || :keyword || '%'
+ ORDER BY time DESC
+ """)
+ fun getByKeyword(keyword: String): List<Code>
}
--
Gitblit v1.9.3