Membuat Form Menu(Tugas 16)

Buatlah sebuah Form pada Project_penjualan dengan nama form menu dengan cara sebagai berikut:

pada project penjualan source package klik kanan pilih New |Jframe form

akan tampil gambar seperti di bawah ini&ketik:form menu pada class namepilih finish

pilih menu bar pada swing menu yang ada di pallete lalu drag ke form menu sehingga tampak pada gambar berikut:

gantilah nama file menjadi peralatan &edit file menjadi file sehingga nampak seperti pada gambar berikut:

Tambahkan 3 menu item pada swing menu yang ada di palete lalu drag ke form menu peralatan sehingga tampak seperti gambar diatas selanjutnya tambahkan menu item pada masing masng menu bar sehingga tampak seperti gambar di bawah ini:

adapun properties dari komponennya sebagai berikut:

adapun kode program untuk form menu sebagai berikut: 

 package project_penjualan;

import java.awt.Dimension;

import java.awt.Toolkit;

/**

 *

 * @author ismail

 */

public class formMenu extends javax.swing.JFrame {

    /** Creates new form formMenu */

    public formMenu() {

        initComponents();

        Dimension layar =Toolkit.getDefaultToolkit().getScreenSize();

        int i=(layar.width);

        int j=(layar.height);

        this.setSize(i, j);

    }

    /** This method is called from within the constructor to

     * initialize the form.

     * WARNING: Do NOT modify this code. The content of this method is

     * always regenerated by the Form Editor.

     */

    @SuppressWarnings("unchecked")

    // <editor-fold defaultstate="collapsed" desc="Generated Code">                         

    private void initComponents() {

        jMenuBar1 = new javax.swing.JMenuBar();

        mnuperalatan = new javax.swing.JMenu();

        mnulogin = new javax.swing.JMenuItem();

        mnulogout = new javax.swing.JMenuItem();

        mnuexit = new javax.swing.JMenuItem();

        jMenu2 = new javax.swing.JMenu();

        jseperator = new javax.swing.JMenuItem();

        jMenuItem1 = new javax.swing.JMenuItem();

        jMenuItem2 = new javax.swing.JMenuItem();

        jMenu1 = new javax.swing.JMenu();

        jMenuItem3 = new javax.swing.JMenuItem();

        jMenu3 = new javax.swing.JMenu();

        jMenuItem4 = new javax.swing.JMenuItem();

        jMenuItem5 = new javax.swing.JMenuItem();

        jMenuItem6 = new javax.swing.JMenuItem();

        jMenuItem7 = new javax.swing.JMenuItem();

        jMenu4 = new javax.swing.JMenu();

        jMenuItem8 = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        mnuperalatan.setText("peralatan");

        mnulogin.setText("login");

        mnulogin.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                mnuloginActionPerformed(evt);

            }

        });

        mnuperalatan.add(mnulogin);

        mnulogout.setText("logout");

        mnuperalatan.add(mnulogout);

        mnuexit.setText("exit");

        mnuexit.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                mnuexitActionPerformed(evt);

            }

        });

        mnuperalatan.add(mnuexit);

        jMenuBar1.add(mnuperalatan);

        jMenu2.setText("file");

        jseperator.setText("operator");

        jseperator.addActionListener(new java.awt.event.ActionListener() {

            public void actionPerformed(java.awt.event.ActionEvent evt) {

                jseperatorActionPerformed(evt);

            }

        });

        jMenu2.add(jseperator);

        jMenuItem1.setText("barang");

        jMenu2.add(jMenuItem1);

        jMenuItem2.setText("pelanggan");

        jMenu2.add(jMenuItem2);

        jMenuBar1.add(jMenu2);

        jMenu1.setText("Transaksi");

        jMenuItem3.setText("penjualan");

        jMenu1.add(jMenuItem3);

        jMenuBar1.add(jMenu1);

        jMenu3.setText("Laporan");

        jMenuItem4.setText("Data barang");

        jMenu3.add(jMenuItem4);

        jMenuItem5.setText("Data pelanggan");

        jMenu3.add(jMenuItem5);

        jMenuItem6.setText("Data operator");

        jMenu3.add(jMenuItem6);

        jMenuItem7.setText("Data penjualan");

        jMenu3.add(jMenuItem7);

        jMenuBar1.add(jMenu3);

        jMenu4.setText("Bantuan");

        jMenuItem8.setText("About");

        jMenu4.add(jMenuItem8);

        jMenuBar1.add(jMenu4);

        setJMenuBar(jMenuBar1);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());

        getContentPane().setLayout(layout);

        layout.setHorizontalGroup(

            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

            .addGap(0, 2318, Short.MAX_VALUE)

        );

        layout.setVerticalGroup(

            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

            .addGap(0, 1699, Short.MAX_VALUE)

        );

        pack();

    }// </editor-fold>                       

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

        // TODO add your handling code here:

        System.exit(0);

    }                                      

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

        // TODO add your handling code here:

        new fromOperator().setVisible(true);

    }                                         

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

        // TODO add your handling code here:

        new login().setVisible(true);

    }                                       

    /**

     * @param args the command line arguments

     */

    public static void main(String args[]) {

        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {

                new formMenu().setVisible(true);

            }

        });

    }

