Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static final String DATABASE_NAME = "Homeomedicaldb";
- private static final int DATABASE_VERSION = 3;
- private static final String DATABASE_TABLE1 = "basic_table";
- private static final String KEY_ID = "sym_id";
- private static final String KEY_NAME = "sym_detail_name";
- private static final String DATABASE_TABLE2 = "detail_table";
- private static final String KEY_SYM_ID = "sym_previous_id";
- private static final String KEY_DET_ID = "sym_detail_id";
- private static final String KEY_SYMP_DETAIL = "sym_details";
- private static final String KEY_MEDICINE = "medicine_name";
- 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);";
- 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+"));" ;
- private DbHelper ourHelper;
- private final Context ourContext;
- private static SQLiteDatabase ourDatabase;
- private static class DbHelper extends SQLiteOpenHelper {
- public DbHelper(Context context) {
- super(context, DATABASE_NAME, null, DATABASE_VERSION);
- // TODO Auto-generated constructor stub
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- // TODO Auto-generated method stub
- db.execSQL(CREATE_DATABASE_TABLE1);
- db.execSQL(CREATE_DATABASE_TABLE2);
- db.execSQL("PRAGMA foreign_keys = ON;");
- ContentValues values = new ContentValues();
- values.put(KEY_ID, "1");
- values.put(KEY_NAME, "headache");
- db.insert(DATABASE_TABLE1, null, values);
- values.put(KEY_ID, "2");
- values.put(KEY_NAME, "abdominal pain");
- db.insert(DATABASE_TABLE1, null, values);
- values.put(KEY_ID, "3");
- values.put(KEY_NAME, "eye infection");
- db.insert(DATABASE_TABLE1, null, values);
- values.put(KEY_ID, "4");
- values.put(KEY_NAME, "skin pimples");
- db.insert(DATABASE_TABLE1, null, values);
- values.put(KEY_ID, "5");
- values.put(KEY_NAME, "infection");
- db.insert(DATABASE_TABLE1, null, values);
- new_values.put(KEY_DET_ID, "1.1");
- new_values.put(KEY_SYMP_DETAIL, "eye;inflammation;with headache");
- new_values.put(KEY_MEDICINE, "lycopodium");
- new_values.put(KEY_SYM_ID, "1");
- return ourDatabase.insert(DATABASE_TABLE2, null, new_values);
- new_values.put(KEY_DET_ID, "1.2");
- new_values.put(KEY_SYMP_DETAIL, "nose;pain;with headache");
- new_values.put(KEY_MEDICINE, "lycopodium");
- new_values.put(KEY_SYM_ID, "1");
- db.insert(DATABASE_TABLE2, null, new_values);
- new_values.put(KEY_DET_ID, "1.3");
- new_values.put(KEY_SYMP_DETAIL, "perspiration;cold;with headache");
- new_values.put(KEY_MEDICINE, "lycopodium");
- new_values.put(KEY_SYM_ID, "1");
- db.insert(DATABASE_TABLE2, null, new_values);
- new_values.put(KEY_DET_ID, "1.4");
- new_values.put(KEY_SYMP_DETAIL, "face;heat;with headache");
- new_values.put(KEY_MEDICINE, "lycopodium");
- new_values.put(KEY_SYM_ID, "1");
- db.insert(DATABASE_TABLE2, null, new_values);
- new_values.put(KEY_DET_ID, "1.5");
- new_values.put(KEY_SYMP_DETAIL, "perspiration;with headache");
- new_values.put(KEY_MEDICINE, "lycopodium");
- new_values.put(KEY_SYM_ID, "1");
- db.insert(DATABASE_TABLE2, null, new_values);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement