TP2_Partie_1_Base_de_donnee
(ouvrir le fichier BdSQLiteOpenHelper.java )
package org.btssio.bd1;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class BdSQLiteOpenHelper extends SQLiteOpenHelper {
private String requete="create table viticulteur ("
+ "id INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "nom TEXT NOT NULL,"
+ "prenom TEXT NOT NULL,"
+ "ville TEXT NOT NULL,"
+ "niveau INTEGER NOT NULL);";
public BdSQLiteOpenHelper(Context context, String name, CursorFactory factory, int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(requete);
// 1ère méthode pour insérer des enregistrements dans une table
db.execSQL("insert into viticulteur (nom,prenom,ville,niveau) values('Tissot','Jacques','MONTIGNY LES ARSURES',50);");
db.execSQL("insert into viticulteur (nom,prenom,ville,niveau) values('Bulabois','Philippe','ARBOIS',60);");
// 2ème méthode pour
ContentValues value = new ContentValues();
value.put("nom", "Badoz");
value.put("prenom", "Benoit");
value.put("ville", "POLIGNY");
value.put("niveau",30);
db.insert("viticulteur", null, value);
value.put("nom", "Thiebaut");
value.put("prenom", "Etienne");
value.put("ville", "PORT LESNEY");
value.put("niveau",55);
db.insert("viticulteur", null, value);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
Edited by dilhan akyuz