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