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 } }
sqlite数据库增删改查[Kotlin]
本文介绍了一个名为SQLUtils的类,用于在SQLite数据库中进行MusicSQL表的操作,包括添加、更新、删除和查询音乐视频实体(VideosEntity)。
摘要由CSDN通过智能技术生成