MainActivity.java

package org.francho.unutopia_android.persistencia;

import org.francho.unutopia_android.persistencia.db.MembersContract.UsersTable;
import org.francho.unutopia_android.persistencia.db.MyDbHelper;

import android.app.ListActivity;
import android.content.ContentValues;
import android.content.Context;
import android.content.SharedPreferences;
import android.content.SharedPreferences.Editor;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.widget.SimpleCursorAdapter;

public class MainActivity extends ListActivity {

    private SimpleCursorAdapter adapter;

	@Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        // setContentView(R.layout.activity_main);
        
        // getFilesDir();
        // getCacheDir();
        // getExternalCacheDir();
        // getExternalFilesDir(type);
 
        final MyDbHelper helper = new MyDbHelper(this);
        final SQLiteDatabase db = helper.getWritableDatabase();
        
        ContentValues values = new ContentValues();
        values.put(UsersTable.EMAIL, "pepe@super.man");
        values.put(UsersTable.USERNAME, "Pepe");
        
		long id = db.insert(UsersTable.TABLE_NAME, null, values );
		db.close();
		

		Context context = this;
		int layout = android.R.layout.simple_list_item_2;
		Cursor c = null;
		String[] from = new String[] { UsersTable.USERNAME, UsersTable.EMAIL };
		int[] to = new int[]{android.R.id.text1, android.R.id.text2 };
		int flags = SimpleCursorAdapter.FLAG_REGISTER_CONTENT_OBSERVER;
		
		adapter = new SimpleCursorAdapter(context, layout, c, from, to, flags);
		setListAdapter(adapter);

    }

	protected void onStart() {
		super.onStart();
		
		adapter.changeCursor(getUsers());
	}

	protected void onStop() {
		adapter.changeCursor(null);
		
    		super.onStop();
	}

	private Cursor getUsers() {
		MyDbHelper helper = new MyDbHelper(this);
		SQLiteDatabase db = helper.getReadableDatabase();
		
		String table = UsersTable.TABLE_NAME;
		String[] columns = new String[] { UsersTable._ID, UsersTable.USERNAME, UsersTable.EMAIL };
		String selection = null;
		String[] selectionArgs = null;
		String orderBy = UsersTable.USERNAME + " DESC";
		String groupBy = null;
		String having = null;
		return db.query(table, columns, selection, selectionArgs, groupBy, having, orderBy);
		}

	protected void onResume() {
		super.onResume();
	
		SharedPreferences prefs = getSharedPreferences("MisPrefs", MODE_PRIVATE);
        
		int counter = prefs.getInt("COUNTER", 0);
        counter++;
        
        Editor editor = prefs.edit();
        editor.putInt("COUNTER", counter);
        editor.commit();
        
        Log.d("Counter", ""+counter);
    }

    public boolean onCreateOptionsMenu(Menu menu) {
        getMenuInflater().inflate(R.menu.activity_main, menu);
        return true;
    }
}