jeudi 21 mai 2015

Table not being created sqlite andoird

I am using a database in my app.For that i have created sqlite database with single instance.But when i run the app no table is being created.I dont know what is the problem.

Code

public class DatabaseHelper extends SQLiteOpenHelper {
    private static DatabaseHelper mInstance = null;

    private static final String DATABASE_NAME = "MCQDemo";
    private static final String DATABASE_TABLE = "LANGUAGETABLE";
    private static final int DATABASE_VERSION = 1;

    private Context mCxt;

    public static DatabaseHelper getInstance(Context ctx) {
        /**
         * use the application context as suggested by CommonsWare.
         * this will ensure that you dont accidentally leak an Activitys
         * context (see this article for more information:
         * http://ift.tt/1fiOpAy)
         */
        if (mInstance == null) {
            mInstance = new DatabaseHelper(ctx.getApplicationContext());
        }
        return mInstance;
    }

    /**
     * constructor should be private to prevent direct instantiation.
     * make call to static factory method "getInstance()" instead.
     */
    private DatabaseHelper(Context ctx) {
        super(ctx, DATABASE_NAME, null, DATABASE_VERSION);
        this.mCxt = ctx;
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        try {
            db.execSQL(LanguageTable.CreateTable());
        } catch (SQLiteException e) {

        }


    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

LanguageTable

public class LanguageTable {

    private SQLiteDatabase database;
    private DatabaseHelper databaseHelper;
    private Context context;
    private static String TableName = "LANGUAGETABLE";
    private boolean result;


    private static String Language_Name = "language_name";


    public LanguageTable(Context context) {
        this.context = context;
        databaseHelper = DatabaseHelper.getInstance(context);
    }

    public static String CreateTable() {
        String query = "Create table " + TableName + " ( " +
                Language_Name + " varchar " +
                ");";

        return query;

    }

Please do let me find out the problem. Thanks

Aucun commentaire:

Enregistrer un commentaire