1. \uc11c\ub860<\/h2>\n
\ud604\ub300\uc758 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c\uc5d0\uc11c \ub370\uc774\ud130 \uad00\ub9ac\ub294 \ud544\uc218\uc801\uc778 \uc694\uc18c\uc785\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\uc758 \uc815\ubcf4\ub098 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uc0c1\ud0dc\ub97c \uc800\uc7a5\ud558\uae30 \uc704\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uadf8 \uc911\uc694\uc131\uc774 \ub0a0\ub85c \uc99d\uac00\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc548\ub4dc\ub85c\uc774\ub4dc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c\ub3c4 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud65c\uc6a9\uc774 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. \uc774\ubc88 \uac15\uc88c\uc5d0\uc11c\ub294 \ucf54\ud2c0\ub9b0\uc744 \uc0ac\uc6a9\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ubc29\ubc95\uc744 \ub2e4\ub8e8\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<\/section>\n \uc548\ub4dc\ub85c\uc774\ub4dc\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc73c\uba70, \uadf8 \uc911 \uac00\uc7a5 \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \uac83\ub4e4\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n \uc774 \uac15\uc88c\uc5d0\uc11c\ub294 SQLite\uc640 Room\uc744 \uc911\uc2ec\uc73c\ub85c \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<\/section>\n SQLite\ub294 \ub85c\uceec\uc5d0 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \uac04\ub2e8\ud558\uace0 \ud6a8\uc728\uc801\uc778 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ucef4\ud3ec\ub10c\ud2b8 \uae30\ubc18\uc758 \uc548\ub4dc\ub85c\uc774\ub4dc \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \uc694\uccad\ud558\ub294 \ub370\uc774\ud130\uc5d0 \ub300\ud574 \ube60\ub974\uac8c \uc561\uc138\uc2a4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc8fc\uc694 \ub2e8\uacc4\ub97c \uac70\uccd0\uc57c \ud569\ub2c8\ub2e4.<\/p>\n SQLiteOpenHelper\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131 \ubc0f \ubc84\uc804 \uad00\ub9ac\ub97c \uc704\ud55c \ud074\ub798\uc2a4\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n \uc544\ub798\ub294 SQLiteOpenHelper\uc758 \uac04\ub2e8\ud55c \uad6c\ud604 \uc608\uc81c\uc785\ub2c8\ub2e4:<\/p>\n \uc774\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\uace0 \uc870\ud68c, \uc218\uc815 \ubc0f \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n Room\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uadfc\uc744 \uc704\ud55c \ubcf4\ub2e4 \uac04\ub2e8\ud558\uace0 \uc720\uc5f0\ud55c \ubc29\ubc95\uc744 \uc81c\uacf5\ud558\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac\uc785\ub2c8\ub2e4. \uac01\uc885 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub828 \ucf54\ub4dc\uc758 \uc591\uc744 \uc904\uc774\uace0, \ub354 \uc548\uc804\ud558\uac8c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ub3c4\uc640\uc90d\ub2c8\ub2e4. Room\uc740 \ub2e4\uc74c\uc758 \uc138 \uac00\uc9c0 \uc8fc\uc694 \uad6c\uc131 \uc694\uc18c\ub85c \uc774\ub8e8\uc5b4\uc838 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n Room\uc5d0\uc11c Entity\ub97c \uc815\uc758\ud558\ub294 \uac83\uc740 \ud14c\uc774\ube14\uc744 \uc124\uacc4\ud558\ub294 \uac83\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4. \uc544\ub798\ub294 \uac04\ub2e8\ud55c User Entity\uc758 \uc608\uc785\ub2c8\ub2e4:<\/p>\n DAO\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c CRUD(\uc0dd\uc131, \uc77d\uae30, \uc5c5\ub370\uc774\ud2b8, \uc0ad\uc81c) \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uba54\uc18c\ub4dc\ub97c \uc815\uc758\ud569\ub2c8\ub2e4:<\/p>\n RoomDatabase \ud074\ub798\uc2a4\ub97c \ud1b5\ud574 DAO\ub97c \uc778\uc2a4\ud134\uc2a4\ud654\ud558\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n Room \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc0bd\uc785, \uc870\ud68c, \uc218\uc815, \uc0ad\uc81c\ud558\ub294 \ubc29\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n \uc774\ubc88 \uac15\uc88c\uc5d0\uc11c\ub294 \ucf54\ud2c0\ub9b0\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc548\ub4dc\ub85c\uc774\ub4dc \uc571\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. SQLite\uc640 Room \uac01\uac01\uc758 \uc7a5\ub2e8\uc810\uc744 \uc774\ud574\ud558\uace0, \uad6c\uccb4\uc801\uc778 \uad6c\ud604 \uc608\uc81c\ub97c \ud1b5\ud574 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\uace0 \uad00\ub9ac\ud558\ub294 \ubc29\ubc95\uc744 \ubc30\uc6e0\uc2b5\ub2c8\ub2e4. \uc774\uc81c \uc5ec\ub7ec\ubd84\ub3c4 \uc774\ub7ec\ud55c \uae30\ubc95\uc744 \ud65c\uc6a9\ud558\uc5ec \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \uc571\uc758 \uae30\ub2a5\uc744 \uac15\ud654\ud560 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n<\/section>\n<\/article>\n <\/body><\/p>\n","protected":false},"excerpt":{"rendered":"2. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc885\ub958<\/h2>\n
\n
3. SQLite \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/h2>\n
3.1. SQLiteOpenHelper \ud074\ub798\uc2a4<\/h3>\n
\n
\n class MyDatabaseHelper(context: Context) : SQLiteOpenHelper(context, DATABASE_NAME, null, DATABASE_VERSION) {\n override fun onCreate(db: SQLiteDatabase) {\n val createTableSQL = \"CREATE TABLE ${TABLE_NAME} (\" +\n \"${COLUMN_ID} INTEGER PRIMARY KEY AUTOINCREMENT, \" +\n \"${COLUMN_NAME} TEXT)\"\n db.execSQL(createTableSQL)\n }\n \n override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) {\n db.execSQL(\"DROP TABLE IF EXISTS $TABLE_NAME\")\n onCreate(db)\n }\n }\n <\/code>\n <\/pre>\n3.2. \ub370\uc774\ud130 \uc0bd\uc785, \uc870\ud68c, \uc218\uc815, \uc0ad\uc81c<\/h3>\n
\ub370\uc774\ud130 \uc0bd\uc785<\/h4>\n
\n
\n fun insertData(name: String) {\n val db = this.writableDatabase\n val values = ContentValues().apply {\n put(COLUMN_NAME, name)\n }\n db.insert(TABLE_NAME, null, values)\n db.close()\n }\n <\/code>\n <\/pre>\n\ub370\uc774\ud130 \uc870\ud68c<\/h4>\n
\n
\n fun getData(): List\ub370\uc774\ud130 \uc218\uc815<\/h4>\n
\n
\n fun updateData(id: Int, newName: String) {\n val db = this.writableDatabase\n val values = ContentValues().apply {\n put(COLUMN_NAME, newName)\n }\n db.update(TABLE_NAME, values, \"$COLUMN_ID = ?\", arrayOf(id.toString()))\n db.close()\n }\n <\/code>\n <\/pre>\n\ub370\uc774\ud130 \uc0ad\uc81c<\/h4>\n
\n
\n fun deleteData(id: Int) {\n val db = this.writableDatabase\n db.delete(TABLE_NAME, \"$COLUMN_ID = ?\", arrayOf(id.toString()))\n db.close()\n }\n <\/code>\n <\/pre>\n<\/section>\n4. Room \ub370\uc774\ud130\ubca0\uc774\uc2a4<\/h2>\n
\n
4.1. Entity \ud074\ub798\uc2a4 \uc815\uc758<\/h3>\n
\n
\n @Entity(tableName = \"user_table\")\n data class User(\n @PrimaryKey(autoGenerate = true) val id: Int = 0,\n @ColumnInfo(name = \"name\") val name: String\n )\n <\/code>\n <\/pre>\n4.2. DAO \uc778\ud130\ud398\uc774\uc2a4 \uc815\uc758<\/h3>\n
\n
\n @Dao\n interface UserDao {\n @Insert\n suspend fun insert(user: User)\n \n @Query(\"SELECT * FROM user_table\")\n suspend fun getAllUsers(): List4.3. RoomDatabase \ud074\ub798\uc2a4 \uc815\uc758<\/h3>\n
\n
\n @Database(entities = [User::class], version = 1)\n abstract class UserDatabase : RoomDatabase() {\n abstract fun userDao(): UserDao\n \n companion object {\n @Volatile\n private var INSTANCE: UserDatabase? = null\n\n fun getDatabase(context: Context): UserDatabase {\n return INSTANCE ?: synchronized(this) {\n val instance = Room.databaseBuilder(\n context.applicationContext,\n UserDatabase::class.java,\n \"user_database\"\n ).build()\n INSTANCE = instance\n instance\n }\n }\n }\n }\n <\/code>\n <\/pre>\n4.4. \ub370\uc774\ud130 \uc870\uc791\ud558\uae30<\/h3>\n
\ub370\uc774\ud130 \uc0bd\uc785<\/h4>\n
\n
\n private fun insertUser(user: User) {\n CoroutineScope(Dispatchers.IO).launch {\n val db = UserDatabase.getDatabase(context)\n db.userDao().insert(user)\n }\n }\n <\/code>\n <\/pre>\n\ub370\uc774\ud130 \uc870\ud68c<\/h4>\n
\n
\n private fun getAllUsers() {\n CoroutineScope(Dispatchers.IO).launch {\n val db = UserDatabase.getDatabase(context)\n val users = db.userDao().getAllUsers()\n }\n }\n <\/code>\n <\/pre>\n\ub370\uc774\ud130 \uc218\uc815<\/h4>\n
\n
\n private fun updateUser(user: User) {\n CoroutineScope(Dispatchers.IO).launch {\n val db = UserDatabase.getDatabase(context)\n db.userDao().update(user)\n }\n }\n <\/code>\n <\/pre>\n\ub370\uc774\ud130 \uc0ad\uc81c<\/h4>\n
\n
\n private fun deleteUser(user: User) {\n CoroutineScope(Dispatchers.IO).launch {\n val db = UserDatabase.getDatabase(context)\n db.userDao().delete(user)\n }\n }\n <\/code>\n <\/pre>\n<\/section>\n5. \uacb0\ub860<\/h2>\n