Membuat form Login(Tugas 15)

adapun kode untuk programnya adalah sbb:

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 login extends javax.swing.JFrame {

    /** Creates new form login */

    public login() {

        initComponents();

    }

kode untuk tombol keluar:

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

        // TODO add your handling code here:

        System.exit(1);

    }                                       

kode untuk tombol ok:
  private void bokActionPerformed(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()+
                    "'&& Passid='"+txtpassword.getText().trim()+"'";
            ResultSet rs=st.executeQuery(SQL);
            if(rs.next()){
                fromOperator mn=new fromOperator();
                mn.setVisible(true);
                dispose();
            }
            else{
                JOptionPane.showMessageDialog(null,"salah boz");
            }
            st.close();
            Cn.close();
            rs.close();
        }catch(Exception exc){
            System.err.println(exc.getMessage());
        }
        txtkdoperator.requestFocus();

    }                                  

Membuat Database Dengan MYSQL(Tugas 12)

Ketikan di browser anda localhost/phpmyadmin maka akan muncul sbb:

lalu pada create database ketik nama databasenya contoh dbpenjualan 

lalu buat tabel barang

tabel pelanggan

Tabel Operator

Tabel Jual

Tabel detailjual

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();

           

   

   

}

     

    }                                     

 

Membuat Class Koneksi ke Database(tugas 13)

Membuat Class Koneksi ke Database

ketikan connekdb lalu ketik finish

package project_penjualan;

import java.sql.*;

/**

 *

 * @author ismail

 */

public class ConekDB {

    public static void main(String[] args){

    }

    public Connection konek()throws SQLException{

        Connection Cn=null;

        try{

            Class.forName("com.mysql.jdbc.Driver");

            System.out.println("driver berhasil ditemukan");

           try{

               String url="jdbc:mysql://localhost/penjualan";

               String user="root";

                            String password="";

                            Cn=DriverManager.getConnection(url, user, password);

                            System.out.println("buat koneksi sukses");

                            return Cn;

           }catch(SQLException ex){

               System.out.println("koneksi gagal");

               System.out.println("SQLException:"+ ex.getMessage());

               return null;

           }

        }catch(Exception se){

            System.out.println("Driver MySQL tidak ditemukan:"+se);

            return null;

        }

    }

}

Selanjutnya membuat class data java

/*

 * To change this template, choose Tools | Templates

 * and open the template in the editor.

 */

package project_penjualan;

import java.sql.*;

import javax.swing.*;

/**

 *

 * @author ismail

 */

public class Data {

    Connection cnExecute=null;

    int rowNgefek=0;

    Statement stExecute;

   

   

    public void closingConnection(Connection cnClose,Statement stClose)

    {

        try

        {

            cnClose.close();

            stClose.close();

        }

    catch(SQLException e)

    {

    }

    }

       

        public void ExecuteSQL(String SQL)

        {

            ConekDB getCn=new ConekDB();

            rowNgefek=0;

            try{

                cnExecute=getCn.konek();

                stExecute=cnExecute.createStatement();

                cnExecute.setAutoCommit(false);

                rowNgefek=stExecute.executeUpdate(SQL);

                cnExecute.commit();

                closingConnection(cnExecute,stExecute);

            }

            catch(SQLException e)

            {

                System.out.println(e.toString());

                JOptionPane.showMessageDialog(null,

             e.toString(),"warning",JOptionPane.OK_OPTION);

            }

        }

    }

Membuat form Contoh Scroll Bar(Tugas 11b)

Adapun kodenya adalah sbb:

private void sbvolumeAdjustmentValueChanged(java.awt.event.AdjustmentEvent evt) {

// TODO add your handling code here:

arearesume.setText("Volume:\t"+sbvolume.getValue()+"\n"+"Treble\t"+sbtreble.getValue()+"\n"+"Bass\t"+sbbass.getValue());

}

private void sbbassAdjustmentValueChanged(java.awt.event.AdjustmentEvent evt) {

// TODO add your handling code here:

arearesume.setText("Volume:\t"+sbvolume.getValue()+"\n"+"Treble\t"+sbtreble.getValue()+"\n"+"Bass\t"+sbbass.getValue());

}

private void sbtrebleAdjustmentValueChanged(java.awt.event.AdjustmentEvent evt) {

// TODO add your handling code here:

arearesume.setText("Volume:\t"+sbvolume.getValue()+"\n"+"Treble\t"+sbtreble.getValue()+"\n"+"Bass\t"+sbbass.getValue());

    }

Mengenal Spinner dan Scrollbar pada Netbeans(tugas 11a)

 private void spinhariStateChanged(javax.swing.event.ChangeEvent evt) {
// TODO add your handling code here:
Ehari.setText(spinhari.getValue().toString());
}
private void spinangkaStateChanged(javax.swing.event.ChangeEvent evt) {
// TODO add your handling code here:
Eangka.setText(spinangka.getValue().toString());

}


private void spinnormalStateChanged(javax.swing.event.ChangeEvent evt) {
// TODO add your handling code here:
Enormal.setText(spinnormal.getValue().toString());


}