How is advised to use the contentResolver's delete method to be injection safe?

Question

You can delete with content resolver by URI or by passing some parameters to the where parameter.

How do you make the parameters to be SQL Injection Safe?
Is it possible to use Prepared Statements with ContentResolver?

act.getContentResolver().delete(myuriwithid,null,null);

act.getContentResolver().delete(mybaseuri," name = '"+this.name"'",null);

Huntley

Answer 1

Use positional parameters.

public final int delete (Uri url, String where, String[] selectionArgs)

e.g.

ContentResolver cr = ...;
String where = "nameid=?";
String[] args = new String[] { "george" };
cr.delete( Stuff.CONTENT_URI, where, args );

Tract

I don't know. If you don't trust it, you can use SQLiteDatabase.execSQL( "delete .." ) and harden the query yourself. – Tract

By my tests it seems to be SQL injection safe, but I can't see it documented anywhere. – Brunner

I just found some useful info, look for "SQL injection" in this page: developer.android.com/training/contacts-provider/… – Brunner