EditActivity.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.Button;
import android.widget.EditText;
import android.widget.Toast;

public class EditActivity extends Activity {
    Cursor cursor;
    SQLiteDatabase db;
    Button edit, hapus;
    EditText isi, judul;
    Database sqlite, sqlite2;


    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.edit);
        judul = (EditText) findViewById(R.id.edjudul);
        isi = (EditText) findViewById(R.id.edisi);
        edit = (Button) findViewById(R.id.btnedit);
        hapus = (Button) findViewById(R.id.btnhapus);
        String x = getIntent().getStringExtra("Judul");
        sqlite = new Database(this);
        cursor =sqlite.getReadableDatabase().rawQuery("Select*from catatan limit " + x + ",1", (String[]) null);
        cursor.moveToFirst();
        judul.setText(cursor.getString(0));
        isi.setText(cursor.getString(1));
        sqlite2 = new Database(this);
        edit.setOnClickListener(new View.OnClickListener() {
            public void onClick(View arg0) {
                sqlite2.getWritableDatabase().execSQL("update catatan set isi='" +isi.getText().toString() + "' where judul ='"
                		+ judul.getText().toString() + "'");
                Toast.makeText(EditActivity.this.getBaseContext(), "Data Berhasil Terupdate", 0).show();
                startActivity(new Intent(getApplicationContext(), MenuActivity.class));
                finish();
            }
        });
        hapus.setOnClickListener(new View.OnClickListener() {
            public void onClick(View arg0) {
                sqlite2.getWritableDatabase().execSQL("Delete from catatan where judul ='"
                +judul.getText().toString() + "'");
                Toast.makeText(getBaseContext(), "Data Berhasil Terhapus", 0).show();
                startActivity(new Intent(getApplicationContext(), MenuActivity.class));
                finish();
            }
        });
    }
}
// ig harymalau