Back to project page sqlite.
The source code is released under:
GNU General Public License
If you think the Android project sqlite listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
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"); } }