Membuat Project Penjualan & Operator(Tugas 14)

Berikut adalah kode programnya:

package project_penjualan;

import javax.swing.JTable.*;

import javax.swing.table.DefaultTableModel;

import javax.swing.JOptionPane;

import java.text.*;

import java.sql.*;

/**

 *

 * @author ismail

 */

public class fromOperator extends javax.swing.JFrame {

    String[] judul={"Kode Operator","Nama Operator","Kelamin","Alamat","Username"};

    DefaultTableModel DTM;

   

    /** Creates new form fromOperator */

    public fromOperator() {

          DTM = new DefaultTableModel(null,judul){

            public boolean isCellEditable(int row,int column){

                return false;}

          };

         

        initComponents();

        kosong();

        filltable();

    }

Kode untuk Tombol keluar:

   private void bkeluarActionPerformed(java.awt.event.ActionEvent evt) {                                        

        // TODO add your handling code here:

if(bkeluar.getText().equals("Keluar")){

    dispose();

    setVisible(false);}

else

    kosong();

    }                                      

Kode untuk Kode Operator:  private void txtkdoperatorActionPerformed(java.awt.event.ActionEvent evt) {                                             

        // TODO add your handling code here:

        try{

                ConekDB getCn = new ConekDB();

                Connection Cn=getCn.konek();

         Statement st=Cn.createStatement();

         String SQL="SELECT*FROM operator where kdoperator='"+txtkdoperator.getText().trim()+"'";

                        ResultSet rs=st.executeQuery(SQL);

                if(rs.next()){

                    JOptionPane.showMessageDialog(null," maaf data sudah ada");

                        txtnmoperator.setText(""+rs.getString("nmoperator"));

         if(rs.getString("Kelamin").equals("L"))

             rdpria.setSelected(true);

         else

             rdwanita.setSelected(true);

         txtalamat.setText(""+rs.getString("alamat"));

         txtusername.setText(""+rs.getString("Userid"));

         txtpassword.setText(""+rs.getString("Passid"));

         bsimpan.setText("Update");

         bhapus.setEnabled(true);

                }

                else{

         bsimpan.setText("Simpan");

            JOptionPane.showMessageDialog(null, "Masukkan Data Baru");

                }

                bsimpan.setEnabled(true);

                bkeluar.setText("Batal");

                st.close();

                Cn.close();

                rs.close();

    }catch(Exception exc){

        System.err.println(exc.getMessage());

    }

        txtnmoperator.requestFocus();

    }                                             

Kode untuk tombol simpan:

private void bsimpanActionPerformed(java.awt.event.ActionEvent evt) {                                       

        // TODO add your handling code here:

        if(txtkdoperator.getText().equals(""))

        JOptionPane.showMessageDialog(null,"Isi Data Yang Lengkap Donk!!!");

        else{

            String kel="";

            if(rdpria.isSelected()==true)

                kel="L";

            else

                kel="P";

            Data clsData = new Data();

            String SQL="";

            if(bsimpan.getText().equals("Simpan")){

                SQL ="INSERT INTO operator VALUES('"+txtkdoperator.getText().trim()+"','"+

            txtnmoperator.getText().trim()+"','"+kel+"','"+txtalamat.getText().trim()+"','"+

            txtusername.getText().trim()+"','"+txtpassword.getText().trim()+"')";

                clsData.ExecuteSQL(SQL);

            }

            else{

                SQL ="UPDATE operator SET nmoperator='"+txtnmoperator.getText().trim()+

            "',Kelamin='"+ kel +"',alamat='"+txtalamat.getText().trim()+"',Userid='"+

            txtusername.getText().trim()+"',Passid='"+txtpassword.getText().trim()+

            "'WHERE kdoperator='"+txtkdoperator.getText().trim()+"'";

                clsData.ExecuteSQL(SQL);

            }

            clsData=null;

            kosong();

            filltable();

        }

    }                                      

Kode untuk Prosedur Kosong:

private void kosong() {

         txtkdoperator.setText("");

         txtnmoperator.setText("");

         rdpria.setSelected(true);

         rdwanita.setSelected(false);

         txtalamat.setText("");

         txtusername.setText("");

         txtpassword.setText("0");

         bsimpan.setEnabled(false);

         bhapus.setEnabled(false);

         bkeluar.setEnabled(true);

         bsimpan.setText("Simpan");

         bkeluar.setText("Keluar");

         txtkdoperator.requestFocus();

        //throw new UnsupportedOperationException("Not yet implemented");   

    }

    private void filltable() {

        String SQL="SELECT * FROM operator";

        DTM.setRowCount(0);

        try{

            ConekDB getCn= new ConekDB();

            Connection Cn=getCn.konek();

            Statement st=Cn.createStatement();

            ResultSet rs=st.executeQuery(SQL);

            while(rs.next())

            {

                String vkdoperator=rs.getString("kdoperator");

                String vnmoperator=rs.getString("nmoperator");

                String valamat=rs.getString("alamat");

                String vKelamin=rs.getString("Kelamin");

                String kel="";

                if(vKelamin.equals("L"))

                    kel="Laki-Laki";

                else

                    kel="Wanita";

                String vusername=rs.getString("Userid");

                String[] data={vkdoperator,vnmoperator,kel,valamat,vusername};

                DTM.addRow(data);

            }

            st.close();

            Cn.close();

                rs.close();

            TBoperator.setModel(DTM);

        }

        catch(SQLException e){

           

        }

        //throw new UnsupportedOperationException("Not yet implemented");

    }

}

Kode Untuk Prosedur Hapus:

private void bhapusActionPerformed(java.awt.event.ActionEvent evt) {                                      

        // TODO add your handling code here:

        int result=JOptionPane.showConfirmDialog(this, "Yakin Akan Dihapus","konfirmasi",

                    JOptionPane.YES_NO_OPTION);

        if (result==JOptionPane.YES_NO_OPTION){

            Data clsData=new Data();

            String SQL="";

            SQL="DELETE FROM Operator WHERE kdoperator='"+ txtkdoperator.getText().trim()+"'";

            clsData.ExecuteSQL(SQL);

            clsData=null;

           kosong();

           filltable();

           

   

   

}

     

    }