Guest User

Untitled

a guest
Aug 15th, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.50 KB | None | 0 0
  1. public 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.  
  49. new 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.  
  54. public 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.  
  63. new MySQLiteHelper(MainActivity.this).fillTable();
  64.  
  65. public 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. }
Add Comment
Please, Sign In to add comment