JavaKTI

Connection koneksi    = null;
    ResultSet data_record = null;
    Statement perintahSQL = null;

    String kodenip = null;
    public MenuAwal() {
        initComponents();
        koneksi();

        panel_insert.setVisible(false);
        panel_view.setVisible(false);
        panel_update.setVisible(false);
        table_karyawan.addMouseListener(mouseListener);

        new Thread(){
            @Override
            public void run(){
                while(timeRun == 0){
                    Calendar cal = new GregorianCalendar();
                    String tanggal, bulan, tahun, textdate;

                    int tanggal2 = cal.get(Calendar.DATE);
                    int bulan2 = cal.get(Calendar.MONTH);
                    int tahun2 =  cal.get(Calendar.YEAR);

                    int detik = cal.get(Calendar.SECOND);
                    int menit = cal.get(Calendar.MINUTE);
                    int jam = cal.get(Calendar.HOUR_OF_DAY);

                    String sJam   = null;
                    String sMenit = null;
                    String sDetik = null;

                    sJam   = Integer.toString(jam);
                    sMenit = Integer.toString(menit);
                    sDetik = Integer.toString(detik);

                    if(sJam.length()<2){
                        sJam = "0"+sJam;
                    }
                    if(sMenit.length()<2){
                        sMenit = "0"+sMenit;
                    }
                    if(sDetik.length()<2) {
                        sDetik = "0"+sDetik;
                    }

                    String textjam = sJam+":"+sMenit+":"+sDetik;
                    text_jam.setText(textjam);
                    String texttanggal = hari()+", "+tanggal2+"-"+bulan2+1+"-"+tahun2;
                    text_hari.setText(texttanggal);
                }
            }
        }.start();
    }

    int timeRun = 0;

    private String hari() {
        SimpleDateFormat format = new SimpleDateFormat("EEEEEE");
        Date date = new Date();
        return format.format(date);
    }

    private void koneksi() {
        try{
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/krwadriansya1ia10";
            koneksi = DriverManager.getConnection(url, "root", "");

        }catch(ClassNotFoundException |SQLException ex) {
            JOptionPane.showMessageDialog(rootPane, "Error Koneksi : \n"+ex, "Pesan", JOptionPane.ERROR_MESSAGE);
            System.exit(0);
        }
    }

    private void tampil() {
        Object header[] = {"No", "NIP", "Nama", "Alamat", "Jenis Kelamin", "Status", "Tunjangan", "Gaji", "No HP"};
        DefaultTableModel modeltable = new DefaultTableModel(null, header);
        table_karyawan.setModel(modeltable);

        String nip, nama, almt, jk, stat, tunjngn, gaji, nohp;
        int no = 1;
        try{
            perintahSQL = koneksi.createStatement();
            data_record = perintahSQL.executeQuery("SELECT * FROM krwadriansya1ia10 ORDER BY NIP");
            while(data_record.next()) {
                nip     = data_record.getString("nip");
                nama    = data_record.getString("nama");
                almt    = data_record.getString("almt");
                jk      = data_record.getString("jk");
                stat    = data_record.getString("status");
                tunjngn = data_record.getString("tunjangan");
                gaji    = data_record.getString("gaji");
                nohp    = data_record.getString("nohp");

                String ls_no = Integer.toString(no);
                String kolom[] = {ls_no, nip, nama, almt, jk , stat, tunjngn, gaji, nohp};
                modeltable.addRow(kolom);
                no++;
                new AutoResizeTable().sesuaikanKolom(table_karyawan);
            }
        }catch(SQLException se) {
            JOptionPane.showMessageDialog(rootPane, "Error Show : \n"+se, "Pesan", JOptionPane.ERROR_MESSAGE);
        }
    }

    private void selection() {
        int pesan;
        pesan = JOptionPane.showOptionDialog(rootPane, "Pilih Opsi untuk nip : "+kodenip, "Pesan", JOptionPane.YES_NO_CANCEL_OPTION, JOptionPane.INFORMATION_MESSAGE, null, new String[]{"Edit","Hapus","Batal"}, "default");
        if(pesan == JOptionPane.YES_OPTION) {
            try {
                perintahSQL = koneksi.createStatement();
                data_record = perintahSQL.executeQuery("SELECT * FROM krwadriansya1ia10 WHERE nip = '" + kodenip + "'");
                if(data_record.next()) {
                    String alamat, jk;
                    text_nip1.setText(data_record.getString("nip"));
                    text_nama1.setText(data_record.getString("nama"));
                    text_tunjngn1.setText(data_record.getString("tunjangan"));
                    text_gaji1.setText(data_record.getString("gaji"));
                    text_nohp1.setText(data_record.getString("nohp"));

                    alamat = data_record.getString("almt");
                    jk = data_record.getString("jk");

                    if(alamat.equals("JKT")) {
                        cmb_almt1.setSelectedItem("Jakarta");
                    }else if(alamat.equals("BKS")) {
                        cmb_almt1.setSelectedItem("Bekasi");
                    }else if(alamat.equals("DPK")) {
                        cmb_almt1.setSelectedItem("Depok");
                    }else {
                        cmb_almt1.setSelectedItem("Bogor");
                    }

                    if(jk.equals("L")) {
                       rd_L1.setSelected(true);
                    }else {
                        rd_W1.setSelected(true);
                    }
                }
            }catch(SQLException se) {
                JOptionPane.showMessageDialog(rootPane, "Error GetData : \n"+se, "Pesan", JOptionPane.ERROR_MESSAGE);
            }

            panel_home.setVisible(false);
            panel_view.setVisible(false);
            panel_insert.setVisible(false);
            panel_update.setVisible(true);
        }else if(pesan == JOptionPane.NO_OPTION) {
            try{
                perintahSQL = koneksi.createStatement();
                perintahSQL.executeUpdate("DELETE FROM krwadriansya1ia10 WHERE nip = '"+ kodenip +"'");
                JOptionPane.showMessageDialog(rootPane, "Berhasil Hapus", "Pesan", JOptionPane.INFORMATION_MESSAGE);
                tampil();
            }catch(SQLException se) {
                JOptionPane.showMessageDialog(rootPane, "Error Simpan : \n"+se, "Pesan", JOptionPane.ERROR_MESSAGE);
            }
        }
    }

    MouseListener mouseListener = new MouseAdapter() {
      @Override
      public void mouseClicked(MouseEvent mouseEvent) {
         int row = table_karyawan.rowAtPoint(mouseEvent.getPoint());
         int col = table_karyawan.columnAtPoint(mouseEvent.getPoint());
         kodenip = table_karyawan.getValueAt(row, col).toString();
         selection();
      }
    };