Q0vJYxR0

1package xyz.arizalshop.sqliteproject;
2
3import java.util.ArrayList;
4import java.util.HashMap;
5import android.content.ContentValues;
6import android.content.Context;
7import android.database.Cursor;
8import android.database.sqlite.SQLiteDatabase;
9import android.database.sqlite.SQLiteOpenHelper;
10
11public class SQLiteHelper extends SQLiteOpenHelper {
12
13    private static final String nama_database = "database_pemain.db";
14    private static final int versi_database = 1;
15    private static final String query_buat_tabel_biodata_pemain = "CREATE TABLE IF NOT EXISTS tabel_biodata(id_biodata INTEGER PRIMARY KEY AUTOINCREMENT, nama TEXT,alamat TEXT)";
16    private static final String query_hapus_tabel_biodata_pemain = "DROP TABLE IF EXISTS query_buat_tabel_biodata_pemain";
17
18    public SQLiteHelper(Context context) {
19        super(context, nama_database, null, versi_database);
20    }
21
22    @Override
23    public void onCreate(SQLiteDatabase sqLiteDatabase) {
24        sqLiteDatabase.execSQL(query_buat_tabel_biodata_pemain);
25        System.out.println("tabel_biodata sudah dibuat");
26    }
27
28    @Override
29    public void onUpgrade(SQLiteDatabase database, int versi_lama, int versi_baru) {
30        database.execSQL(query_hapus_tabel_biodata_pemain);
31        onCreate(database);
32
33    }
34
35    public void tambah_biodata(String nama, String alamat) {
36        SQLiteDatabase database = this.getWritableDatabase();
37        ContentValues values = new ContentValues();
38        values.put("nama", nama);
39        values.put("alamat", alamat);
40        database.insert("tabel_biodata", null, values);
41        database.close();
42    }
43
44    public ArrayList<HashMap<String, String>> tampil_semua_biodata() {
45        SQLiteDatabase database = this.getWritableDatabase();
46
47        // deklarasikan sebuah arraylist yang bisa menampung hashmap
48        ArrayList<HashMap<String, String>> arrayListBiodata = new ArrayList<HashMap<String, String>>();
49
50        Cursor cursor = database.rawQuery("SELECT * FROM tabel_biodata", null);
51
52        // kursor langsung diarkan ke posisi paling awal data pada tabel_biodata
53        if (cursor.moveToFirst()) {
54            do {
55                // deklarasikan sebuah hashmap, yang bisa menamp
56                HashMap<String, String> hashMapBiodata = new HashMap<String, String>();
57
58                // masukkan masing-masing field dari tabel_biodata ke dalamhashMapBiodata
59                // pastikan id_biodata, nama dan alamat sama persis dengan field yang ada pada tabel_biodata
60                hashMapBiodata.put("id_biodata", cursor.getString(0));
61                hashMapBiodata.put("nama", cursor.getString(1));
62                hashMapBiodata.put("alamat", cursor.getString(2));
63
64                // masukkan hashMapBiodata ke dalam arrayListBiodata
65                arrayListBiodata.add(hashMapBiodata);
66
67            } while (cursor.moveToNext());
68        }
69
70        return arrayListBiodata;
71    }
72
73    public int update_biodata(int id, String nama, String alamat) {
74        SQLiteDatabase database = this.getWritableDatabase();
75        ContentValues recordBiodata = new ContentValues();
76        recordBiodata.put("nama", nama);
77        recordBiodata.put("alamat", alamat);
78        return database.update("tabel_biodata", recordBiodata, "id_biodata=" + id, null);
79    }
80
81    public void hapus_biodata(int id) {
82        SQLiteDatabase database = this.getWritableDatabase();
83        database.execSQL("DELETE FROM  tabel_biodata WHERE id_biodata='" + id + "'");
84        database.close();
85    }
86
87    public HashMap<String, String> tampil_biodata_berdasarkan_id(int id) {
88        SQLiteDatabase database = this.getReadableDatabase();
89
90        HashMap<String, String> hashMapBiodata = new HashMap<String, String>();
91        Cursor cursor = database.rawQuery("SELECT * FROM tabel_biodata WHERE id_biodata=" + id + "", null);
92
93        if (cursor.moveToFirst()) {
94            do {
95                hashMapBiodata.put("id_biodata", cursor.getString(0));
96                hashMapBiodata.put("nama", cursor.getString(1));
97                hashMapBiodata.put("alamat", cursor.getString(2));
98            } while (cursor.moveToNext());
99        }
100        return hashMapBiodata;
101    }
102}