· 9 years ago · Oct 21, 2016, 11:12 AM
1public class DatabaseHelper extends SQLiteOpenHelper {
2
3private static final int DATABASE_VERSION = 13; // Database version
4private static final String DATABASE_NAME = "PharmaQuestions"; // database name
5
6// Table Names
7private static final String TABLE_ACE = "ace";
8private static final String TABLE_ANDROGENS = "androgens";
9
10// General question columns
11private static final String ID = "id"; // question id
12private static final String QUES = "question"; // the question
13private static final String OPTA = "opta"; // option a
14private static final String OPTB = "optb"; // option b
15private static final String OPTC = "optc"; // option c
16private static final String OPTD = "optd"; // option d
17private static final String ANSWER = "answer"; // correct option
18
19private SQLiteDatabase database;
20
21// Create Table ace
22private static final String CREATE_TABLE_ACE = "CREATE TABLE IF NOT EXISTS " + TABLE_ACE + "( "
23 + ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + QUES
24 + " TEXT, "+OPTA +" TEXT, " +OPTB +" TEXT, "+OPTC+" TEXT, "+OPTD
25 + " TEXT, " + ANSWER+ " TEXT)";
26
27// Create Table androgens
28private static final String CREATE_TABLE_ANDROGENS = "CREATE TABLE IF NOT EXISTS " + TABLE_ANDROGENS + "( "
29 + ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + QUES
30 + " TEXT, "+OPTA +" TEXT, " +OPTB +" TEXT, "+OPTC+" TEXT, "+OPTD
31 + " TEXT, " + ANSWER+ " TEXT)";
32
33public DatabaseHelper(Context context) {
34 super(context, DATABASE_NAME, null, DATABASE_VERSION);
35}
36
37@Override
38public void onCreate(SQLiteDatabase db) {
39 // creating required tables
40 database = db;
41 db.execSQL(CREATE_TABLE_ACE);
42 db.execSQL(CREATE_TABLE_ANDROGENS);
43 addQuestions();
44}
45
46@Override
47public void onUpgrade(SQLiteDatabase db, int oldV, int newV) {
48 // Drop older table if existed
49 db.execSQL("DROP TABLE IF EXISTS " + TABLE_ACE);
50 db.execSQL("DROP TABLE IF EXISTS " + TABLE_ANDROGENS);
51 // Create tables again
52 onCreate(db);
53}
54
55private void addQuestions() {
56 // ACE Questions
57 Question ace1 = new Question("ACE Frage Nr. 1?","Antwort1", "Antwort2", "Antwort3", "Antwort4", "Antwort1");
58 this.addACEQuestion(ace1);
59 Question ace2 = new Question("ACE Frage Nr. 2?", "Antwort1", "Antwort2", "Antwort3", "Antwort4", "Antwort2");
60 this.addACEQuestion(ace2);
61 // Androgen Questions
62 Question androgen1 = new Question("Androgen Frage Nr. 1?", "Antwort1", "Antwort2", "Antwort3", "Antwort4", "Antwort2");
63 this.addAndrogensQuestion(androgen1);
64 Question androgen2 = new Question("Androgen Frage Nr. 2?", "Antwort1", "Antwort2", "Antwort3", "Antwort4", "Antwort2");
65 this.addAndrogensQuestion(androgen2);
66}
67
68// Adding ace question
69public void addACEQuestion(Question quest) {
70 //SQLiteDatabase db = this.getWritableDatabase();
71 ContentValues values = new ContentValues();
72 values.put(QUES, quest.getQUESTION());
73 values.put(OPTA, quest.getOPTA());
74 values.put(OPTB, quest.getOPTB());
75 values.put(OPTC, quest.getOPTC());
76 values.put(OPTD, quest.getOPTD());
77 values.put(ANSWER, quest.getANSWER());
78 // Inserting Rows
79 database.insert(TABLE_ACE, null, values);
80}
81
82// Adding androgen question
83public void addAndrogensQuestion(Question quest) {
84 //SQLiteDatabase db = this.getWritableDatabase();
85 ContentValues values = new ContentValues();
86 values.put(QUES, quest.getQUESTION());
87 values.put(OPTA, quest.getOPTA());
88 values.put(OPTB, quest.getOPTB());
89 values.put(OPTC, quest.getOPTC());
90 values.put(OPTD, quest.getOPTD());
91 values.put(ANSWER, quest.getANSWER());
92 // Inserting Rows
93 database.insert(TABLE_ANDROGENS, null, values);
94}
95
96public List<Question> getAllACEQuestions() {
97 List<Question> quesList = new ArrayList<Question>();
98 // Select All Query
99 String selectQuery = "SELECT * FROM " + TABLE_ACE;
100 database = this.getReadableDatabase();
101 Cursor cursor = database.rawQuery(selectQuery, null);
102 // looping through all rows and adding to list
103 if (cursor.moveToFirst()) {
104 do {
105 Question quest = new Question();
106 quest.setID(cursor.getInt(0));
107 quest.setQUESTION(cursor.getString(1));
108 quest.setOPTA(cursor.getString(2));
109 quest.setOPTB(cursor.getString(3));
110 quest.setOPTC(cursor.getString(4));
111 quest.setOPTD(cursor.getString(5));
112 quest.setANSWER(cursor.getString(6));
113 quesList.add(quest);
114 } while (cursor.moveToNext());
115 }
116 // return quest list
117 return quesList;
118}
119
120public List<Question> getAllAndrogensQuestions() {
121 List<Question> quesList = new ArrayList<Question>();
122 // Select All Query
123 String selectQuery = "SELECT * FROM " + TABLE_ANDROGENS;
124 database = this.getReadableDatabase();
125 Cursor cursor = database.rawQuery(selectQuery, null);
126 // looping through all rows and adding to list
127 if (cursor.moveToFirst()) {
128 do {
129 Question quest = new Question();
130 quest.setID(cursor.getInt(0));
131 quest.setQUESTION(cursor.getString(1));
132 quest.setOPTA(cursor.getString(2));
133 quest.setOPTB(cursor.getString(3));
134 quest.setOPTC(cursor.getString(4));
135 quest.setOPTD(cursor.getString(5));
136 quest.setANSWER(cursor.getString(6));
137 quesList.add(quest);
138 } while (cursor.moveToNext());
139 }
140 // return quest list
141 return quesList;
142}
143
144public int acerowcount() {
145 int row=0;
146 String selectQuery = "SELECT * FROM " + TABLE_ACE;
147 SQLiteDatabase db = this.getWritableDatabase();
148 Cursor cursor = db.rawQuery(selectQuery, null);
149 row=cursor.getCount();
150 return row;
151}
152
153public int androgenrowcount() {
154 int row=0;
155 String selectQuery = "SELECT * FROM " + TABLE_ANDROGENS;
156 SQLiteDatabase db = this.getWritableDatabase();
157 Cursor cursor = db.rawQuery(selectQuery, null);
158 row=cursor.getCount();
159 return row;
160 }
161}