e4zfrrCv

1import android.content.ContentValues;
2import android.content.Context;
3import android.database.sqlite.SQLiteDatabase;
4import android.database.sqlite.SQLiteOpenHelper;
5
6public class DbOpenHelper extends SQLiteOpenHelper {
7
8
9    private static final String TAG = "DbOpenHelper";
10    private static final String DATABASE_NAME = "todo";
11    private static final String TODO_TABLE_NAME = "mst_todo";
12    private static final int DATABASE_VERSION = 1;
13
14    public DbOpenHelper(Context context){
15        super(context, DATABASE_NAME, null, DATABASE_VERSION);
16    }
17
18    @Override
19    public void onCreate(SQLiteDatabase db){
20        createToDoTable(db);
21    }
22    /*
23     * Update ToDo Table
24     * This method execute when application was upgraded
25     * Change the database configuration
26     * */
27    @Override
28    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion){
29        db.execSQL("DROP TABLE IF EXISTS " + TODO_TABLE_NAME + ";");
30        onCreate(db);
31    }
32    /*
33     * Initialize process create ToDo Table
34     * */
35    private void createToDoTable(SQLiteDatabase db){
36        String sql = "CREATE TABLE mst_todo ( "
37                + " id int(11) NOT NULL COMMENT'Tasku ID' AUTO_INCREMENT, "
38                + "Title text NOT NULL COMMENT'Title', "
39                + "created_at timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT'Create Time', "
40                + "update_at timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT'Update Time', "
41                + "delflg tinyint(3) NOT NULL DEFAULT 0 COMMENT'Delete Flag', "
42                + "PRIMARY KEY (id); ";
43        db.execSQL(sql);
44    }
45}