Android Open Source - sqlite Cursor Adapter_ Fragment

From Project

Back to project page sqlite.

License

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.

Java Source Code

package edu.cs4730.sqlitedemo;
/*from  www . j ava 2s  .  c  o  m*/
import android.app.Activity;
import android.content.Context;
import android.database.Cursor;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;
import android.support.v4.app.Fragment;
import android.support.v4.widget.SimpleCursorAdapter;
import android.widget.TextView;
import android.widget.Toast;
/*
 * http://www.mysamplecode.com/2012/07/android-listview-cursoradapter-sqlite.html
 */
public class CursorAdapter_Fragment extends Fragment {
  String TAG = "cursorAdapter_frag";
  Context myContext;


  TextView output;
  ScoreDatabase db;
  private SimpleCursorAdapter dataAdapter;


  public CursorAdapter_Fragment() {
    // Required empty public constructor
  }

  @Override
  public View onCreateView(LayoutInflater inflater, ViewGroup container,
      Bundle savedInstanceState) {
    // Inflate the layout for this fragment
    View myView =  inflater.inflate(R.layout.cursoradapter_fragment, container, false);
    output = (TextView) myView.findViewById(R.id.textView1);

    db = new ScoreDatabase(myContext);
    db.open();  //if database doesn't exist, it has now created.

    Cursor cursor = db.getAllNames();

    if (cursor == null) {
      Log.i("CAA", "cursor is null...");
    }

    // The desired columns to be bound
    String[] columns = new String[] {
        mySQLiteHelper.KEY_NAME,
        mySQLiteHelper.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.highscore,
        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);

        // display the name in a toast.
        String name = cursor.getString(cursor.getColumnIndexOrThrow(mySQLiteHelper.KEY_NAME));
        Toast.makeText(myContext,
            name, Toast.LENGTH_SHORT).show();

      }
    });
    return myView;

  }
  
  
    @Override
  public void onResume() {
      super.onResume(); 
     if (db == null) 
        db = new ScoreDatabase(myContext);
     if (!db.isOpen())
       db.open();
    }
    @Override
  public void onPause() {
      super.onPause();
      if (db.isOpen())
        db.close();
 
    }
  
  @Override
  public void onAttach(Activity activity) {
    super.onAttach(activity);
    myContext = activity.getApplicationContext();
    Log.d(TAG,"onAttach");
  }
}

Java Source Code List