CRUD SEDERHANA BERBASIS ANDROID MENGGUNAKAN DATABASE SQLITE

Perancangan Aplikasi

Aplikasi ini terdiri dari 5 Activity, sebagai berikut :

Buat
Buat digunakan untuk membuat data diri, yang terdiri dari nomor, nama, tanggal lahir, jenis kelamin, dan alamat.

DataHelper
DataHelper merupakan koneksi Sqlite dengan aplikasi.

Lihat
Lihat digunakan untuk melihat data yang sudah kita di BuatActivity

Main
Main Merupakan tata letak button didalam aplikasi, meliputi latar belakang, icon aplikasi, dll.

Update
Update digunakan untuk mengubah data yang sudah dibuat sebelumnya.

Source kode.

a.      BuatActivity

package com.example.server.uascrudsbd;

/**

 * Created by Server on 26/12/2017.

 */

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.support.v7.app.AppCompatActivity;

import android.view.Menu;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.Toast;

publicclass BuatActivity extends AppCompatActivity {

protected Cursor cursor;

    DataHelper dbHelper;

    Button ton1, ton2;

    EditText text1, text2, text3, text4, text5;

    @Override

protectedvoid onCreate(Bundle savedInstanceState){

super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_buat);

        dbHelper =new DataHelper(this);

        text1 =(EditText) findViewById(R.id.editText1);

        text2 =(EditText) findViewById(R.id.editText2);

        text3 =(EditText) findViewById(R.id.editText3);

        text4 =(EditText) findViewById(R.id.editText4);

        text5 =(EditText) findViewById(R.id.editText5);

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

        ton2 =(Button) findViewById(R.id.button2);

        ton1.setOnClickListener(new View.OnClickListener(){

            @Override

publicvoid onClick(View arg0){

// TODO Auto-generated method stub

                SQLiteDatabase db = dbHelper.getWritableDatabase();

                db.execSQL("insert into biodata(no, nama, tgl, jk, alamat) values('"+

                        text1.getText().toString()+"','"+

                        text2.getText().toString()+"','"+

                        text3.getText().toString()+"','"+

                        text4.getText().toString()+"','"+

                        text5.getText().toString()+"')");

                Toast.makeText(getApplicationContext(),"Sukses", Toast.LENGTH_LONG).show();

                MainActivity.ma.RefreshList();

                finish();

}

});

        ton2.setOnClickListener(new View.OnClickListener(){

            @Override

publicvoid onClick(View arg0){

// TODO Auto-generated method stub

                finish();

}

});

}

    @Override

publicboolean onCreateOptionsMenu(Menu menu){

// Inflate the menu; this adds items to the action bar if it is present.

        getMenuInflater().inflate(R.menu.main, menu);

returntrue;

}

}

b.      DataHelper

package com.example.server.uascrudsbd;

/**

 * Created by Server on 26/12/2017.

 */

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

import android.util.Log;

publicclass DataHelper extends SQLiteOpenHelper {

privatestaticfinal String DATABASE_NAME ="biodatadiri.db";

privatestaticfinalint DATABASE_VERSION =1;

public DataHelper(Context context){

super(context, DATABASE_NAME,null, DATABASE_VERSION);

// TODO Auto-generated constructor stub

}

    @Override

publicvoid onCreate(SQLiteDatabase db){

// TODO Auto-generated method stub

        String sql ="create table biodata(no integer primary key, nama text null, tgl text null, jk text null, alamat text null);";

        Log.d("Data","onCreate: "+ sql);

        db.execSQL(sql);

        sql ="INSERT INTO biodata (no, nama, tgl, jk, alamat) VALUES ('1234', 'Yopi Hidayat', '1998-03-25', 'Laki-laki','Bandung');";

        db.execSQL(sql);

}

    @Override

publicvoid onUpgrade(SQLiteDatabase arg0,int arg1,int arg2){

// TODO Auto-generated method stub

}

}

c.       LihatActivity

package com.example.server.uascrudsbd;

