jeudi 8 octobre 2015

Fetch data from SQLite to new class

I'm still new to android development and now facing problem on fetching data from SQLite to another class by using intent. I have read a lot of documentation but still failing to attain the desired results. There are no data display on DisplayData.java. Have I missed out anything??? Below are my coding snippet.

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);
                    startActivity(intent);
 }

                });
                builder.setNegativeButton("Cancel", new DialogInterface.OnClickListener() {
                    public void onClick(DialogInterface dialog, int ii) {
                        dialog.dismiss();
                    }
                });
                builder.show();


            }
        });
    }

DisplayData.java

public class DisplayData extends AppCompatActivity {
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.displaydata);
        setRequestedOrientation(ActivityInfo.SCREEN_ORIENTATION_LANDSCAPE);
        final String name1 = getIntent().getExtras().getString("name");
        if(name1=="Lim X Y")
        {
            SQLiteDatabase db=(new MyDatabaseHelper(this)).getReadableDatabase();
            Cursor cursor=db.rawQuery("SELECT weather,date,status FROM Information WHERE name = ?",new String[]{""+name1});
            if(cursor.getCount()==1)
            {
                cursor.moveToFirst();
                cursor.getString(cursor.getColumnIndex("weather"));
                cursor.getString(cursor.getColumnIndex("date"));
                cursor.getString(cursor.getColumnIndex("status"));

            }

        }

    }
}

displaydata.xml

<?xml version="1.0" encoding="utf-8"?>
<ScrollView xmlns:android="http://ift.tt/nIICcg"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content">

    <LinearLayout
        android:orientation="vertical"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content">

        <HorizontalScrollView
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_marginTop="15dp" >

            <TableLayout

                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
                android:stretchColumns="|"

                android:layout_marginBottom="25dp">


                <TableRow
                    android:layout_width="match_parent"
                    android:layout_height="match_parent"
                    android:id="@+id/tableRow1">



                    <TextView
                        android:layout_width="wrap_content"
                        android:layout_height="wrap_content"
                        android:id="@+id/textView10"
                        android:background="@drawable/cell_shape"
                        android:textSize="17sp"
                        android:text="weather"/>

                    <TextView android:id="@+id/textView111"
                        android:layout_width="wrap_content"
                        android:layout_height="wrap_content"
                        android:textSize="17sp"
                        android:background="@drawable/cell_shape"
                        android:text="date"/>

                    <TextView android:id="@+id/textView11"
                        android:layout_width="wrap_content"
                        android:layout_height="wrap_content"
                        android:textSize="17sp"
                        android:background="@drawable/cell_shape"
                        android:text="status"/>



    </TableRow>
    </TableLayout>
    </HorizontalScrollView>
    </LinearLayout>
    </ScrollView>

Aucun commentaire:

Enregistrer un commentaire