Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.example.konrad.sqlite_database.feature;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- import android.content.Context;
- import android.util.Log;
- public class MyDatabase extends SQLiteOpenHelper {
- public static final int DATABASE_VERSION = 1;
- public static final String DATABASE_NAME = "mydatabase.db";
- private static final String SQL_CREATE_ENTRIES = "CREATE TABLE " + MyDatabaseInfo.TABLE_NAME + " (" + MyDatabaseInfo._ID + " INTEGER PRIMARY KEY," + MyDatabaseInfo.COLUMN_NAME_USER_NAME + " TEXT," + MyDatabaseInfo.COLUMN_NAME_CASH + " INTEGER" + ")";
- private static final String SQL_DELETE_ENTRIES = "DROP TABLE IF EXISTS " + MyDatabaseInfo.TABLE_NAME;
- private final static String LOG_TAG = "RKLog";
- public MyDatabase(Context context){
- super(context, DATABASE_NAME, null, DATABASE_VERSION);
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- db.execSQL(SQL_CREATE_ENTRIES);
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- Log.w(LOG_TAG, "Upgrading database from version " + oldVersion + "to" + newVersion + ", which will destroy all old data");
- db.execSQL(SQL_DELETE_ENTRIES);
- onCreate(db);
- }
- @Override
- public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- onUpgrade(db, oldVersion, newVersion);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement