Not sure why, but I get some weird error. Console says: "Caused by: java.lang.NullPointerException: Attempt to invoke virtual method 'android.database.sqlite.SQLiteDatabase android.content.Context.openOrCreateDatabase(java.lang.String, int, android.database.sqlite.SQLiteDatabase$CursorFactory, android.database.DatabaseErrorHandler)' on a null object reference"
DBHandler
public class MyDatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME="CategoryDatabase";
public MyDatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, 1);
}
@Override
public void onCreate(SQLiteDatabase database) {
database.execSQL("CREATE TABLE Category (_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT);");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS Category");
onCreate(db);
}
public void addCategory(String name)
{
ContentValues values=new ContentValues(1);
values.put("name", name);
getWritableDatabase().insert("Category", "name", values);
}
public Cursor getCategories()
{
Cursor cursor = getReadableDatabase().rawQuery("select * from Category", null);
return cursor;
}
public ArrayList<Category> GetAllValues()
{
ArrayList<Category> list = new ArrayList<Category>();
Cursor cursor = getCategories();
if (cursor.moveToFirst())
{
do
{
Category cat = new Category(cursor.getString(0));
list.add(cat);
}
while (cursor.moveToNext());
}
if (cursor != null && !cursor.isClosed())
{
cursor.close();
}
return list;
}
