EpPQ9iVK

1private static  final String TABLE_CREATE_QUIZ = "create table quiz (QUIZ_ID integer primary key not null ,"+
2         "question text not null, answer1 text not null, answer2 text not null, answer3 text not null, answer4 text not null);";
3
4 public DatabaseHelper(Context context)
5 {
6     super(context , DATABASE_NAME , null , DATABASE_VERSION);
7 }
8
9
10
11 @Override
12 public void onCreate(SQLiteDatabase db) {
13     db.execSQL(TABLE_CREATE);
14     db.execSQL(TABLE_CREATE_QUIZ);
15     this.db = db;
16 }
17
18 @Override
19 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
20     String query = "DROP TABLE IF EXISTS "+TABLE_NAME;
21     String query1 = "DROP TABLE IF EXISTS "+TABLE_CREATE_QUIZ;
22     db.execSQL(query);
23     db.execSQL(query1);
24     this.onCreate(db);
25
26 }
27
28 public void insertContact(Contact c) {
29     db = this.getWritableDatabase();
30     ContentValues values = new ContentValues();
31
32     String query = "select * from contacts";
33     Cursor cursor = db.rawQuery(query , null);
34     int count = cursor.getCount();
35
36     values.put(COLUMN_ID , count);
37     values.put(COLUMN_NAME , c.getName());
38     values.put(COLUMN_EMAIL , c.getEmail());
39     values.put(COLUMN_UNAME, c.getUname());
40     values.put(COLUMN_PASS, c.getPass());
41
42     db.insert(TABLE_NAME, null, values);
43     db.close();
44 }
45     public boolean insertQuest(String question, String answer1, String answer2, String answer3, String answer4){
46     db = this.getWritableDatabase();
47         ContentValues contentValues = new ContentValues();
48         String query1 = "select * from quiz";
49         Cursor cursor = db.rawQuery(query1 , null);
50         int count = cursor.getCount();
51
52         contentValues.put(COLUMN_QUIZ_ID, count);
53         contentValues.put(COLUMN_QUESTION, question);
54         contentValues.put(COLUMN_ANSWER1, answer1);
55         contentValues.put(COLUMN_ANSWER2, answer2);
56         contentValues.put(COLUMN_ANSWER3, answer3);
57         contentValues.put(COLUMN_ANSWER4, answer4);
58
59         long result = db.insert(TABLE_QUIZ, null, contentValues);
60         if(result == -1)
61             return false;
62         else
63         return true;
64
65 }
66 public Cursor getAllData(){
67     db = this.getWritableDatabase();
68     Cursor res = db.rawQuery("select * from"+TABLE_QUIZ,null);
69     return res;
70 } 
71     
72public void viewAll(){
73        view.setOnClickListener(new View.OnClickListener() {
74            @Override
75            public void onClick(View v) {
76             Cursor res = helper.getAllData();
77                if(res.getCount()== 0){
78                    showMessage("Error","Nothing found");
79                    return;
80                }
81                StringBuffer buffer = new StringBuffer();
82                while (res.moveToNext()){
83                    buffer.append("Id:"+ res.getString(0)+"n");
84                    buffer.append("Question:"+ res.getString(1)+"n");
85                    buffer.append("Answer1:"+ res.getString(2)+"n");
86                    buffer.append("Answer2:"+ res.getString(3)+"n");
87                    buffer.append("Answer3:"+ res.getString(4)+"n");
88                    buffer.append("Answer4:"+ res.getString(5)+"nn");
89                }
90
91                showMessage("Data",buffer.toString());
92            }
93        });
94    }
95
96    public void showMessage(String title, String Message){
97        AlertDialog.Builder builder = new AlertDialog.Builder(this);
98        builder.setCancelable(true);
99        builder.setTitle(title);
100        builder.setMessage(Message);
101        builder.show();
102
103    }