[DROID] CRUD and Database Java

Posted by : Unknown Jumat, 15 Desember 2017

MainActivity.java

import android.content.ActivityNotFoundException;
import android.content.Intent;

import android.os.Bundle;

import android.view.View;
import android.widget.Button;
import android.widget.TextView;
import android.widget.Toast;

import com.mycompany.myapp.R;
import android.app.*;

public class MainActivity extends Activity {

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);{

Button btnCall = (Button) findViewById(R.id.button1);

btnCall.setOnClickListener(new Button.OnClickListener() {
public void onClick(View v) {
Intent intent = new Intent(MainActivity.this,SimpanData.class);

startActivity(intent);}});}}}

DATABASE.java

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
* Created by Riyan on 5/4/2017.
*/

public class DATABASE extends SQLiteOpenHelper {

public static final String NAMA_DATABASE = "Programmer.db";
public static final String NAMA_TABLE = "Programmer_table";

    public static final String COL_1 = "ID";
    public static final String COL_2 = "NAMA";
    public static final String COL_3 = "ALAMAT";
    public static final String COL_4 = "NO_CELANA";

    public DATABASE(Context context) {
        super(context, NAMA_DATABASE, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE " + NAMA_TABLE + " (ID INTEGER PRIMARY KEY AUTOINCREMENT , NAMA TEXT, ALAMAT TEXT, NO_CELANA INTEGER)");

}

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + NAMA_TABLE);
    }

    //untuk memanggil semua data yang sudah di isi atau di input sebelumnya.
    public Cursor getSemuaData() {
        SQLiteDatabase database = this.getWritableDatabase();
        //panggil dengan perintah (Select * from + nama tabelnya apa)
        Cursor res = database.rawQuery("Select * from " + NAMA_TABLE, null);
        return res;
    }

    //metode untuk input data, ID tidak perlu di input karna sudah Primary Key AutoIncrement agar ID tidak menimpa ID yang sudah ada.
    public boolean insertData(String nama, String alamat, String no_celana) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_2, nama);
        contentValues.put(COL_3, alamat);
        contentValues.put(COL_4, no_celana);
        long hasil = db.insert(NAMA_TABLE, null, contentValues);
        db.close();

        //memeriksa Data yang sudah di input di DataBase
        if (hasil == -1 ) {
            return false;
        } else {
            return true;
        }
    }

    //metode untuk memperbaharui data
    public boolean updateData(String id, String nama, String alamat, String no_celana) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COL_2, nama);
        contentValues.put(COL_3, alamat);
        contentValues.put(COL_4, no_celana);
        int hasil = db.update(NAMA_TABLE, contentValues, "ID=?",new String [] {id});
        db.close();

        //memeriksa kembali Data yang sudah di input di DataBase
        if (hasil > 0) {
            return true;
        } else {
            return false;
        }
    }
    //metode untuk menghapus dengan cukup memanggil nomor ID nya saja.
    public Integer hapusData(String id) {
        SQLiteDatabase database = this.getWritableDatabase();
        int kasian_dech_lu = database.delete(NAMA_TABLE, "ID=?", new String [] {id});
        return kasian_dech_lu ;

}
}

SimpanData.java

import android.content.Context;
import android.content.DialogInterface;
import android.database.Cursor;
import android.app.AlertDialog;
import android.app.Activity;
import android.os.Bundle;
import android.widget.Toolbar;
import android.view.LayoutInflater;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import com.mycompany.myapp.R;
import android.content.*;

public class SimpanData extends Activity {
DATABASE dbSaya;
EditText edtTeksNama, edtTeksAlamat, edtTeksNoCelana;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.simpan);

edtTeksNama = (EditText) findViewById(R.id.nama);
edtTeksAlamat = (EditText) findViewById(R.id.alamat);
edtTeksNoCelana = (EditText) findViewById(R.id.umur);
final Button btnMasukkan = (Button) findViewById(R.id.simpan);
btnMasukkan.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
dbSaya = new DATABASE(SimpanData.this);