/**

 * Created by Server on 26/12/2017.

 */

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.support.v7.app.AppCompatActivity;

import android.view.Menu;

import android.view.View;

import android.widget.Button;

import android.widget.TextView;

publicclass LihatActivity extends AppCompatActivity {

protected Cursor cursor;

    DataHelper dbHelper;

    Button ton2;

    TextView text1, text2, text3, text4, text5;

    @Override

protectedvoid onCreate(Bundle savedInstanceState){

super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_lihat);

        dbHelper =new DataHelper(this);

        text1 =(TextView) findViewById(R.id.textView1);

        text2 =(TextView) findViewById(R.id.textView2);

        text3 =(TextView) findViewById(R.id.textView3);

        text4 =(TextView) findViewById(R.id.textView4);

        text5 =(TextView) findViewById(R.id.textView5);

        SQLiteDatabase db = dbHelper.getReadableDatabase();

        cursor = db.rawQuery("SELECT * FROM biodata WHERE nama = '"+

                getIntent().getStringExtra("nama")+"'",null);

        cursor.moveToFirst();

if(cursor.getCount()>0)

{

            cursor.moveToPosition(0);

            text1.setText(cursor.getString(0).toString());

            text2.setText(cursor.getString(1).toString());

            text3.setText(cursor.getString(2).toString());

            text4.setText(cursor.getString(3).toString());

            text5.setText(cursor.getString(4).toString());

}

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

        ton2.setOnClickListener(new View.OnClickListener(){

            @Override

publicvoid onClick(View arg0){

// TODO Auto-generated method stub

                finish();

}

});

}

    @Override

publicboolean onCreateOptionsMenu(Menu menu){

// Inflate the menu; this adds items to the action bar if it is present.

        getMenuInflater().inflate(R.menu.main, menu);

returntrue;

}

}

d.      MainActivity

package com.example.server.uascrudsbd;

/**

 * Created by Server on 26/12/2017.

 */

import android.app.AlertDialog;

import android.database.sqlite.SQLiteDatabase;import android.app.AlertDialog;

import android.content.DialogInterface;

import android.content.Intent;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.support.v7.app.AppCompatActivity;

import android.view.Menu;

import android.view.View;

import android.widget.AdapterView;

import android.widget.AdapterView.OnItemClickListener;

import android.widget.ArrayAdapter;

import android.widget.Button;

import android.widget.ListView;

import android.content.Intent;

publicclass MainActivity extends AppCompatActivity {

    String[] daftar;

    ListView ListView01;

    Menu menu;

protected Cursor cursor;

    DataHelper dbcenter;

publicstatic MainActivity ma;

    @Override

protectedvoid onCreate(Bundle savedInstanceState){

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);

        Button btn=(Button)findViewById(R.id.button2);

               btn.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View arg0) {

                // TODO Auto-generated method stub

                Intent inte = new Intent(MainActivity.this, BuatActivity.class);

                startActivity(inte);

            }

        });

        ma = this;

        dbcenter = new DataHelper(this);

        RefreshList();

    }

    public void RefreshList(){

        SQLiteDatabase db = dbcenter.getReadableDatabase();

        cursor = db.rawQuery("SELECT * FROM biodata",null);

        daftar = new String[cursor.getCount()];

        cursor.moveToFirst();

        for (int cc=0; cc < cursor.getCount(); cc++){

            cursor.moveToPosition(cc);

            daftar[cc] = cursor.getString(1).toString();

        }

        ListView01 = (ListView)findViewById(R.id.listView1);

        ListView01.setAdapter(new ArrayAdapter(this, android.R.layout.simple_list_item_1, daftar));

        ListView01.setSelected(true);

        ListView01.setOnItemClickListener(new OnItemClickListener() {

            public void onItemClick(AdapterView arg0, View arg1, int arg2, long arg3) {

                final String selection = daftar[arg2]; //.getItemAtPosition(arg2).toString();

                final CharSequence[] dialogitem = {"Lihat Biodata", "Ubah Biodata", "Hapus Biodata"};

                AlertDialog.Builder builder = new AlertDialog.Builder(MainActivity.this);

                builder.setTitle("Pilihan");

                builder.setItems(dialogitem, new DialogInterface.OnClickListener() {

                    public void onClick(DialogInterface dialog, int item) {

                        switch(item){

                            case 0 :

                                Intent i = new Intent(getApplicationContext(), LihatActivity.class);

                                i.putExtra("nama", selection);

                                startActivity(i);

                                break;

                            case 1 :

                                Intent in = new Intent(getApplicationContext(), UpdateActivity.class);

                                in.putExtra("nama", selection);

                                startActivity(in);

                                break;

                            case 2 :

                                SQLiteDatabase db = dbcenter.getWritableDatabase();

                                db.execSQL("delete from biodata where nama = '"+selection+"'");

                                RefreshList();

                                break;

                        }

                    }

                });

                builder.create().show();

            }});

        ((ArrayAdapter)ListView01.getAdapter()).notifyDataSetInvalidated();

    }

    @Override

    public boolean onCreateOptionsMenu(Menu menu) {

        // Inflate the menu; this adds items to the action bar if it is present.

        getMenuInflater().inflate(R.menu.main, menu);

        return true;

    }

}

