Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.redorange.database;
- import android.content.Context;
- import android.database.sqlite.SQLiteDatabase;
- import android.database.sqlite.SQLiteOpenHelper;
- import android.database.sqlite.SQLiteDatabase.CursorFactory;
- import android.provider.BaseColumns;
- import android.util.Log;
- public class HeadshopSQLHelper extends SQLiteOpenHelper{
- private static final String DATABASE_Name1 = "HeadShop DataBase";
- private static final int DATABASE_VERSION1 = 1;
- //create table name
- public static final String TABLE1 = "HeadTable1";
- //DEFINE COLOMN Name
- public static final long _ID = 1;
- public static final String NAME = "Name";
- public static final String GRADE = "Grade";
- public static final String DESCRIPTION = "Description";
- public HeadshopSQLHelper(Context context) {
- super(context ,DATABASE_Name1, null, DATABASE_VERSION1);
- }
- @Override
- public void onCreate(SQLiteDatabase db1) {
- String sql = "create table " + TABLE1 + "( " + BaseColumns._ID
- + " integer primary key autoincrement, " + NAME + " text not null, "
- + GRADE + " text not null, " + DESCRIPTION + " text not null);";
- Log.d("Headshop", "onCreate: " + sql);
- db1.execSQL(sql);
- }
- //@Override
- public void onCreate1(SQLiteDatabase db1) {
- String sql = "Alter table " + TABLE1 + "( " + BaseColumns._ID
- + " integer primary key autoincrement, " + NAME + " text not null, "
- + GRADE + " text not null, " + DESCRIPTION + " text not null);";
- Log.d("Headshop", "onCreate: " + sql);
- db1.execSQL(sql);
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- if (oldVersion >= newVersion)
- return;
- String sql = null;
- if (oldVersion == 1)
- sql = "alter table " + TABLE1 + " add note text;";
- if (oldVersion == 2)
- sql = "";
- Log.d("Headshop", "onUpgrade : " + sql);
- if (sql != null)
- db.execSQL(sql);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement