Minibank #3

Buat JPanel dan beri nama "Lihat Transaksi"

Buat tampilan sperti ini:

Coding:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
import sql.konek;

public lihat_transaksi() {
        initComponents();
    }

    public void cari() {
        DefaultTableModel model = (DefaultTableModel) tdata.getModel();
        model.setRowCount(0);
        String Norek = norek.getText();
        String Nama = nama.getText();
        String Aw = aw.getText();
        String Ak = ak.getText();

        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "SELECT * FROM transaksi WHERE `no_rek`='" + Norek + "' AND `nama_cs`='" + Nama + "' AND DAY(tanggal) BETWEEN " + Aw + " AND " + Ak;
            ResultSet r = s.executeQuery(sql);
            while (r.next()) {
                Object[] o = new Object[4];
                o[0] = r.getString("tanggal");
                o[1] = r.getString("keterangan");
                o[2] = r.getString("nominal");
                o[3] = r.getString("nom_seb");
                model.addRow(o);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println("No Rekening atas nama " + Nama + " Tidak Ada");
            System.out.print(e.getMessage());
            JOptionPane.showMessageDialog(null, e);
        }
    }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        DefaultTableModel model = (DefaultTableModel) tdata.getModel();

        if (tdata.getRowCount() == 0) {
            cari();
        } else {
            cari();
        }

        if (tdata.getRowCount() == 0) {
            JOptionPane.showMessageDialog(null, "Transaksi Kosong!!! ");
        }
    }