Please Help Me...How can the data display to the specific column??? I don't want the data display as Toast, but I want data display as row...How can I do to achieve this? I really have no idea. Any suggestions would be greatly appreciated.
WorkDetailsTable.Java
Button btn1=(Button)findViewById(R.id.button2);
btn1.setOnClickListener(new View.OnClickListener() {
public void onClick(View arg0) {
AlertDialog.Builder builder=new AlertDialog.Builder(WorkDetailsTable.this);
builder.setTitle("Data Saved");
builder.setMessage("Are you sure you want to save?");
builder.setIcon(android.R.drawable.ic_dialog_alert);
builder.setPositiveButton("Yes", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int ii) {
long ab = ts.insertTimeSheet(name, weather, date, status);
Toast.makeText(context, "Data Saved", Toast.LENGTH_SHORT).show();
Intent intent=new Intent(WorkDetailsTable.this,DisplayData.class);
intent.putExtra("name",name); // pass name to DisplayData
startActivity(intent);
});
DisplayData.java
public class DisplayData extends AppCompatActivity {
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.displaydata);
MyDatabaseHelper db=new MyDatabaseHelper(this);
InfoAPI I1=new InfoAPI(this);
setRequestedOrientation(ActivityInfo.SCREEN_ORIENTATION_LANDSCAPE);
final String name1 = getIntent().getExtras().getString("name");
Toast.makeText(getApplicationContext(), name1, Toast.LENGTH_SHORT).show();
if (name1.equals("X Y Z")) ;
{
Log.d("Reading: ", "Reading all contacts..");
List<Info> info=I1.getAllContacts(name1); //refer to InfoAPI
for(Info in:info)
{
String
log="Weather:"+in.getWeather()+",Date:"+in.getDate()+"Status:"+in.getStatus();
Log.d("Name: ", log);
// Toast.makeText(getApplicationContext(), log, Toast.LENGTH_SHORT).show();
// what should write so data can be displayed in certain manner?
}
}
}
}
InfoAPI.java
public List<Info> getAllContacts(String name) {
List<Info> contactList = new ArrayList<Info>();
String selectQuery = ("SELECT Weather,Date,Status FROM "+MyDatabaseHelper.TABLE_INFO);
database=dbHelper.getWritableDatabase();
Cursor cursor = database.query(MyDatabaseHelper.TABLE_INFO,new String[]{MyDatabaseHelper.ID,MyDatabaseHelper.Name,MyDatabaseHelper.Weather,MyDatabaseHelper.Date,MyDatabaseHelper.Status},MyDatabaseHelper.Name+"=?", new String[] { String.valueOf(name)}, null, null, null, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
Info contact = new Info(); //refer Info
contact.setWeather((cursor.getString(0)));
contact.setDate(cursor.getString(1));
contact.setStatus(cursor.getString(2));
contactList.add(contact);
} while (cursor.moveToNext());
}
// return contact list
return contactList;
}
Info.java
public class Info {
private int id;
private String name;
private String weather;
private String date;
private String status;
public Info() {
}
public void setStatus(String status)
{
this.status=status;
}
public String getStatus()
{
return this.status;
}
public void setID(int id)
{
this.id=id;
}
public int getID()
{
return this.id;
}
public void setName(String name) {
this.name = name;
}
public String getName() {
return this.name;
}
public void setWeather(String weather)
{
this.weather=weather;
}
public String getWeather()
{
return this.weather;
}
public void setDate(String date)
{
this.date=date;
}
public String getDate()
{
return this.date;
}
}
Data should be displayed in the second row
Aucun commentaire:
Enregistrer un commentaire