How to find out the table ID in SQLite when the row is clicked? I have two tables, one is Info and another is WorkForce. I have implemented a tableListener in DisplayData.java. Everytime the row is pressed, it will retrieved all the information based on the name and ID by using this query
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.ID= ? ",
new String[]{String.valueOf(name2),String.valueOf(date2)}, null);
Table Info
ID Name Weather Date Status
---------- ---------- ---------- ---------- ----------
1 Paul Sunny 15/10 MC
2 Allen Rainy 15/10 Working
Table WorkForce
ID Subcontractors NumberOfPeople NumberOfHours TInfo_id
---------- -------------- ---------- ---------- -------
1 AAA 2 2 1
2 BBB 3 1 2
Assuming there are two row in DisplayData.java, which are the two row in Table Info. If the first row is pressed, it will retrieved all the information from table Info and Table WorkForce...
DisplayData.java
row.setOnClickListener(new View.OnClickListener() {
public void onClick(View v) {
Intent intent = new Intent(DisplayData.this, UpdatePage.class);
intent.putExtra("name", name);
// code for finding id in tableInfo
startActivity(intent);
}
});
Aucun commentaire:
Enregistrer un commentaire