e.       UpdateActivity

package com.example.server.uascrudsbd;

/**

 * Created by Server on 26/12/2017.

 */

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.support.v7.app.AppCompatActivity;

import android.view.Menu;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.Toast;

publicclass UpdateActivity extends AppCompatActivity {

protected Cursor cursor;

    DataHelper dbHelper;

    Button ton1, ton2;

    EditText text1, text2, text3, text4, text5;

    @Override

protectedvoid onCreate(Bundle savedInstanceState){

super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_update);

        dbHelper =new DataHelper(this);

        text1 =(EditText) findViewById(R.id.editText1);

        text2 =(EditText) findViewById(R.id.editText2);

        text3 =(EditText) findViewById(R.id.editText3);

        text4 =(EditText) findViewById(R.id.editText4);

        text5 =(EditText) findViewById(R.id.editText5);

        SQLiteDatabase db = dbHelper.getReadableDatabase();

        cursor = db.rawQuery("SELECT * FROM biodata WHERE nama = '"+

                getIntent().getStringExtra("nama")+"'",null);

        cursor.moveToFirst();

if(cursor.getCount()>0)

{

            cursor.moveToPosition(0);

            text1.setText(cursor.getString(0).toString());

            text2.setText(cursor.getString(1).toString());

            text3.setText(cursor.getString(2).toString());

            text4.setText(cursor.getString(3).toString());

            text5.setText(cursor.getString(4).toString());

}

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

        ton2 =(Button) findViewById(R.id.button2);

// daftarkan even onClick pada btnSimpan

        ton1.setOnClickListener(new View.OnClickListener(){

            @Override

publicvoid onClick(View arg0){

// TODO Auto-generated method stub

                SQLiteDatabase db = dbHelper.getWritableDatabase();

                db.execSQL("update biodata set nama='"+

                        text2.getText().toString()+"', tgl='"+

                        text3.getText().toString()+"', jk='"+

                        text4.getText().toString()+"', alamat='"+

                        text5.getText().toString()+"' where no='"+

                        text1.getText().toString()+"'");

                Toast.makeText(getApplicationContext(),"Berhasil", Toast.LENGTH_LONG).show();

                MainActivity.ma.RefreshList();

                finish();

}

});

        ton2.setOnClickListener(new View.OnClickListener(){

            @Override

publicvoid onClick(View arg0){

// TODO Auto-generated method stub

                finish();

}

});

}

    @Override

publicboolean onCreateOptionsMenu(Menu menu){

// Inflate the menu; this adds items to the action bar if it is present.

        getMenuInflater().inflate(R.menu.main, menu);

returntrue;

}}

PrintScreen Aplikasi ini kira-kira seperti ini.

Dede Heri         A2.1600037

Euis Endang         A2.1600060

Muhammad Thoyiban A2.1600108