Jumat, 24 Juni 2016

Minibank #6

Buat JPanel dan beri nama "Status Cs"


Buat tampilan sperti ini:

 

Coding:
 import java.awt.event.KeyEvent;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import sql.konek;

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

    /**
     * Creates new form status_cs
     */
    public status_cs() {
        initComponents();
        bacaData();
    }

    private void bacaData() {
        db.removeAll(db);
        try {
            Connection c = konek.getkoneksi();
            Statement s = c.createStatement();
            String sql = "Select * from customer where `status`=1 or `status`=2";
            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("status");
                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());
        }
       // norek.setText("");
    }

    public void exec() {
        String Norek = norek.getText();
        String Status = status.getText();
        String aksi = "";

        if (b1.isSelected()) {
            aksi = "1";
        } else if (b2.isSelected()) {
            aksi = "2";
        } else if (b3.isSelected()) {
            aksi = "3";
        }

        try {
            Connection c = konek.getkoneksi();
            Statement stat = c.createStatement();
            try {
                String sql = "update `customer` set `status`=" + aksi + " where `no_rek`='" + Norek + "';";
                stat.execute(sql);
                String sql1 = "update `saldo` set `status`=" + aksi + " where `no_rek`='" + Norek + "';";
                stat.execute(sql1);
                stat.close();
            } catch (SQLException ex) {
                System.out.println(ex);
            }
        } catch (SQLException ex) {
        }
        bacaData();
    }
private void norekKeyPressed(java.awt.event.KeyEvent evt) {                                
        if (evt.getKeyCode() == KeyEvent.VK_ENTER) {
            for (int i = 0; i < db.size(); i++) {
                if (norek.getText().equals(db.get(i).get(1))) {
                    status.setText(db.get(i).get(2));
                    break;
                } else {
                    status.setText("No Rekening Salah");
                }
            }    bacaData();
        }
  
    }                               

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        if (status.getText().equals("aktif") || status.getText().equals("blokir")) {
            exec();
        }
    }

Tidak ada komentar:

Posting Komentar