· 8 years ago · Aug 08, 2018, 02:50 PM
1package com.mht.events;
2
3import android.content.ContentValues;
4import android.content.Context;
5import android.database.Cursor;
6import android.database.SQLException;
7import android.database.sqlite.SQLiteDatabase;
8import android.database.sqlite.SQLiteOpenHelper;
9import android.util.Log;
10
11public class ItemsDbAdapter
12{
13 private static final String DATABASE_NAME = "daycounterdb";
14 private static final String SQLITE_TABLE_ONE = "Event_details";
15 public static final String EVENTAUTOID = "Event_autoid";
16 public static final String EVENTNAME = "Event_name";
17 public static final String EVENTDATE= "Event_date";
18 public static final String EVENTTYPE= "Event_type";
19 public static final String EVENTDATEYEAR= "Event_dateyear";
20 public static final String EVENTID= "Event_id";
21
22
23 private static final String TAG = "ItemsDbAdapter";
24 private DatabaseHelper mDbHelper;
25 private SQLiteDatabase mDb;
26
27
28 private static final int DATABASE_VERSION = 1;
29
30 private final Context mCtx;
31
32 private static final String DATABASE_CREATE_FIRST =
33 "CREATE TABLE if not exists " + SQLITE_TABLE_ONE + " ("+
34 EVENTAUTOID +" INTEGER PRIMARY KEY autoincrement,"+EVENTNAME +","+EVENTDATE+","+EVENTTYPE+","+EVENTDATEYEAR+","+EVENTID+");";
35
36
37 private static class DatabaseHelper extends SQLiteOpenHelper {
38
39 DatabaseHelper(Context context) {
40 super(context, DATABASE_NAME, null, DATABASE_VERSION);
41 }
42
43
44 @Override
45 public void onCreate(SQLiteDatabase db) {
46 //Log.w(TAG, DATABASE_CREATE);
47
48 db.execSQL(DATABASE_CREATE_FIRST);
49
50 }
51
52 @Override
53 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
54
55 }
56 }
57
58 public ItemsDbAdapter(Context ctx) {
59 this.mCtx = ctx;
60 }
61
62 public ItemsDbAdapter open() throws SQLException {
63 mDbHelper = new DatabaseHelper(mCtx);
64 mDb = mDbHelper.getWritableDatabase();
65 return this;
66 }
67
68 public void close() {
69 if (mDbHelper != null) {
70 mDbHelper.close();
71 }
72 }
73
74
75
76 public void createItem()
77 {
78
79 insertItem("Republic Day(India)","26-01","Worldevents","26-01-2012","");
80 insertItem("Valentine Day","14-02","Worldevents","14-02-2012","");
81 insertItem("International woman's Day","21-02","Worldevents","21-02-2012","");
82 insertItem("Water Day","22-03","Worldevents","22-03-2012","");
83 insertItem("Health Day","07-04","Worldevents","07-04-2012","");
84 insertItem("Earth Day","22-04","Worldevents","22-04-2012","");
85 insertItem("Labour Day","01-05","Worldevents","01-05-2012","");
86 insertItem("Mother's Day","02-05","Worldevents","02-05-2012","");
87 insertItem("Anti-Tobacco","31-05","Worldevents","31-05-2012","");
88 insertItem("Father's Day","18-06","Worldevents","18-06-2012","");
89 insertItem("Diabetes Day","27-06","Worldevents","27-06-2012","");
90 insertItem("Peace Day","06-08","Worldevents","06-08-2012","");
91 insertItem(" Independence Day (India)","15-08","Worldevents","15-08-2012","");
92 insertItem("World Deaf and Heart Day","24-09","Worldevents","24-09-2012","");
93 insertItem("Non- violence Day","02-10","Worldevents","02-10-2012","");
94 insertItem("Teacher’s Day","05-10","Worldevents","05-10-2012","");
95 insertItem(" Food Day","16-10","Worldevents","16-10-2012","");
96 insertItem("UN Day","24-10","Worldevents","24-10-2012","");
97 insertItem("Children’s Day","20-11","Worldevents","20-11-2012","");
98 insertItem("AIDS Day","01-12","Worldevents","01-12-2012","");
99 insertItem("Christmas","25-12","Worldevents","25-12-2012","");
100 }
101
102
103 public long insertItem(String eventName,String eventDate,String eventType,String eventDateYear,String eventId)
104 {
105 ContentValues initialValues = new ContentValues();
106 initialValues.put(EVENTNAME, eventName);
107 initialValues.put(EVENTDATE, eventDate);
108 initialValues.put(EVENTTYPE, eventType);
109 initialValues.put(EVENTDATEYEAR, eventDateYear);
110 initialValues.put(EVENTID,eventId);
111 return mDb.insert(SQLITE_TABLE_ONE, null, initialValues);
112 }
113
114
115}