假设 SQL 为：

sql
SELECT * FROM nfc WHERE site_id IN (1,2);

错误用法：

kotlin
@Query("SELECT * FROM nfc WHERE site_id IN (:siteIDs)")
fun getAllBySites(
    siteIDs: String = "1,2"
): List<Nfc>

正确用法：

kotlin
@Query("SELECT * FROM nfc WHERE site_id IN (:siteIDs)")
fun getAllBySites(
    siteIDs: List<String> = listOf(1,2)
): List<Nfc>

或

kotlin
@Query("SELECT * FROM nfc WHERE site_id IN (:siteIDs)")
fun getAllBySites(
    siteIDs: Array<String> = arrayOf(1,2)
): List<Nfc>
#Android #Room #sql #sqlite
分享