Android Open Source - sqlite sqlitedemo2 Frag

• Back to SQLite/example  ↑

From Project

Back to project page sqlite.

License

The source code is released under:

GNU General Public License

Java Source Code

package edu.cs4730.sqlitedemo2;
//w  w  w .  ja  v  a 2s  .  co m
import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.net.Uri;
import android.os.Bundle;
import android.provider.ContactsContract;
import android.support.v4.app.Fragment;
import android.support.v4.widget.SimpleCursorAdapter;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.ListView;
import android.widget.Toast;
import android.widget.AdapterView.OnItemClickListener;

public class sqlitedemo2Frag extends Fragment {


  String TAG = "sqldemo2_frag";
  Context myContext;
  Cursor cursor;
  private SimpleCursorAdapter dataAdapter;


  @Override
  public View onCreateView(LayoutInflater inflater, ViewGroup container,
      Bundle savedInstanceState) {
    View myView = inflater.inflate(R.layout.sqlitedmeo2frag, container, false);

    //get the people URI
    Uri CONTENT_URI = Uri.parse("content://edu.cs4730.scoreprovider/score");
    //setup the information we want for the contentprovider.
    String[] projection = new String[] { MainActivity.KEY_ROWID, MainActivity.KEY_NAME, MainActivity.KEY_SCORE};

    //just for fun, sort return data by name, which instead of default which is _ID I think.
    String SortOrder = MainActivity.KEY_SCORE;  //"column name, column name"  except only have one column name.

    //finally make the query
    // cursor = managedQuery(CONTENT_URI, projection, null, null, null);  //depreicated method, use one below.
    cursor = getActivity().getContentResolver().query(CONTENT_URI, projection, null, null, SortOrder);

    //this is commented out, because better using a listview, which is what displayListView() does.
    //      if (c.moveToFirst()) {
    //       do {
    //         String str = "Id: " + c.getString(0);
    //         str += "Name: " + c.getString(1);
    //       } while (c.moveToNext());
    //     }
    if (cursor == null) {
      Log.i("CAA", "cursor is null...");
    }

    // The desired columns to be bound
    String[] columns = new String[] {
        MainActivity.KEY_NAME,
        MainActivity.KEY_SCORE
    };

    // the XML defined views which the data will be bound to
    int[] to = new int[] {
        R.id.name,
        R.id.score
    };

    // create the adapter using the cursor pointing to the desired data
    //as well as the layout information
    dataAdapter = new SimpleCursorAdapter(
        myContext, R.layout.scorelist,
        cursor,
        columns,
        to,
        0);

    ListView listView = (ListView) myView.findViewById(R.id.listView1);
    // Assign adapter to ListView
    listView.setAdapter(dataAdapter);


    listView.setOnItemClickListener(new OnItemClickListener() {
      @Override
      public void onItemClick(AdapterView<?> listView, View view,
          int position, long id) {
        // Get the cursor, positioned to the corresponding row in the result set
        Cursor cursor = (Cursor) listView.getItemAtPosition(position);

        // Should really create a dialogfragment and display all the contact info here.  but I'll get to that 
        // when I have time.
        String name = cursor.getString(cursor.getColumnIndexOrThrow(ContactsContract.Contacts.DISPLAY_NAME));
        Toast.makeText(myContext,   name, Toast.LENGTH_SHORT).show();

      }
    });

    return myView;
  }




  @Override
  public void onAttach(Activity activity) {
    super.onAttach(activity);
    myContext = activity.getApplicationContext();
    Log.d(TAG,"onAttach");
  }


}

Java Source Code List

• Back to SQLite/example  ↑