vendredi 16 octobre 2015

How to pass retrieved data to editText?

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..

UpdateDetails.java

package com.example.project.project;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.widget.EditText;
import android.widget.Spinner;
import android.widget.Toast;

import com.example.project.project.API.InfoAPI;
import com.example.project.project.TimeSheet.Details;
import com.example.project.project.TimeSheet.Force;
import com.example.project.project.TimeSheet.Info;
import com.example.project.project.database.MyDatabaseHelper;

/**
 * Created by tongws on 10/15/2015.
 */
public class UpdatePage extends AppCompatActivity {
    InfoAPI sqlcon;
    private SQLiteDatabase database;
    private MyDatabaseHelper dbHelper;
    private Cursor c;


    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        dbHelper = new MyDatabaseHelper(this);
        setContentView(R.layout.updatepage);
        final String name1 = getIntent().getExtras().getString("name");
        final String date = getIntent().getExtras().getString("date");
        RetrievePage(name1, date);
    }


    public void RetrievePage(String name, String date) {
        final String name2 = name;
        final String date2 = date;
        database = dbHelper.getWritableDatabase();
         c = database.rawQuery("SELECT  i.Name, i.Date, i.Status, i.Weather, w.Subcontractors, w.NumberOfPerson, w.NumberOfHours 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 = ? AND i.Date= ? ",
                 new String[]{String.valueOf(name2),String.valueOf(date2)}, null);
        final EditText name3 = (EditText) findViewById(R.id.editText9);
        final EditText date3 = (EditText) findViewById(R.id.editText12);
        name3.setText(name2);
        date3.setText(date2);
        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);
        if (c != null) {
            c.moveToFirst();
            while (c.moveToNext()) {
                Info I = new Info();
                Force WF = new Force();
                Details WD = new Details();

                String Weather = c.getString(c.getColumnIndex(MyDatabaseHelper.Weather));
                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.setWeather(Weather);
               // I.setStatus(Status);
                WF.setSubcontractors(SubC);
                WF.setNoOfPerson(NoP);
                WF.setNoOfHours(NoH);
                //WD.setProject(Project);


                subC3.setText(SubC);
                noP.setText(NoP);
                noH.setText(NoH);

            }

        }

    }
    }

Did I miss anything ? Please let me know! Any suggestions would be great. Thanks

Aucun commentaire:

Enregistrer un commentaire