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


0 Komentar untuk "CRUD SEDERHANA BERBASIS ANDROID MENGGUNAKAN DATABASE SQLITE"

Silakan tinggalkan komentar anda. DILARANG KERAS menyimpan link blog/web pada komentar dengan tujuan backlink, Spam.

 
Copyright © 2014 Tutorial Kampus - All Rights Reserved
Template By. Catatan Info