Sum all the display values
<p>I need to perform sum the total of calories that display based on added food.
My design is like this:</p>

<pre><code>Breakfast

[EDITTEXT]

[BUTTON][TEXTVIEW] &lt;--display food name and calories

[BUTTON2][TEXTVIEW2]

[BUTTON3][TEXTVIEW3]

[BUTTON4][TEXTVIEW4]

[BUTTON5][TEXTVIEW5]
</code></pre>

<p>same thing repeat on Lunch and Dinner</p>

<p>In the end, i would like to have a TEXTVIEW to show the total amount of calories based on added food.</p>

<p>Anyone know how to do so?</p>

<p>Here is my code:</p>

<pre><code>public class MyFoodCalIntakeActivity extends Activity {

private Button breakfastSearchButton;
private Button breakfastSearchButton2;
private Button breakfastSearchButton3;
private Button breakfastSearchButton4;
private Button breakfastSearchButton5;

private Button lunchSearchButton;
private Button lunchSearchButton2;
private Button lunchSearchButton3;
private Button lunchSearchButton4;
private Button lunchSearchButton5;

private Button dinnerSearchButton;
private Button dinnerSearchButton2;
private Button dinnerSearchButton3;
private Button dinnerSearchButton4;
private Button dinnerSearchButton5;

private EditText breakfastEditText;
private EditText lunchEditText;
private EditText dinnerEditText;

private TextView breakfastTextView1;
private TextView breakfastTextView2;
private TextView breakfastTextView3;
private TextView breakfastTextView4;
private TextView breakfastTextView5;

private TextView lunchTextView1;
private TextView lunchTextView2;
private TextView lunchTextView3;
private TextView lunchTextView4;
private TextView lunchTextView5;

private TextView dinnerTextView1;
private TextView dinnerTextView2;
private TextView dinnerTextView3;
private TextView dinnerTextView4;
private TextView dinnerTextView5;

private DatabaseHelper dbHelper = new DatabaseHelper(MyFoodCalIntakeActivity.this,"food",2);

/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.food_calorie_intake);

    。。。

class breakfastSearchButtonListener implements OnClickListener, android.view.View.OnClickListener
{
public void onClick(View v) 
{
    if (v.getId() == R.id.breakfastSearchButton) {

    String display = "";
    SQLiteDatabase db = dbHelper.getWritableDatabase();
    /** the result will be loaded in cursor **/
    Cursor cursor = db.query("food_table", new String[]{"ID","name","calorie"}, null, null, null, null, null);

    while(cursor.moveToNext())
    {

        String name = cursor.getString(cursor.getColumnIndex("name"));
        String calorie = cursor.getString(cursor.getColumnIndex("calorie"));


        if (name.compareTo(breakfastEditText.getText().toString())==0){
            display = display +"Name: "+name+", Calorie: "+calorie;
            breakfastTextView1.setText(display);
        }
    }
}
}

public void onClick(DialogInterface dialog, int which) 
{
    // TODO Auto-generated method stub  
}

} // end activity
</code></pre>

<p>please bear with me, the code is little bit longer.</p>
