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 referred 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;

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;
        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);
        database = dbHelper.getWritableDatabase();
        c = database.rawQuery("SELECT w.Subcontractors, w.NumberOfPerson, w.NumberOfHours FROM Information i LEFT JOIN WorkForce w ON w.TInfo_id = i.ID WHERE i.Name = ? AND i.Date= ? ",
                new String[]{String.valueOf(name2),String.valueOf(date2)}, null);
        if (c != null) {
            c.moveToFirst();
            while (c.moveToNext()) {
                Info I = new Info();
                Details WD = new Details();

               // String Weather = c.getString(c.getColumnIndexOrThrow(MyDatabaseHelper.Weather));
                //String Status = c.getString(c.getColumnIndexOrThrow(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));
                Force WF = new Force();
                WF.setSubcontractors(SubC);
                WF.setNoOfPerson(NoP);
                WF.setNoOfHours(NoH);
                subC3.setText(SubC);
                noP.setText(NoP);
                noH.setText(NoH);

            }

        }
        c.close();


    }
    }

Force.java

public class Force {

    private int id1;
    private String subcontractors;
    private String noOfPerson;
    private String noOfHours;

    public void setID(int  id1)
    {
        this.id1=id1;
    }

    public int getID()
    {
        return this.id1;
    }

    public void setSubcontractors(String subcontractors)
    {
        this.subcontractors=subcontractors;
    }

    public String getSubcontractors()
    {
        return this.subcontractors;
    }

    public void setNoOfPerson(String noOfPerson)
    {
        this.noOfPerson=noOfPerson;
    }

    public String getNoOfPerson()
    {
        return this.noOfPerson;
    }

    public void setNoOfHours(String noOfHours)
    {
        this.noOfHours=noOfHours;
    }

    public String getNoOfHours()
    {
        return this.noOfHours;
    }



}

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

Aucun commentaire:

Enregistrer un commentaire