1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
public class DBHelper extends SQLiteOpenHelper {
public static final String DATABASE_NAME = "Mybase.db";
public static final String CONTACTS_TABLE_NAME = "patients";
public static final String CONTACTS_COLUMN_ID = "id";
public static final String CONTACTS_COLUMN_NAME = "nom";
public static final String CONTACTS_COLUMN_PRENOM = "prenom";
public static final String CONTACTS_COLUMN_AGE = "age";
public static final String CONTACTS_COLUMN_TEL = "tel";
public static final String CONTACTS_COLUMN_MALADIE = "maladie";
public static final String CONTACTS_COLUMN_DEGRE = "degre";
public static final String CONTACTS_COLUMN_GROUPE_SANG = "groupe_sang";
public static final String CONTACTS_COLUMN_COMMENTAIRE = "commentaire";
public DBHelper(Context context)
{
super(context, DATABASE_NAME , null, 1);
SQLiteDatabase db = this .getWritableDatabase();
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(
"create table " + CONTACTS_TABLE_NAME +
"(id INTEGER PRIMARY KEY AUTOINCREMENT , nom TEXT,prenom TEXT,age TEXT, tel TEXT,maladie TEXT,degre TEXT,groupe_sang TEXT,commentaire TEXT)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS "+CONTACTS_TABLE_NAME);
onCreate(db);
}
} |
Partager