0mfDZpJA

1//MyDatabaseHelper.java
2
3package com.example.sqlitedatabaseone;
4
5import android.content.Context;
6import android.database.sqlite.SQLiteDatabase;
7import android.database.sqlite.SQLiteOpenHelper;
8import android.widget.Toast;
9
10import androidx.annotation.Nullable;
11
12public class MyDataBaseHelper extends SQLiteOpenHelper {
13
14    Context context;
15    private static final String DATABASE_NAME = "students.db";
16
17    private static final String TABLE_NAME = "student_info";
18
19    private static final int VERSION = 2;
20
21    private static final String ID = "_id";
22
23    private static final String AGE = "age";
24
25    private static final String NAME = "name";
26
27    private static final String PROFESSION = "profession";
28
29    private static final String CREATE_TABLE = "CREATE TABLE "+TABLE_NAME+"("+ID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+NAME+" varchar(255), "+AGE+" int(11), "+PROFESSION+" varchar(255))";
30
31    private static final String DROP_TABLE = "DROP TABLE IF EXISTS "+TABLE_NAME;
32
33
34    public MyDataBaseHelper(@Nullable Context context) {
35
36        super(context, DATABASE_NAME, null, VERSION);
37        this.context = context;
38
39    }
40
41    @Override
42    public void onCreate(SQLiteDatabase sqLiteDatabase) {
43
44        try{
45            sqLiteDatabase.execSQL(CREATE_TABLE);
46            Toast.makeText(context, "DataBase Created Successfully", Toast.LENGTH_SHORT).show();
47        }catch (Exception e){
48            Toast.makeText(context, "Database Not Created", Toast.LENGTH_SHORT).show();
49        }
50
51
52
53    }
54
55    @Override
56    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
57        sqLiteDatabase.execSQL(DROP_TABLE);
58        onCreate(sqLiteDatabase);
59        Toast.makeText(context, "OnUpgrade Method is called ", Toast.LENGTH_SHORT).show();
60    }
61}
62
63
64//MainActivity.Java
65
66package com.example.sqlitedatabaseone;
67
68import androidx.appcompat.app.AppCompatActivity;
69
70import android.database.sqlite.SQLiteDatabase;
71import android.os.Bundle;
72
73public class MainActivity extends AppCompatActivity {
74
75    MyDataBaseHelper myDataBaseHelper;
76
77    @Override
78    protected void onCreate(Bundle savedInstanceState) {
79        super.onCreate(savedInstanceState);
80        setContentView(R.layout.activity_main);
81
82        myDataBaseHelper = new MyDataBaseHelper(this);
83        SQLiteDatabase sqLiteDatabase = myDataBaseHelper.getWritableDatabase();
84
85
86    }
87}