M0q0idW5

1public class MySQLiteHelper extends SQLiteOpenHelper{
2    final static String DB_NAME = "citiesdata.db";
3    final static String TABLE_NAME = "allcities";
4    final static String ID = "_id";
5    final static String CITY_CODE = "city_code";
6    final static int DB_VERSION = 1;
7    private SQLiteDatabase db;
8    Context cont;
9
10    public MySQLiteHelper(Context context) {
11        super(context, DB_NAME, null, DB_VERSION);
12        cont = context;
13        Toast.makeText(cont, "constructor called", Toast.LENGTH_LONG).show();
14    }
15
16    @Override
17    public void onCreate(SQLiteDatabase db) {
18        Toast.makeText(cont, "onCreate method called", Toast.LENGTH_LONG).show();
19        String createTable = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "(" + ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + CITY_CODE + " TEXT);";
20        db.execSQL(createTable);
21
22//      INSERTING RECORDS IN DATABASE
23        SQLiteDatabase writableDB = this.getWritableDatabase();
24        ContentValues values = new ContentValues();
25        values.put(CITY_CODE, "333");
26        writableDB.insert(TABLE_NAME, null, values);
27        writableDB.close();
28        readCity();
29    }
30
31    @Override
32    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
33        Toast.makeText(cont, "onUpgrade method called", Toast.LENGTH_LONG).show();
34        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
35        onCreate(db);
36    }
37
38
39    public void readCity(){
40        Toast.makeText(cont, "readCity method called", Toast.LENGTH_LONG).show();
41        String selectQuery = "SELECT  * FROM " + TABLE_NAME;
42        SQLiteDatabase db = this.getReadableDatabase();
43        Cursor cursor = db.rawQuery(selectQuery, null);
44        Toast.makeText(cont, cursor.getString(cursor.getColumnIndex(CITY_CODE)), Toast.LENGTH_LONG).show();
45        db.close();
46    }
47}
48	
49new MySQLiteHelper(MainActivity.this);
50	
51<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>
52<uses-permission android:name="android.permission.WRITE_INTERNAL_STORAGE"/>
53	
54public void fillTable(){
55    db = this.getWritableDatabase();
56    ContentValues values = new ContentValues();
57    values.put(CITY_CODE, "333");
58    db.insert(TABLE_NAME, null, values);
59    db.close();
60    readCity();
61}
62	
63new MySQLiteHelper(MainActivity.this).fillTable();
64	
65public MySQLiteHelper(Context context) {
66    super(context, DB_NAME, null, DB_VERSION);
67    cont = context;
68    SQLiteDatabase db = this.getReadableDatabase();
69    Toast.makeText(cont, "constructor called", Toast.LENGTH_LONG).show();
70}