package com.example.exemple4;

import android.provider.BaseColumns;

public final class DbContrat {

public static final String dbRestos = "dbrestos";
public static final int DB_VERSION = 1;

public static abstract class Restaurant implements BaseColumns {

public static final String T_NOM = "restaurant";
public static final String C_NOM = "nom";
public static final String C_ADRESSE = "adresse";
public static final String SQL_CREATE = "create table " + T_NOM + "("
+ _ID + " INTEGER PRIMARY KEY," + C_NOM + " TEXT ," + C_ADRESSE
+ " TEXT )";
public static final String SQL_DROP = "DROP TABLE IF EXISTS " + T_NOM;}}



/////////////////////////////


package com.example.exemple4;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DbRestos extends SQLiteOpenHelper {

public DbRestos(Context context) {
super(context, DbContrat.dbRestos, null, DbContrat.DB_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(DbContrat.Restaurant.SQL_CREATE);
db.execSQL("insert into Restaurant(nom,adresse) values('R1','A1')");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL(DbContrat.Restaurant.SQL_DROP);
onCreate(db);
}
}
//////////////////////