Minibank #5

Buat JPanel dan beri nama "Setor"

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 sql.konek;

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

    public setor() {
        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.removeAllElements();
                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 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");
            }
        }
        System.out.println(sa.getText());

    }                                       

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

    public void Setor() {
        String norek = "'" + nrt.getText() + "',";
        String saldo = "'" + sa.getText() + "',";
        String jn = "'" + js.getText() + "',";
        String tg = "'" + tgl.getText() + "'";
        String nama = "'" + name.getText() + "',";
        String ket = "2,";

        int upsaldo = Integer.parseInt(sa.getText()) + Integer.parseInt(js.getText());
        String us = "" + upsaldo;
        try {
            Connection c = konek.getkoneksi();
            Statement stat = c.createStatement();
            try {
                String sql = "INSERT INTO transaksi( `no_rek`,`nama_cs` ,`nom_seb`,`nominal`,`keterangan`,`tanggal`) VALUES (" + norek + nama + 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();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        } catch (SQLException ex) {
        }

        bacaData();
        name.setText("Nama Tertanda");
        js.setText("");
        sa.setText(".....................................");
    }