70RUr6Yf

1Database Contract.java
2
3package com.reihanalavi.mynotesapp;
4
5import android.provider.BaseColumns;
6
7/**
8 * Created by rehan on 2/20/2018.
9 */
10
11public class DatabaseContract {
12
13    public static String TABLE_NOTE = "note";
14
15    public static final class NoteColumns implements BaseColumns {
16        public static String TITLE = "title";
17        public static String DESC = "desc";
18        public static String DATE = "date";
19    }
20}
21
22------------------------------------------------------------------------------------------------------
23
24DatabaseHelper.java
25
26package com.reihanalavi.mynotesapp;
27
28import android.content.Context;
29import android.database.sqlite.SQLiteDatabase;
30import android.database.sqlite.SQLiteOpenHelper;
31
32/**
33 * Created by rehan on 2/20/2018.
34 */
35
36public class DatabaseHelper extends SQLiteOpenHelper {
37    public static String DATABASE_NAME = "dbnoteapp";
38    private static final int DATABASE_VERSION = 1;
39    private static final String SQL_CREATE_TABLE_NOTE = String.format
40            ("CREATE TABLE %s" +
41                    " (%s INTEGER PRIMARY KEY AUTOINCREMENT," +
42                    " %s TEXT NOT NULL," +
43                    " %s TEXT NOT NULL," +
44                    " %s TEXT NOT NULL)",
45                    DatabaseContract.TABLE_NOTE,
46                    DatabaseContract.NoteColumns._ID,
47                    DatabaseContract.NoteColumns.TITLE,
48                    DatabaseContract.NoteColumns.DESC,
49                    DatabaseContract.NoteColumns.DATE);
50
51
52    public DatabaseHelper(Context context) {
53        super(context, DATABASE_NAME, null, DATABASE_VERSION);
54    }
55
56    @Override
57    public void onCreate(SQLiteDatabase sqLiteDatabase) {
58        sqLiteDatabase.execSQL(SQL_CREATE_TABLE_NOTE);
59    }
60
61    @Override
62    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
63        sqLiteDatabase.execSQL("DROP TABLE IF EXISTS "+ DatabaseContract.TABLE_NOTE);
64        onCreate(sqLiteDatabase);
65    }
66}
67
68------------------------------------------------------------------------------------------------------