Minibank #7

Buat JPanel dan beri nama "Transfer"

Buat tampilan sperti ini:

   

 

Coding:

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Vector;
import javax.swing.JOptionPane;
import sql.konek;

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

    public trasfer() {
        initComponents();
        bacaData();
        dat();
    }

    private void bacaData() {
        db.removeAll(db);
        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "Select * from saldo where `status`=1";
            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");
                o[2] = r.getString("jum_saldo");
                Vector<String> tmp2 = new Vector();
                tmp2.add((String) o[0]);
                tmp2.add((String) o[1]);
                tmp2.add((String) o[2]);
                db.add(tmp2);
            }
            r.close();
            s.close();
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
    }

    public void dat() {
        Calendar cal = Calendar.getInstance();
        SimpleDateFormat contoh4 = new SimpleDateFormat("yyyy-MM-dd");
        String Tanggal = contoh4.format(cal.getTime());
        tgl.setText(Tanggal);
    }

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        String norek = "'" + nrt.getText() + "',";
        String saldo = "'" + sa.getText() + "',";
        String jn = "'" + js.getText() + "',";
        String tg = "'" + tgl.getText() + "'";
        String ket = "3,";
        String notu = "'" + nr.getText() + "',";
        String nama = "'" + name.getText() + "',";

        int upsaldo = Integer.parseInt(sa.getText()) - Integer.parseInt(js.getText());
        String us = "" + upsaldo;
        if (Integer.parseInt(sa.getText()) > Integer.parseInt(js.getText())) {
            try {
                Connection c = konek.getkoneksi();
                Statement stat = c.createStatement();
                try {
                    String sql = "INSERT INTO transaksi( `no_rek`,`nama_cs` ,`no_rek_tujuan`,`nom_seb`,`nominal`,`keterangan`,`tanggal`) VALUES (" + norek + nama + notu + saldo + jn + ket + tg + ")";
                    String sql1 = "UPDATE `saldo` SET `jum_saldo` = '" + us + "' WHERE `no_rek` = '" + nrt.getText() + "';";
                    stat.execute(sql);
                    stat.execute(sql1);
                    stat.close();
                    stat.close();
                } catch (SQLException ex) {
                    System.out.println(ex);
                }
            } catch (SQLException ex) {
            }
        name.setText("Nama Tertanda");
        js.setText("");
        sa.setText(".....................................");
        nr.setText("");
        }else{
            JOptionPane.showMessageDialog(null, "Jumlah Saldo Anda Kurang!!!");
            nr.setText("");
        }
        bacaData();
    }                                       

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        bacaData();
        for (int i = 0; i < db.size(); i++) {
            if (nrt.getText().equals(db.get(i).get(1))) {
                System.out.print("ada");
                sa.setText(db.get(i).get(2));
                name.setText(db.get(i).get(0));
                break;
            } else {
                sa.setText("No Rekening Salah");
            }
        }
    }