Java and SQL

[brentc]

I get no compiler error. The execution does not return from the following method...It crashes.

public boolean deleteOne(CustomerModel customerModel) {

SQLiteDatabase db = this.getWritableDatabase();
String queryString = "DELETE FROM CUSTOMER_TABLE" + " WHERE " + COLUMN_ID + "=" + customerModel.getId();
Cursor cursor = db.rawQuery(queryString, null);

if (cursor.moveToFirst()) {
return true;
} else {
return false;
}
}

 

[James_Watson]

I think you had better use 'try - catch - finally' to catch exceptions in db operation.

 

[brentc]

If I implement a Toast like this....

Toast.maketext(MainActivity.this, "Hello", Toast.LENGTH_LONG).show();

It flags MainActivity.this with the error "is not an enclosing class". What should I use for that?

 

[brentc]

The Toast is in a class called DataBaseHelper. But that gets an error too...

 

[brentc]

System.out.println("Error") does not print to the terminal