MyDBHandler.
java
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class MyDBHandler extends SQLiteOpenHelper {
private static final int DATABASE_VERSION = 1;
private static final String DATABASE_NAME = "[Link]";
private static final String Table_Mahasiswa = "Mahasiswa";
private static final String COLUMN_ID = "MahasiswaNPM";
private static final String COLUMN_NAME = "MahasiswaNama";
MyDBHandler(Context context)
{
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_Mahasiswa_TABLE = "CREATE TABLE " +
Table_Mahasiswa + "(" + COLUMN_ID + " INTEGER PRIMARY KEY," + COLUMN_NAME
+ " TEXT " + ")";
[Link](CREATE_Mahasiswa_TABLE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion,
int newVersion) {
[Link]("DROP TABLE IF EXISTS " + Table_Mahasiswa);
onCreate(db);
}
String loadHandler() {
String hasil = "";
String query = "Select*FROM " + Table_Mahasiswa;
SQLiteDatabase db = [Link]();
Cursor cursor = [Link](query, null);
while ([Link]()) {
int hasil_0 = [Link](0);
String hasil_1 = [Link](1);
hasil += [Link](hasil_0) + " " + hasil_1 +
[Link]("[Link]");
}
[Link]();
[Link]();
if([Link](""))
hasil="No Record Found";
return hasil;
}
long addHandler(Mahasiswa Mahasiswa) {
long id;
ContentValues values = new ContentValues();
[Link](COLUMN_ID, [Link]());
[Link](COLUMN_NAME, [Link]());
SQLiteDatabase db = [Link]();
id = [Link](Table_Mahasiswa, null, values);
[Link]();
return id;
}
boolean updateHandler(int ID, String name) {
SQLiteDatabase db = [Link]();
ContentValues args = new ContentValues();
[Link](COLUMN_ID, ID);
[Link](COLUMN_NAME, name);
return [Link](Table_Mahasiswa, args, COLUMN_ID + "=" + ID, null) > 0;
}
boolean deleteHandler(int ID) {
boolean hasil = false;
String query = "Select*FROM " + Table_Mahasiswa + " WHERE " + COLUMN_ID + " = '" +
[Link](ID) + "'";
SQLiteDatabase db = [Link]();
Cursor cursor = [Link](query, null);
Mahasiswa Mahasiswa = new Mahasiswa();
if ([Link]()) {
[Link]([Link]([Link](0)));
[Link](Table_Mahasiswa, COLUMN_ID + "=?",
new String[] {
[Link]([Link]())
});
[Link]();
hasil = true;
}
[Link]();
return hasil;
}
}
[Link]
public class Mahasiswa {
private int id;
private String MahasiswaNama;
Mahasiswa() {
}
Mahasiswa(int id, String MahasiswaNama) {
[Link] = id;
[Link] = MahasiswaNama;
}
void setID(int id) {
[Link] = id;
}
int getID() {
return [Link];
}
void setMahasiswaNama(String MahasiswaNama) {
[Link] = MahasiswaNama;
}
String getMahasiswaNama() {
return [Link];
}
}
main_activity.xml
<?xml version="1.0" encoding="utf-8"?>
<[Link]
xmlns:android="[Link]
xmlns:app="[Link]
xmlns:tools="[Link]
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity">
<LinearLayout
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity"
android:orientation="vertical" >
<EditText
android:id="@+id/npm"
android:layout_width="match_parent"
android:layout_height="0dp"
android:layout_weight="1"
android:ems="10"
android:inputType="number"
android:hint="NPM"
/>
<EditText
android:id="@+id/nama_mhs"
android:layout_width="match_parent"
android:layout_height="0dp"
android:layout_weight="1"
android:ems="10"
android:inputType="textPersonName"
android:hint="NAMA"
/>
<Button
android:layout_width="match_parent"
android:layout_height="0dp"
android:layout_weight="1"
android:text="TAMPIL SEMUA"
android:onClick="tampil_semua"
/>
<TextView
android:id="@+id/hasil"
android:layout_width="match_parent"
android:layout_height="0dp"
android:layout_weight="1"
android:hint="HASIL"
android:textSize="30dp"
/>
<Button
android:layout_width="match_parent"
android:layout_height="0dp"
android:layout_weight="1"
android:onClick="tambah_mhs"
android:text="TAMBAH" />
<Button
android:layout_width="match_parent"
android:layout_height="0dp"
android:layout_weight="1"
android:onClick="update_mhs"
android:text="UPDATE"
/>
<Button
android:layout_width="match_parent"
android:layout_height="0dp"
android:layout_weight="1"
android:onClick="hapus_mhs"
android:text="HAPUS"
/>
</LinearLayout>
</[Link]>
[Link]
package [Link].db_crud;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class MainActivity extends AppCompatActivity {
TextView hasilText;
EditText MahasiswaNPM;
EditText MahasiswaNama;
MyDBHandler dbHandler;
@Override
protected void onCreate(Bundle savedInstanceState) {
[Link](savedInstanceState);
setContentView([Link].activity_main);
hasilText = (TextView) findViewById([Link]);
MahasiswaNPM = (EditText) findViewById([Link]);
MahasiswaNama = (EditText) findViewById([Link].nama_mhs);
[Link](new ScrollingMovementMethod());
dbHandler= new MyDBHandler(this);
public void tampil_semua(View view) {
[Link]([Link]());
[Link]("");
[Link]("");
}
public void tambah_mhs (View view) {
if(![Link]().toString().isEmpty() && !
[Link]().toString().isEmpty()) {
int id = [Link]([Link]().toString());
String name = [Link]().toString();
Mahasiswa Mahasiswa = new Mahasiswa(id, name);
long insertId=[Link](Mahasiswa);
if(insertId==-1){
[Link]("Data sudah ada");
}
else{
[Link]("");
[Link]("");
[Link]("Data ditambahkan");
}
}
else{
[Link]("Masukan NPM dan Nama dengan benar");
}
}
public void update_mhs(View view) {
if( ![Link]().toString().isEmpty() && !
[Link]().toString().isEmpty()) {
boolean hasil = [Link]([Link](
[Link]().toString()), [Link]().toString());
if (hasil) {
[Link]("");
[Link]("");
[Link]("Data DIperbaharui");
} else {
[Link]("Tidak ada data ditemukan");
}
}
else{
[Link]("Masukan NPM dan Nama dengan benar");
}
}
public void hapus_mhs(View view) {
if(![Link]().toString().isEmpty()) {
boolean hasil = [Link]([Link](
[Link]().toString()));
if (hasil) {
[Link]("");
[Link]("");
[Link]("Data dihapus");
} else {
[Link]("Tidak ada data ditemukan");
}
} else{
[Link]("Masukan NPM dengan benar");
}
}
@Override
protected void onDestroy() {
[Link]();
[Link]();
}