package micka.haushaltsbuch;

import android.app.Activity;
import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.view.View;

public class Startseiteactivity extends Activity {
    final static String MY_DB_NAME = "FinanzenDB";
    final static String MY_DB_TABLE = "eintraege";
    final static String tag="ensacom"; 
    
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        SQLiteDatabase myDB = null;
        try {
            myDB = this.openOrCreateDatabase(MY_DB_NAME, MODE_PRIVATE, null);
            myDB.execSQL("CREATE TABLE IF NOT EXISTS tabellen"
                    + " (_id integer primary key autoincrement,"
                    + " tabellenname text not null)"
                    + ";");
            myDB.execSQL("INSERT INTO tabellen (tabellenname) "
                    +"VALUES('eintraege');");
        } finally {
             if (myDB != null)
                  myDB.close();
        }
        onCreateDBAndDBTabled();
        setContentView(R.layout.startseitelayout);
    }

    /** Erzeugt Menüeintrag beenden **/
    public static final int beenden_ID = Menu.FIRST;
    @Override
    public boolean onCreateOptionsMenu(Menu menu)
    {
        menu.add(0, beenden_ID, Menu.NONE, "beenden");
        return super.onCreateOptionsMenu(menu);
    }
    public boolean onOptionsItemSelected(MenuItem item)
    {
        switch(item.getItemId())
        {
        case beenden_ID: 
            finish();

        default:
            return super.onOptionsItemSelected(item);
        }
    }
    //ButtonFunktionen
    public void onClickEintragHinzufuegen(final View sfNormal) 
    {
        final Intent i = new Intent(this, EintragHinzufuegenActivity.class);
        startActivity(i);
    }
    public void onClickEintraegeAnzeigen(final View sfNormal) 
    {
        final Intent i = new Intent(this, TabellenAnzeigenActivity.class);
        startActivity(i);
    }
    /** Datenbank und Tabellen erstellen wenn noch nicht vorhanden */
    private void onCreateDBAndDBTabled()
    {
        SQLiteDatabase myDB = null;
        try {
            myDB = this.openOrCreateDatabase(MY_DB_NAME, MODE_PRIVATE, null);
            myDB.execSQL("CREATE TABLE IF NOT EXISTS " + MY_DB_TABLE
                    + " (_id integer primary key autoincrement,"
                    + " day integer(2), month integer(2),"
                    + " year integer(4), wofuer text not null,"
                    + " betrag real)"
                    +";");
        } finally {
             if (myDB != null)
                  myDB.close();
        }
    }
}

ContentResolver resolver = context.getContentResolver();
Uri uri = ContactsContract.StatusUpdates.CONTENT_URI;
String[] columns = new String[]{ ContactsContract.StatusUpdates.STATUS };
String where = ContactsContract.StatusUpdates.IM_HANDLE+"=?";
Cursor lastStatus = resolver.query(uri, columns, where, new String[]{clickedContact}, null);

 
String[] columns = new String[]{ ContactsContract.StatusUpdates.PRESENCE };

String[] columns = new String[]{ ContactsContract.StatusUpdates.PRESENCE, ContactsContract.StatusUpdates.STATUS };