fun getUsers(): List<Users> {
val db = this.writableDatabase
val list = ArrayList<Users>()
val cusrsor: Cursor
cusrsor = db.rawQuery("SELECT * FROM USER", null)
if (cusrsor != null) {
if (cusrsor.count > 0) {
cusrsor.moveToFirst()
do {
val userID = cusrsor.getInt(cusrsor.getColumnIndex("userID"))
val userName = cusrsor.getString(cusrsor.getColumnIndex("userName"))
val userAge = cusrsor.getInt(cusrsor.getColumnIndex("userAge"))
val user = Users(userID, userName, userAge)
list.add(user)
} while (cusrsor.moveToNext())
}
}
return list
}
@Dedy Kurniawan Please try like this. Replace rawquery, object and dto with yours.