@Query("INSERT INTO TestTable VALUES(null,:a,:b)")
List<TestTable> getall(String a, String b, String columna, String columnb);
Android Studio没有抱怨,但是你会得到一个编译器错误:
error: INSERT query type is not supported yet. You can use:SELECT, DELETE, UPDATE
RoomDatabase
上调用 getOpenHelper().getWritableDatabase()
。SupportSQLiteDatabase object
,这本质上是非 Room 的方式。execSQL()
或使用 insert()
。@Entity
data class ModulesRoom(
@PrimaryKey(autoGenerate = false)
var id: Int = 0,
var nav: String = "",
var name: String = "",
var imageurl: String = ""
)
for List Object
@Insert(onConflict = OnConflictStrategy.REPLACE)
fun saveEmployees(modules: List<ModulesRoom>)
for single obbjet
@Insert(onConflict = OnConflictStrategy.REPLACE)
fun saveEmployees(modules: ModulesRoom)
Ussage
val mModules = Modules()
mModules.id = values
mModules.nav = values
saveEmployees(mModules)