I am new in android. I am using about 12 different sqlite DB tables in it and all is need to be created on application startup. So which is the best way to do it? I am using the code similar to the following.
private void createTablesInDatabase() {
SQLiteDatabase sqLiteDatabase;
sqLiteDatabase = activity.openOrCreateDatabase(Constants.DATABASE,
Context.MODE_PRIVATE, null);
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-1> +
" (ID INTEGER PRIMARY KEY AUTOINCREMENT," +
" XXXXX VARCHAR NOT NULL);");
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-5> +
" (ID INTEGER PRIMARY KEY AUTOINCREMENT," +
" AAAAA INT NOT NULL," +
" BBBBB VARCHAR NOT NULL," +
" CCCCC VARCHAR NOT NULL," +
" DDDDD VARCHAR NOT NULL," +
" EEEEE VARCHAR NOT NULL);");
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-2> +
" (ID INTEGER PRIMARY KEY AUTOINCREMENT," +
" XXXXX VARCHAR NOT NULL);");
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-6> +
" (ID INTEGER PRIMARY KEY AUTOINCREMENT," +
" AAAAA INT NOT NULL," +
" BBBBB VARCHAR NOT NULL," +
" FFFFF VARCHAR NOT NULL," +
" EEEEE VARCHAR NOT NULL," +
" GGGGG VARCHAR NOT NULL," +
" HHHHH VARCHAR NOT NULL);");
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-3> +
" (ID INTEGER PRIMARY KEY AUTOINCREMENT," +
" XXXXX VARCHAR NOT NULL);");
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-7> +
" (ID INTEGER PRIMARY KEY AUTOINCREMENT," +
" BBBBB INT NOT NULL," +
" CCCCC VARCHAR NOT NULL," +
" IIIII VARCHAR NOT NULL," +
" FFFFF VARCHAR NOT NULL);");
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-4> +
" (ID INTEGER PRIMARY KEY AUTOINCREMENT," +
" XXXXX VARCHAR NOT NULL);");
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-9> +
" (ID INTEGER PRIMARY KEY AUTOINCREMENT," +
" BBBBB VARCHAR NOT NULL," +
" AAAAA VARCHAR NOT NULL," +
" CCCCC VARCHAR NOT NULL," +
" FFFFF VARCHAR NOT NULL" +
" );");
sqLiteDatabase.execSQL("CREATE TABLE IF NOT EXISTS "
+ <table-name-8> +
" (ID INT PRIMARY KEY NOT NULL," +
" PPPPP VARCHAR NOT NULL," +
" QQQQQ VARCHAR NOT NULL," +
" RRRRR VARCHAR NOT NULL," +
" SSSSS VARCHAR," +
" TTTTT INT DEFAULT 1);");
sqLiteDatabase.close();
}
Aucun commentaire:
Enregistrer un commentaire