String nama = edtTeksNama.getText().toString();
String alamat = edtTeksAlamat.getText().toString();
String no_celana = edtTeksNoCelana.getText().toString();
Boolean hasil = dbSaya.insertData(nama, alamat, no_celana);
if (hasil == true) {
Toast.makeText(getBaseContext(), "Data berhasil di input", Toast.LENGTH_SHORT).show();
} else if (hasil == false ) {
Toast.makeText(getBaseContext(), "Data gagal di input", Toast.LENGTH_SHORT).show();
}
}
});

Button btnCall = (Button) findViewById(R.id.view);

btnCall.setOnClickListener(new Button.OnClickListener() {
public void onClick(View v) {
Intent intent = new Intent(SimpanData.this,TampilkanData.class);

startActivity(intent);}});
Button btnCall2 = (Button) findViewById(R.id.delete);

btnCall2.setOnClickListener(new Button.OnClickListener() {
public void onClick(View v) {
Intent intent = new Intent(SimpanData.this,HapusData.class);

startActivity(intent);}});

}

TampilkanData.java

public class TampilkanData extends Activity {
DATABASE dbSaya;
EditText edtTeksNama, edtTeksAlamat, edtTeksNoCelana;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.tampil);

/* Button btnTampilkanDataSql = (Button) findViewById(R.id.btnBacaTampil);
btnTampilkanDataSql.setOnClickListener(new View.OnClickListener() {
@Override

public void onClick(View v) {*/

final TextView textViewHadir = (TextView) findViewById(R.id.tampil);

final Button btnMunculHadirkan = (Button) findViewById(R.id.lihat);
btnMunculHadirkan.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
dbSaya = new DATABASE(TampilkanData.this);

Cursor res = dbSaya.getSemuaData();
StringBuffer stringBuffer = new StringBuffer();
if (res != null && res.getCount() > 0) {
while (res.moveToNext()) {
stringBuffer.append("ID: " + res.getString(0) + "\n");
stringBuffer.append("Nama: " + res.getString(1) + "\n");
stringBuffer.append("Alamat: " + res.getString(2) + "\n");
stringBuffer.append("No Celana: " + res.getString(3) + "\n" + "\n");
}
textViewHadir.setText(stringBuffer.toString());
Toast.makeText(getBaseContext(), "Data ada", Toast.LENGTH_SHORT).show();
} else {
Toast.makeText(getBaseContext(), "Data tidak ada", Toast.LENGTH_SHORT).show();
}
}
});
}
}

HapusData.java

public class HapusData extends Activity {
DATABASE dbSaya;
EditText edtTeksNama, edtTeksAlamat, edtTeksNoCelana;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.hapus);

/* Button btnHilangkan = (Button) findViewById(R.id.hapus);
btnHilangkan.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {*/

final EditText edhilangkan = (EditText) findViewById(R.id.tulis);

final Button btnHilangkan = (Button) findViewById(R.id.hapus);
btnHilangkan.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
dbSaya = new DATABASE(HapusData.this);

String id = edhilangkan.getText().toString();
int hasil = dbSaya.hapusData(id);

Toast.makeText(getBaseContext(), hasil+ "Data sudah dihapus :( ", Toast.LENGTH_SHORT).show();
}
});
};}

AndroidManifest.java

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://
schemas.android.com/apk/res/android"
package="com.mycompany.myapp" >
<application
android:allowBackup="true"
android:icon="@drawable/ic_launcher"
android:label="@string/app_name"
android:theme="@style/AppTheme" >
<activity
android:name=".MainActivity"
android:label="@string/app_name" >
<intent-filter>
<action
android:name="android.intent.action.MAIN" />
<category
android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity
android:name=".SimpanData"
android:label="@string/app_name" >
<intent-filter>
<action
android:name="android.intent.action.VIEW" />
<category
android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
<activity
android:name=".TampilkanData"
android:label="@string/app_name" >
<intent-filter>
<action
android:name="android.intent.action.VIEW" />
<category
android:name="android.intent.category.LAUNCHER" />

</intent-filter>
</activity>
<activity
android:name=".HapusData"
android:label="@string/app_name" >
<intent-filter>
<action
android:name="android.intent.action.VIEW" />
<category
android:name="android.intent.category.LAUNCHER" />

</intent-filter>
</activity>
</application>
</manifest>

Sekarang layout

main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_height="match_parent"
android:layout_width="match_parent"
android:orientation="vertical">

</LinearLayout>

Simpan.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
android:orientation="vertical"
android:background="#A5A5A5">