Project List Buku Android Studio

[RandyLab]

https://drive.google.com/file/d/1DqbIII3AFlgNEc9vslt5pSqtdA0erVvP/view?usp=drivesdk

###List Buku Android Studio

• MainActivity.java

package com.example.databasesqllite;

import androidx.appcompat.app.AppCompatActivity;

import android.annotation.SuppressLint;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.ListView;
import android.widget.Toast;

import java.util.ArrayList;

public class MainActivity extends AppCompatActivity {

    public static Object ma;
    Button button;
    ListView listView;
    ArrayList listItem;
    ArrayAdapter adapter;
    sql dbHelper;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        // Inisialisasi database helper
        dbHelper = new sql(this);
        listView = findViewById(R.id.listBuku);
        listItem = new ArrayList<>();

        tampilkanData();

        Button tombolAdd = findViewById(R.id.buttonAddNav);
        tombolAdd.setOnClickListener(v -> {
            Intent intent = new Intent(MainActivity.this, add.class);
            startActivity(intent);
        });

        Button tombolEdit = findViewById(R.id.buttonEditNav);
        tombolEdit.setOnClickListener(v -> {
            Intent intent = new Intent(MainActivity.this, edit.class);
            startActivity(intent);
        });
    }

    @SuppressLint("Range")
    private void tampilkanData() {
        Cursor cursor = dbHelper.getAllData();
        listItem.clear(); // Bersihkan list sebelum diisi ulang

        if (cursor.getCount() == 0) {
            Toast.makeText(this, "Tidak ada data!", Toast.LENGTH_SHORT).show();
            return;
        }

        while (cursor.moveToNext()) {
            listItem.add(cursor.getString(cursor.getColumnIndex("judul_buku")));
        }

        adapter = new ArrayAdapter<>(this, android.R.layout.simple_list_item_1, listItem);
        listView.setAdapter(adapter);
        adapter.notifyDataSetChanged(); // Memastikan ListView diperbarui
    }
}

• sql.java

package com.example.databasesqllite;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class sql extends SQLiteOpenHelper{
    private static final String DATABASE_NAME = "db.db";
    private  static final int DATABASE_VERSION = 1;

    public sql(Context context){
        super(context,DATABASE_NAME,null,DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db){
        String sql = "create table buku ( id integer primary key autoincrement, judul_buku text null, "+ "nama_pengarang text null, tahun_terbit text null, penerbit text null);";
        Log.d("Data","onCreate: "+sql);
        db.execSQL(sql);
        sql = "INSERT INTO buku (id, judul_buku, nama_pengarang, tahun_terbit, penerbit) Values(1,'Penerapan Sistem','Jogiyanto','2010','Andi');";
        db.execSQL(sql);
        sql = "INSERT INTO buku (id, judul_buku, nama_pengarang, tahun_terbit, penerbit) Values(2,'Pengantar TI','Sutarman','2012','Bumi Aksara');";
        db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }


    public Cursor getAllData() {
        SQLiteDatabase db = this.getReadableDatabase();
        return db.rawQuery("SELECT * FROM buku", null);
    }
}

[RandyLab]

https://drive.google.com/file/d/1DqbIII3AFlgNEc9vslt5pSqtdA0erVvP/view?usp=drivesdk