Advertisement
Guest User

Untitled

a guest
Jul 31st, 2014
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.78 KB | None | 0 0
  1. private static final String DATABASE_NAME = "Homeomedicaldb";
  2. private static final int DATABASE_VERSION = 3;
  3.  
  4. private static final String DATABASE_TABLE1 = "basic_table";
  5. private static final String KEY_ID = "sym_id";
  6. private static final String KEY_NAME = "sym_detail_name";
  7.  
  8. private static final String DATABASE_TABLE2 = "detail_table";
  9. private static final String KEY_SYM_ID = "sym_previous_id";
  10. private static final String KEY_DET_ID = "sym_detail_id";
  11. private static final String KEY_SYMP_DETAIL = "sym_details";
  12. private static final String KEY_MEDICINE = "medicine_name";
  13.  
  14. private static final String CREATE_DATABASE_TABLE1 = "CREATE TABLE IF NOT EXISTS " + DATABASE_TABLE1 + " (" + KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_NAME + " TEXT NOT NULL);";
  15. private static final String CREATE_DATABASE_TABLE2 = "CREATE TABLE IF NOT EXISTS " + DATABASE_TABLE2 + " (" + KEY_DET_ID + " INTEGER PRIMARY KEY, " + KEY_SYMP_DETAIL + " text not null, " + KEY_MEDICINE + " text not null, " + KEY_SYM_ID + " integer, "+ " FOREIGN KEY ("+KEY_SYM_ID+") REFERENCES "+DATABASE_TABLE1+" ("+KEY_ID+"));" ;
  16.  
  17.  
  18. private DbHelper ourHelper;
  19. private final Context ourContext;
  20. private static SQLiteDatabase ourDatabase;
  21.  
  22.  
  23. private static class DbHelper extends SQLiteOpenHelper {
  24.  
  25. public DbHelper(Context context) {
  26. super(context, DATABASE_NAME, null, DATABASE_VERSION);
  27. // TODO Auto-generated constructor stub
  28. }
  29.  
  30. @Override
  31. public void onCreate(SQLiteDatabase db) {
  32. // TODO Auto-generated method stub
  33. db.execSQL(CREATE_DATABASE_TABLE1);
  34. db.execSQL(CREATE_DATABASE_TABLE2);
  35. db.execSQL("PRAGMA foreign_keys = ON;");
  36.  
  37.  
  38. ContentValues values = new ContentValues();
  39. values.put(KEY_ID, "1");
  40. values.put(KEY_NAME, "headache");
  41. db.insert(DATABASE_TABLE1, null, values);
  42.  
  43. values.put(KEY_ID, "2");
  44. values.put(KEY_NAME, "abdominal pain");
  45. db.insert(DATABASE_TABLE1, null, values);
  46.  
  47. values.put(KEY_ID, "3");
  48. values.put(KEY_NAME, "eye infection");
  49. db.insert(DATABASE_TABLE1, null, values);
  50.  
  51. values.put(KEY_ID, "4");
  52. values.put(KEY_NAME, "skin pimples");
  53. db.insert(DATABASE_TABLE1, null, values);
  54.  
  55. values.put(KEY_ID, "5");
  56. values.put(KEY_NAME, "infection");
  57. db.insert(DATABASE_TABLE1, null, values);
  58.  
  59. new_values.put(KEY_DET_ID, "1.1");
  60. new_values.put(KEY_SYMP_DETAIL, "eye;inflammation;with headache");
  61. new_values.put(KEY_MEDICINE, "lycopodium");
  62. new_values.put(KEY_SYM_ID, "1");
  63. return ourDatabase.insert(DATABASE_TABLE2, null, new_values);
  64. new_values.put(KEY_DET_ID, "1.2");
  65. new_values.put(KEY_SYMP_DETAIL, "nose;pain;with headache");
  66. new_values.put(KEY_MEDICINE, "lycopodium");
  67. new_values.put(KEY_SYM_ID, "1");
  68. db.insert(DATABASE_TABLE2, null, new_values);
  69.  
  70. new_values.put(KEY_DET_ID, "1.3");
  71. new_values.put(KEY_SYMP_DETAIL, "perspiration;cold;with headache");
  72. new_values.put(KEY_MEDICINE, "lycopodium");
  73. new_values.put(KEY_SYM_ID, "1");
  74. db.insert(DATABASE_TABLE2, null, new_values);
  75.  
  76. new_values.put(KEY_DET_ID, "1.4");
  77. new_values.put(KEY_SYMP_DETAIL, "face;heat;with headache");
  78. new_values.put(KEY_MEDICINE, "lycopodium");
  79. new_values.put(KEY_SYM_ID, "1");
  80. db.insert(DATABASE_TABLE2, null, new_values);
  81.  
  82. new_values.put(KEY_DET_ID, "1.5");
  83. new_values.put(KEY_SYMP_DETAIL, "perspiration;with headache");
  84. new_values.put(KEY_MEDICINE, "lycopodium");
  85. new_values.put(KEY_SYM_ID, "1");
  86. db.insert(DATABASE_TABLE2, null, new_values);
  87.  
  88.  
  89. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement