KotLin ORM数据库

KotLin ORM 数据库

数据库实体类

@DatabaseTable(tableName = "t_menu") class MenuDb {


    @DatabaseField(generatedId = true) val id:Int = 0

    @DatabaseField(columnName = "menuname") var menuname:String ?= null

    @DatabaseField(columnName = "menunum") var menunum:String ?= null

    @DatabaseField(columnName = "pic") var pic:String ?= null

    @DatabaseField(columnName = "shapname") var shapname:String ?= null

    @DatabaseField(columnName = "address") var address:String ?= null
//
    @DatabaseField(columnName = "sum") var sum:Int = 0
}

OpenHolder类

class MenuOpenHelper(context: Context?) : OrmLiteSqliteOpenHelper(context,"menu.db",null,1) {

    override fun onCreate(database: SQLiteDatabase?, connectionSource: ConnectionSource?) {
       //创建user表

        TableUtils.createTable(connectionSource,MenuDb::class.java)
    }


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

    }

}

添加数据库

            val menuOpenHelper =MenuOpenHelper(this)
            dao = menuOpenHelper.getDao(MenuDb::class.java)
            val menuDb:MenuDb = MenuDb()

                    menuDb.menuname = menuname
                    menuDb.pic = pic
                    menuDb.menunum = num.toString()
                    menuDb.shapname = shapname
                    menuDb.address = address
                    menuDb.sum = 1


                    dao.create(menuDb)

                    Toast.makeText(this@MeauActivity,"加入成功",Toast.LENGTH_SHORT).show()