Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class MyDBOpenHelper extends SQLiteOpenHelper {
- private static final String queryCreationBdd = "CREATE TABLE partie (id INTEGER PRIMARY KEY)";
- public MyDBOpenHelper(Context context, String name, CursorFactory factory, int version)
- {
- super(context, name, factory, version);
- }
- @Override
- public void onCreate(SQLiteDatabase db)
- {
- db.execSQL(queryCreationBdd);
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
- {
- db.execSQL("DROP TABLE partie;");
- db.execSQL("DELETE FROM sqlite_sequence"); //table which contains the next incremented key value
- onCreate(db);
- }
- }
- MyDBOpenHelper databaseHelper = new MyDBOpenHelper(context, "dbname.db", null, 1);
- SQLiteDatabase bdd = databaseHelper .getWritableDatabase();
- /data/data/fr.mathis.application/databases/dbname.db
- try{
- SQLiteDatabase dbe = SQLiteDatabase.openDatabase("/data/data/bangla.rana.fahim/databases/dictionary", null,0);
- Log.d("opendb","EXIST");
- dbe.close();
- }
- catch(SQLiteException e){
- Log.d("opendb","NOT EXIST");
- SQLiteDatabase db = openOrCreateDatabase("dictionary", MODE_PRIVATE, null);
- db.execSQL("CREATE TABLE IF NOT EXISTS LIST(wlist varchar);");
- db.execSQL("INSERT INTO LIST VALUES('খবর');");
- db.execSQL("INSERT INTO LIST VALUES('কবর');"); //whatever you want
- db.close();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement