Guest User

Untitled

a guest
Sep 22nd, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. db = new Database(this);
  2.  
  3. public class Database extends SQLiteOpenHelper {
  4. public static final String DATABASE_NAME = "days.db";
  5. public static final String TABLE_NAME = "days";
  6. public static final String COLUMN_1 = "date";
  7. public static final String COLUMN_2 = "blob";
  8. private Context context;
  9.  
  10.  
  11. public Database(Context context) {
  12. super(context, DATABASE_NAME, null, 1);
  13. }
  14.  
  15. @Override
  16. public void onCreate(SQLiteDatabase db) {
  17. db.execSQL("create table IF NOT EXISTS " + TABLE_NAME + " (" + COLUMN_1 + " TEXT, " + COLUMN_2 + " BLOB)");
  18. }
  19.  
  20. @Override
  21. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  22. onCreate(db);
  23. }
  24.  
  25. }
  26.  
  27. public class Database extends SQLiteOpenHelper {
  28. private Context context1;
  29.  
  30. public Database(Context context) {
  31.  
  32. super(context, "CREATECONTACT", null, 1);
  33. this.context1 = context;
  34. }
  35.  
  36. @Override
  37. public void onCreate(SQLiteDatabase db) {
  38. String query = "CREATE TABLE createContact ( n" +
  39. " ID INTEGER PRIMARY KEY AUTOINCREMENTn" +
  40. " NOT NULLn" +
  41. " UNIQUE,n" +
  42. " Name VARCHAR( 50 ) NOT NULL,n" +
  43. " Phone VARCHAR NOT NULL,n" +
  44. " typeofPhone VARCHAR NOT NULL,n" +
  45. " Email VARCHAR NOT NULL,n" +
  46. " typeofEmail VARCHAR NOT NULL,n" +
  47. " FAVE VARCHAR NOT NULL,n" +
  48. " RED INTEGER,n" +
  49. " GREEN INTEGER,n" +
  50. " BLUE INTEGER n" +
  51. ");n";
  52. db.execSQL(query);
  53. }
  54.  
  55. @Override
  56. public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  57. db.execSQL("DROP TABLE IF EXISTS createContact");
  58. onCreate(db);
  59. }
Add Comment
Please, Sign In to add comment