How to use

bindValue

method

in

android.database.sqlite.SQLiteStatement

 SQLiteDatabase db = ...;
SQLiteStatement insert = db.compileStatement("INSERT INTO categories (yourcolumnnamehere) VALUES (?)");

//process each string
for (String category : getResources().getStringArray(R.array.categories)) 
{
  insert.bindValue(1, category);
  long id = insert.executeInsert(); // In case you care about the row id.
}

private static class DatabaseHelper extends SQLiteOpenHelper {
 ...
 // Replace 'yourcolumnnamehere' with whatever your column is actually named.
 private static final String INSERT_CATEGORY = "INSERT INTO categories (yourcolumnamehere) VALUES (?)"
 ...
 ...
 private final String[] mCategories;
 DatabaseHelper(Context context) {
   super(context, DATABASE_NAME, null, DATABASE_VERSION);
   mCategories = context.getResources().getStringArray(R.array.categories);
 }
 @Override
 public void onCreate(SQLiteDatabase db) {
   db.execSQL(DATABASE_CREATE);
   // Here you create the SQLiteStatement that will be used
   // to add categories. The values are stored in mCategories.
   SQLiteStatement statement = db.compileStatement(INSERT_CATEGORY);
   for (String category : mCategories) {
     statement.bindValue(1, category);
     statement.executeInsert();
   }
   statement.close();
   db.execSQL(EXPENSES_CREATE);
   db.execSQL(INCOMES_CREATE);
   db.execSQL(BUGS_CREATE);            
 }