ORMlite数据库

基本使用

依赖

implementation 'com.j256.ormlite:ormlite-android:5.0'
implementation 'com.j256.ormlite:ormlite-core:5.0'

表类

@DatabaseTable(tableName = "t_user")class UserDb {

    @DatabaseField(generatedId = true) var id: Int = 0
    @DatabaseField(columnName = "name")  var name: String? = null
    @DatabaseField(columnName = "phone") var phone: String? = null
    
}

构造表

class TakeoutOpetHelper(val context: Context) : OrmLiteSqliteOpenHelper(context,"takeout_kotlin.db",null,1){
    override fun onCreate(database: SQLiteDatabase?, connectionSource: ConnectionSource?) {
        TableUtils.createTable(connectionSource,UserDb::class.java)
    }

    override fun onUpgrade(
        database: SQLiteDatabase?,
        connectionSource: ConnectionSource?,
        oldVersion: Int,
        newVersion: Int
    ) {
        TODO("not implemented") //To change body of created functions use File | Settings | File Templates.
    }


}

具体实现

                //缓存到数据库中
                val takeoutOpetHelper =  TakeoutOpetHelper(loginActivity)
                val userDao : Dao<UserDb,Int> = takeoutOpetHelper.getDao(UserDb::class.java)
                val userdb = UserDb()
                userdb.name = “张三”
                userdb.phone = “123456789”
				//添加
				userDao.create(userdb)