Retrieve data from SQLite to editText/Text View

Good day everyone. Can someone tell me how can I retrieve the data from SQLite to editText? I have 3 tables and want to retrieve them out by using left-inner join. The SQL working fine just the data cannot be retrieved to editText. I refer to Android::Data are not retrieving to EditText field through Database but it not working for me..

UpdatePage.java

public class UpdatePage extends AppCompatActivity {
    InfoAPI sqlcon;
    private SQLiteDatabase database;
    private MyDatabaseHelper dbHelper;


    public void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.updatepage);
            final String name1 = getIntent().getExtras().getString("name2");
            final String date=getIntent().getExtras().getString("date2");
            RetrievePage(name1, date);
    }


   public void  RetrievePage(String name,String date)
    {
        final String name2 = name;
        final String date2=date;
        database=dbHelper.getWritableDatabase();
        Cursor c=database.rawQuery("SELECT  i.Date, i.Status, wd.TimeIn, wd.TimeOut, wd.TotalHours FROM Information i LEFT JOIN WorkForce w ON w.TInfo_id = i.ID LEFT JOIN WorkDetails wd ON wd.Twf_id = w.ID WHERE i.Name = ?", new String[]{String.valueOf(name)}, null);
        final EditText name3 = (EditText)findViewById(R.id.editText9);
        final EditText date3=(EditText)findViewById(R.id.editText12);
        final Spinner weather3=(Spinner)findViewById(R.id.spinner5);
        final Spinner status3=(Spinner)findViewById(R.id.spinner7);
        final EditText subC3=(EditText)findViewById(R.id.editText17);
        final EditText noP=(EditText)findViewById(R.id.editText18);
        final EditText noH=(EditText)findViewById(R.id.editText19);
        final Spinner poject3=(Spinner)findViewById(R.id.spinner8);
        while(c.moveToNext())
        {
            Info I=new Info(); //Info bean
            Force WF=new Force(); Force bean
            Details WD=new Details();  // Details bean

            String Name=c.getString(c.getColumnIndex(MyDatabaseHelper.Name));
            String Weather = c.getString(c.getColumnIndex(MyDatabaseHelper.Weather));
            String Date=c.getString(c.getColumnIndex(MyDatabaseHelper.Date));
            String Status = c.getString(c.getColumnIndex(MyDatabaseHelper.Status));
            String SubC = c.getString(c.getColumnIndex(MyDatabaseHelper.Subcontractors));
            String NoP = c.getString(c.getColumnIndex( MyDatabaseHelper.NumberOfPerson));
            String NoH = c.getString(c.getColumnIndex( MyDatabaseHelper.NumberOfHours));
            String Project=c.getString(c.getColumnIndex(MyDatabaseHelper.Project));

            I.setName(Name);
            I.setWeather(Weather);
            I.setDate(Date);
            I.setStatus(Status);
            WF.setSubcontractors(SubC);
            WF.setNoOfPerson(NoP);
            WF.setNoOfHours(NoH);
            WD.setProject(Project);

            name3.setText(c.getString(0));
            date3.setText(c.getString(2));
            subC3.setText(c.getString(4));


        }






    }

    }

I have 3 tables in my SQLite and 3 bean in my project. Do I need to use ArrayList ?

I've been stucked at here for more than two days, need seriously help...Someone can help me please...