jeudi 24 mars 2016

SQLite in Android confusion

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