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