sqlite数据库增删改查[Kotlin]

最新推荐文章于 2025-10-26 13:42:27 发布

原创最新推荐文章于 2025-10-26 13:42:27 发布 · 867 阅读

15 ·

CC 4.0 BY-SA版权

文章标签：

#windows

本文介绍了一个名为SQLUtils的类，用于在SQLite数据库中进行MusicSQL表的操作，包括添加、更新、删除和查询音乐视频实体（VideosEntity）。

class SQLUtils(sql: MusicSQL, db: SQLiteDatabase) {
//添加对象
    fun add(music: VideosEntity) {
        val cv = ContentValues()
        cv.put("name", music.name)
        cv.put("singer", music.singer)
        cv.put("duraion", music.duration)
        cv.put("pic", music.pic)
        cv.put("data", music.videopath)
        db!!.insert("music", null, cv)
    }
//更改对象
    fun updata(music: VideosEntity) {
        val cv = ContentValues()
        cv.put("name", music.name)
        cv.put("singer", music.singer)
        cv.put("duraion", music.duration)
        cv.put("pic", music.pic)
        db!!.update("music", cv, "name = ?", arrayOf(music.name))
    }
//删除对象
    fun delete(name: String) {
        db!!.delete("music", "name = ?", arrayOf(name))
    }
//查询全部
    @SuppressLint("Range")
    fun qurey(): MutableList<VideosEntity> {
        var list = mutableListOf<VideosEntity>()
        val cur = db!!.query("music", null, null, null, null, null, null)
        while (cur.moveToNext()) {
            val name = cur.getString(cur.getColumnIndex("name"))
            val singer = cur.getString(cur.getColumnIndex("singer"))
            val data = cur.getString(cur.getColumnIndex("data"))
            val pic = cur.getString(cur.getColumnIndex("pic"))
            val duration = cur.getInt(cur.getColumnIndex("duration"))
            val music = VideosEntity(name, singer,duration , pic,data )
            list.add(music)
        }
        return list
    }
}