kotlin数据库

基本用法

创建

class GoodsDb(context: Context?) : SQLiteOpenHelper(context, "goodsdb", null, 1) {

    override fun onCreate(db: SQLiteDatabase) {
        db.execSQL("create table goods (goodsname varchar(20),title varchar(20),price varchar(20),num varchar(20),pic varchar(100),flag varchar(10),ordertype varchar(20),moneytype varchar(20))")
    }

    override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) {

    }
}

清单文件

 <provider
            android:name=".model.db.MyContentProvider"
            android:authorities="自己定义"
            android:enabled="true"
            android:exported="true"></provider>

继承ContentProvider

class MyContentProvider : ContentProvider() {
    var db:SQLiteDatabase ?= null
    override fun onCreate(): Boolean {
        var goodsDb:GoodsDb = GoodsDb(context)
        db = goodsDb.writableDatabase
        if (db == null){
            return false
        }else{
            return true
        }
    }


    override fun delete(uri: Uri, selection: String?, selectionArgs: Array<String>?): Int {
        return db!!.delete("goods",selection,selectionArgs)
    }

    override fun insert(uri: Uri, values: ContentValues?): Uri? {
        db!!.insert("goods",null,values)
        return uri
    }



    override fun query(
        uri: Uri, projection: Array<String>?, selection: String?,
        selectionArgs: Array<String>?, sortOrder: String?
    ): Cursor? {
        return db!!.query("goods",projection,selection,selectionArgs,null,null,sortOrder)
    }

    override fun update(
        uri: Uri, values: ContentValues?, selection: String?,
        selectionArgs: Array<String>?
    ): Int {
        return db!!.update("goods",values,selection,selectionArgs)
    }


    override fun getType(uri: Uri): String? {
        TODO(
            "Implement this to handle requests for the MIME type of the data" +
                    "at the given URI"
        )
    }

}

使用

	var uri:Uri ?= null
    var db:ContentResolver ?= null
 	fun oncreate{
 		uri = Uri.parse("content://www.bw.zhigao")
        db = contentResolver
        //查询
        var query= db!!.query(uri, arrayOf("goodsname","title","price","num","pic","flag","ordertype","moneytype"),null,null,null)
        if (query != null){
            dataBeans.clear()
            while (query.moveToNext()){
                var  goodsname = query.getString(query.getColumnIndex("goodsname"))
                var  title = query.getString(query.getColumnIndex("title"))
                var  price = query.getString(query.getColumnIndex("price")).toInt()
                var  num = query.getString(query.getColumnIndex("num")).toInt()
                var  pic = query.getString(query.getColumnIndex("pic"))
                var  flag = query.getString(query.getColumnIndex("flag"))
                var  ordertype = query.getString(query.getColumnIndex("ordertype"))
                var  moneytype = query.getString(query.getColumnIndex("moneytype"))
            }
}