Minibank #2

Buat jPanel dan beri nama "Nasabah"

Buat tampilan seperti ini:

Coding:

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

private Vector<Vector<String>> db = new Vector();

    public lihat_nasabah() {
        initComponents();
        bacaData();
        norek();

    }

    private void bacaData() {
        db.removeAll(db);
        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "Select * from saldo";
            ResultSet r = s.executeQuery(sql);
            String tem;
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("nama_cs");
                o[1] = r.getString("no_rek");
                Vector<String> tmp2 = new Vector();
                tmp2.add((String) o[0]);
                tmp2.add((String) o[1]);
                db.add(tmp2);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

    public void norek() {
        int op = cb1.getItemCount();
        cb1.removeAllItems();
        for (int i = 0; i < db.size(); i++) {
            cb1.addItem(db.get(i).get(1));
        }
    }

    public void simpan() {
        try {
            String rek = "'" + cb1.getSelectedItem().toString() + "'";
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "SELECT * from saldo where no_rek=" + rek;
            ResultSet r = s.executeQuery(sql);
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("no_rek");
                o[1] = r.getString("nama_cs");
                o[2] = r.getString("jum_saldo");

                nama.setText(o[1].toString());
                nor.setText(o[0].toString());
                sal.setText(o[2].toString());
            }

            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

     public void simpan1() {
        try {
            String rek = "'" + cb1.getSelectedItem().toString() + "'";
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "SELECT * from customer where no_rek=" + rek;
            ResultSet r = s.executeQuery(sql);
            while (r.next()) {
                Object[] o = new Object[5];
                o[0] = r.getString("status");
                o[1] = r.getString("jenis");
               
                st.setText(o[1].toString());
                jt.setText(o[0].toString());
            }

            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        simpan(); simpan1();
    }