TampilActivity.java

package notes.bapakkau;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import java.util.ArrayList;

public class TampilActivity extends Activity {
    private ArrayList<String> ListData;
    SQLiteDatabase db;
    ListView lv;
    Database sqlite;

    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.tampil);
        sqlite = new Database(this);
        lv = (ListView) findViewById(R.id.listView1);
        ListData = new ArrayList<String>();
        tampildata();
        lv.setAdapter(new ArrayAdapter(this, 17367043, this.ListData));
        lv.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            public void onItemClick(AdapterView<?> adapterView, View arg1, int arg2, long arg3) {
                String y = String.valueOf(arg2).toString();
                Intent i = new Intent(getBaseContext(), EditActivity.class);
                i.putExtra("Judul", y);
                startActivity(i);
            }
        });
    }

    public void tampildata() {
        Cursor cursor = this.sqlite.getReadableDatabase().rawQuery("SELECT * FROM catatan", (String[]) null);
        cursor.moveToFirst();
        for (int count = 0; count < cursor.getCount(); count++) {
            cursor.moveToPosition(count);
            ListData.add(cursor.getString(0));
        }
    }
}
//ig harymalau