Rabu, 14 Oktober 2015

MEMBUAT APLIKASI STEAM MOTOR

Selamat siang,saya akan berbagi bagaimana membuat aplikasi cuci steam motor dengan java netbeans,
untuk source code dan pengembangan aplikasi silahkan agan download di bawah

Berikut ini tampilanya...SELAMAT MENYAKSIKAN

1.MAIN MENU
















Source code MAIN MENU
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.tree.DefaultMutableTreeNode;
import steam.*;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;
import static steam.Stetment.st;
import static steam.Stetment.rs;
import static steam.Stetment.rs1;
import static steam.Stetment.rs2;
import javax.swing.table.DefaultTableModel;
import java.util.Calendar.*;

public class MAINMENU extends javax.swing.JFrame {
DefaultTableModel tbl= new DefaultTableModel();
    /**
     * Creates new form MAINMENU
     */
    public MAINMENU() throws ClassNotFoundException, SQLException {
        initComponents();
        setExtendedState(MAXIMIZED_BOTH);
       st=ConnectionString.getconnection().createStatement();
    }

                         
    private void initComponents() {

     }                

    private void jMenuItem1ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        try {
            Transaction tn= new Transaction();
            tn.show();
           
           tn.requestFocus();
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
        }
    }                                        

    private void jMenuItem3ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        try {
            Report rp=new Report();
            rp.show();
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
        }
    }                                        

    private void jMenuItem2ActionPerformed(java.awt.event.ActionEvent evt) {                                          
        try {
            InputItem i=new InputItem();
            i.show();
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(MAINMENU.class.getName()).log(Level.SEVERE, null, ex);
        }
    }                                








2.FORM TRANSAKSI















package steam;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import steam.*;
import java.util.Date;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author PC-IT-3
 */
public class Transaction extends javax.swing.JFrame {
 
 

 
    public Transaction() throws ClassNotFoundException, SQLException {
        initComponents();
        Stetment.st=ConnectionString.getconnection().createStatement();
       
       
    }

    /**
     * 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() {

        jScrollPane2 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jPanel1 = new javax.swing.JPanel();
        cmbpilih = new javax.swing.JComboBox();
        txtjeniskendaraan = new javax.swing.JTextField();
        txttransaksi = new javax.swing.JTextField();
        txtharga = new javax.swing.JTextField();
        jButton1 = new javax.swing.JButton();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        tbl = new javax.swing.JTable();

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jScrollPane2.setViewportView(jTable1);

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setTitle("Transaksi");
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowOpened(java.awt.event.WindowEvent evt) {
                formWindowOpened(evt);
            }
        });

        jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 255)));

        cmbpilih.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                cmbpilihItemStateChanged(evt);
            }
        });

        txtjeniskendaraan.setEditable(false);

        txttransaksi.setEditable(false);

        txtharga.setEditable(false);

        jButton1.setText("save");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jLabel1.setText("MEREK KENDARAAN");

        jLabel2.setText("MEREK KENDARAAN");

        jLabel3.setText("TRANSAKSI");

        jLabel4.setText("HARGA");

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(cmbpilih, javax.swing.GroupLayout.PREFERRED_SIZE, 192, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel1)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(txtjeniskendaraan, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel2))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(txttransaksi, javax.swing.GroupLayout.PREFERRED_SIZE, 140, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel3))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addComponent(txtharga, javax.swing.GroupLayout.PREFERRED_SIZE, 148, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(18, 18, 18)
                                .addComponent(jButton1))
                            .addComponent(jLabel4))))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addComponent(jLabel1)
                .addGap(5, 5, 5)
                .addComponent(cmbpilih, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(3, 3, 3)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel2)
                    .addComponent(jLabel3)
                    .addComponent(jLabel4))
                .addGap(1, 1, 1)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtjeniskendaraan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txttransaksi, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtharga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jButton1))
                .addContainerGap(20, Short.MAX_VALUE))
        );

        jPanel2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 255)));

        tbl.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {},
                {},
                {},
                {}
            },
            new String [] {

            }
        ));
        jScrollPane1.setViewportView(tbl);

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1)
                .addContainerGap())
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 58, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(19, Short.MAX_VALUE))
        );

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(20, Short.MAX_VALUE))
        );

        pack();
        setLocationRelativeTo(null);
    }// </editor-fold>                      

    private void formWindowOpened(java.awt.event.WindowEvent evt) {                                
       cmbpilih.addItem("");
        try {
         
         Stetment.rs=Stetment.st.executeQuery("select * from Transaksi");
            while(Stetment.rs.next()){
                cmbpilih.addItem(Stetment.rs.getString(1));
            }
        } catch (SQLException ex) {
            Logger.getLogger(Transaction.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
       private void reload(){
           try {
            Stetment.rs=Stetment.st.executeQuery("select * from Transaksi where Kendaraan='"+cmbpilih.getSelectedItem()+"'");
            while(Stetment.rs.next()){
                txtjeniskendaraan.setText(Stetment.rs.getString(1));
                txttransaksi.setText(Stetment.rs.getString(2));
                txtharga.setText(Stetment.rs.getString(3));
            }
        } catch (SQLException ex) {
            Logger.getLogger(Transaction.class.getName()).log(Level.SEVERE, null, ex);
        }
     
    }                                

    private void cmbpilihItemStateChanged(java.awt.event.ItemEvent evt) {                                        
       
        try {
             DefaultTableModel tebel=new DefaultTableModel();
             tebel.addColumn("Jenis kendaraan"); tebel.addColumn("Jenis Transaksi"); tebel.addColumn("Harga");
            Stetment.rs=Stetment.st.executeQuery("select * from Transaksi where Kendaraan='"+cmbpilih.getSelectedItem()+"'");
            while(Stetment.rs.next()){
                txtjeniskendaraan.setText(Stetment.rs.getString(1));
                txttransaksi.setText(Stetment.rs.getString(2));
                txtharga.setText(Stetment.rs.getString(3));
                tebel.addRow(new Object[]{Stetment.rs.getString(1),Stetment.rs.getString(2),Stetment.rs.getString(3)});
            }tbl.setModel(tebel);
        } catch (SQLException ex) {
            Logger.getLogger(Transaction.class.getName()).log(Level.SEVERE, null, ex);
        }reload();
    }                                        

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
        if(txtjeniskendaraan.getText().equals("")|txttransaksi.getText().equals("")){
           JOptionPane.showMessageDialog(null,"Data Kosong Silahkan Isi");
           txtjeniskendaraan.requestFocus();
           return;
       }
        try {
      java.util.Date now = new java.util.Date();
      SimpleDateFormat sdf = new SimpleDateFormat( "dd-MM-yyyy" );
      String sdate=sdf.format(now).toString();
           int i= Stetment.st.executeUpdate("insert into transaksi2(Kendaraan,Jtransaksi,harga,tanggal)values('"
                    +txtjeniskendaraan.getText()+"','"
                    +txttransaksi.getText()+"','"
                    +txtharga.getText()+"','"+sdate+"')");
           if(i==0){
               JOptionPane.showMessageDialog(null,"Tidak Tersimpan");
           }else {
               JOptionPane.showMessageDialog(null,"Sukses");
               txtjeniskendaraan.setText("");
               txttransaksi.setText("");
               txtharga.setText("");
           }
        } catch (SQLException ex) {
            Logger.getLogger(Transaction.class.getName()).log(Level.SEVERE, null, ex);
        }
    }                                


3.REPORT















package steam;
import steam.*;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.logging.Level;
import java.util.logging.Logger;
import static steam.Stetment.st;
import static steam.Stetment.rs;
import static steam.Stetment.rs1;
import static steam.Stetment.rs2;
import javax.swing.table.DefaultTableModel;
import java.util.Calendar.*;
import java.util.Date;
import javax.swing.JOptionPane;
/**
 *
 * @author PC-IT-3
 */
public class Report extends javax.swing.JFrame {
DefaultTableModel tbl= new DefaultTableModel();
   
    public Report() throws ClassNotFoundException, SQLException {
        initComponents();
        st=ConnectionString.getconnection().createStatement();
        Date tgl = new Date();
        SimpleDateFormat simpdate = new SimpleDateFormat("dd-MM-yyy");
        tanggal.setText(simpdate.format(tgl));
       
    }

    /**
     * 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() {

        jPanel1 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        tanggal = new javax.swing.JTextField();
        jButton1 = new javax.swing.JButton();
        jLabel1 = new javax.swing.JLabel();
        cekbok = new javax.swing.JCheckBox();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setAutoRequestFocus(false);
        setFocusTraversalPolicyProvider(true);
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowOpened(java.awt.event.WindowEvent evt) {
                formWindowOpened(evt);
            }
        });

        jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 204)));

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jScrollPane1.setViewportView(jTable1);

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 705, Short.MAX_VALUE)
                .addContainerGap())
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 322, Short.MAX_VALUE)
                .addContainerGap())
        );

        tanggal.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyReleased(java.awt.event.KeyEvent evt) {
                tanggalKeyReleased(evt);
            }
        });

        jButton1.setText("Refresh");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jLabel1.setText("Date");

        cekbok.setText("ALL");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jLabel1)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(tanggal, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(cekbok)
                .addGap(35, 35, 35)
                .addComponent(jButton1)
                .addGap(0, 0, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(tanggal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel1)
                        .addComponent(cekbok))
                    .addComponent(jButton1))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

        pack();
        setLocationRelativeTo(null);
    }// </editor-fold>                      

    private void formWindowOpened(java.awt.event.WindowEvent evt) {                                
    try {
         
        tbl.addColumn("Kendaraan");tbl.addColumn("Transaksi");tbl.addColumn("Harga");
        tbl.addColumn("Tanggal");
        rs=st.executeQuery("select * from Transaksi2 where tanggal='"+tanggal.getText()+"'");
        while(rs.next()){
            tbl.addRow(new Object[]{rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4)});
        }jTable1.setModel(tbl);
         
    } catch (SQLException ex) {
        Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
    }
    }                                
private void refresh(){
    try {
        rs1=st.executeQuery("select * from Transaksi2");
        while(rs1.next()){
            tbl.addRow(new Object[]{rs1.getString(1),rs1.getString(2),rs1.getString(3),rs1.getString(4)});
        }jTable1.setModel(tbl);
         
    } catch (SQLException ex) {
        Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
    }
}
    private void tanggalKeyReleased(java.awt.event.KeyEvent evt) {                                  
      try {
       rs2=st.executeQuery("select * from Transaksi2 where tanggal='"+tanggal.getText()+"'");
     
       if(rs2.next()){
            tbl.addRow(new Object[]{rs2.getString(1),rs2.getString(2),rs2.getString(3),rs2.getString(4)});
        }jTable1.setModel(tbl);
     
    } catch (SQLException ex) {
        Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
    }
    }                                  

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
 
        if(cekbok.isSelected()){
            refresh();
           }else{
        try {
       rs2=st.executeQuery("select * from Transaksi2 where tanggal='"+tanggal.getText()+"'");
     
       if(rs2.next()){
           
           tbl.addRow(new Object[]{rs2.getString(1),rs2.getString(2),rs2.getString(3),rs2.getString(4)});
         
        }jTable1.setModel(tbl);
     
    } catch (SQLException ex) {
        Logger.getLogger(Report.class.getName()).log(Level.SEVERE, null, ex);
    }
        }
    }                                      


4.MASTER ITEM















package steam;
import steam.*;
import static steam.Stetment.st;
import static steam.Stetment.rs;
import javax.swing.table.DefaultTableModel;
import java.sql.*;
import static java.time.zone.ZoneRulesProvider.refresh;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;



public class InputItem extends javax.swing.JFrame {
DefaultTableModel tbl=new DefaultTableModel();
   
    public InputItem() throws ClassNotFoundException, SQLException {
        initComponents();
        st=ConnectionString.getconnection().createStatement();
    }

 
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                        
    private void initComponents() {

        jPanel1 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jPanel2 = new javax.swing.JPanel();
        txtkendaraan = new javax.swing.JTextField();
        transaksi = new javax.swing.JTextField();
        harga = new javax.swing.JTextField();
        jButton1 = new javax.swing.JButton();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        btnedit = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        addWindowListener(new java.awt.event.WindowAdapter() {
            public void windowOpened(java.awt.event.WindowEvent evt) {
                formWindowOpened(evt);
            }
        });

        jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 204)));

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        jScrollPane1.setViewportView(jTable1);

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)
                .addContainerGap())
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 211, Short.MAX_VALUE)
                .addContainerGap())
        );

        jPanel2.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 204)));

        jButton1.setText("Simpan");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jLabel1.setText("jenis Kendaraan");

        jLabel2.setText("Jenis Transaksi");

        jLabel3.setText("Harga");

        btnedit.setText("Edit");
        btnedit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btneditActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(txtkendaraan, javax.swing.GroupLayout.PREFERRED_SIZE, 122, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel2Layout.createSequentialGroup()
                        .addGap(23, 23, 23)
                        .addComponent(jLabel1)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(transaksi, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                        .addComponent(jLabel2)
                        .addGap(17, 17, 17)))
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel2Layout.createSequentialGroup()
                        .addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addComponent(jButton1)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(btnedit))
                    .addGroup(jPanel2Layout.createSequentialGroup()
                        .addGap(22, 22, 22)
                        .addComponent(jLabel3)))
                .addContainerGap(65, Short.MAX_VALUE))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                .addContainerGap(21, Short.MAX_VALUE)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(jLabel2)
                    .addComponent(jLabel3))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtkendaraan, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(transaksi, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(harga, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jButton1)
                    .addComponent(btnedit))
                .addContainerGap())
        );

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap())
        );

        pack();
        setLocationRelativeTo(null);
    }// </editor-fold>                      

    private void formWindowOpened(java.awt.event.WindowEvent evt) {                                
       
    try {
        tbl.addColumn("Jenis Kendaraan");tbl.addColumn("Jenis Transaksi");tbl.addColumn("Harga");
        rs=st.executeQuery("select * from transaksi");
        while(rs.next()){
            tbl.addRow(new Object[]{rs.getString(1),rs.getString(2),rs.getString(3)});
        }jTable1.setModel(tbl);
    } catch (SQLException ex) {
        Logger.getLogger(InputItem.class.getName()).log(Level.SEVERE, null, ex);
    }
    }                                
private void reload(){
    try {
    rs=st.executeQuery("select * from transaksi");
        while(rs.next()){
            tbl.addRow(new Object[]{rs.getString(1),rs.getString(2),rs.getString(3)});
        }jTable1.setModel(tbl);
    } catch (SQLException ex) {
        Logger.getLogger(InputItem.class.getName()).log(Level.SEVERE, null, ex);
    }
}
    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        
    if(txtkendaraan.getText().equals("") & transaksi.getText().equals("")& harga.getText().equals("")){
       JOptionPane.showMessageDialog(null,"Data Not Found");
       txtkendaraan.requestFocus();
       return;
     }
       try {
      int x= st.executeUpdate("insert into transaksi(Kendaraan,Jtransaksi,harga)Values('"+txtkendaraan.getText()+"','"+transaksi.getText()+"','"+harga.getText()+"')");
       if(x==0){
           JOptionPane.showMessageDialog(null,"Tidak tersimpan");
       }else {
           JOptionPane.showMessageDialog(null,"Tersimpan");
       }
    } catch (SQLException ex) {
        Logger.getLogger(InputItem.class.getName()).log(Level.SEVERE, null, ex);
    }reload();
    }                                      

    private void btneditActionPerformed(java.awt.event.ActionEvent evt) {                                      
     if(txtkendaraan.getText().equals("") & transaksi.getText().equals("")& harga.getText().equals("")){
       JOptionPane.showMessageDialog(null,"Data Not Found");
       txtkendaraan.requestFocus();
       return;
     }
        try {
       int i= st.executeUpdate("update transaksi set Jtransaksi='"+transaksi.getText()
                +"',harga='"+harga.getText()+"'where kendaraan='"+txtkendaraan.getText()+"'");
       if(i==0){
           JOptionPane.showMessageDialog(null,"Updated :" +i);
       }else{
          JOptionPane.showMessageDialog(null,"Updated :" +i);
       }
    } catch (SQLException ex) {
        Logger.getLogger(InputItem.class.getName()).log(Level.SEVERE, null, ex);
    }reload();
    }                                      





       

Jasa Service AC Jakarta

Rabu, 01 Juli 2015

Aplikasi java VS Applet Java

Aplikasi java adalah program yang dijalankan di pada shel,sedangkan applet aja adalah program yang di jalan ke dalam browser.tampilan applet adalah tampilan grafis

contoh applet java

import java.swing.JAplet;
import java.awt.Grafphics;
import java.awat.Color;

public class salamapplet extend JAplett
{
public void paint(Graphics g)
{
g.drawRect(0,0,getSize().widht-1,getSize.haight-1);
stBeground(color.blue);
g.d.drawString("selamat belajar java!",50,20);
       }


Langkah untuk menjalankanya adalah
  1. compaile salam APplet
  2. menghasilkan salam applet.class
  3. jalankan di brow dengan memanggila salam.html di adres bar
Jasa Service AC Jakarta

Sabtu, 27 Juni 2015

Pendahuluan

1.1Tujuan
Setelah mengikut modul ini diharapkan pembaca
  • Mengenal bahasa pemograman java
  • Mengetahui konsep OOP
  • Membuat program dan menjalankan program java
1.2 Apa itu java?
java adalah salah satu bahasa pemograman ber-orientsi objek(OOP-Object Oriented Progreming).Fusngsi OOP menyelesaikan masalah  dengan mempresentasikan masalah ke model objek.
Keutamaan java dibanding bahasa pemrograman lain
  1. Cross platform dengan adanya java virtusl machine
  2. Robust & Scure (tangguh dan aman)
  3. Pengembangannya di dukung oleh programer secara luas
  4. Automatic grabage collection,membebaskan programer dari tugas managemnt memori
1.3 Object Oriented Programming(OOP)

Objek Objek dalam dunia nyata mempunyai dua karakteristik khusus/khas,yaitu:Status dan perilaku
Contoh:
Sepeda punya status
  • Jumlah gir
  • jumlah pedal
  • Dua  ban
Sepeda punya prilaku
  • Mengerem
  • Ngebut
  • Menabrak
Bahasa yang berorientasi pada objek pun mempunya karekteristik yang sama dengan objek-objek di dunia nyata.
yaitu Status atau properti objek dalam bahasa pemrograman di simpan sebagai variabel  dan perilaku di sebut Method

1.4 Karakteristik OOP
  1. Enkapsulasi
  2. Inheritansi
  3. Polimorfisme'
1. Enkapsulasi(Pembungkusan)
Enkapsulasi adalah pelindung program dan data yang sedang di olah.Enkapsulasi mendefinisikan prilaku dan melindungi program dan data agar tidak di akses secara sembarangan oleh program lain.

      Dalam java,dasar enkapsulasi adalah kelas.Anda membuat suatu kelas yang menyatakan bahwa Variabel atau method sebuah class tidak dapat di akses oleh class lain dengan menjadikan class tersebut privat atau menjadikan protectedyaitu hanay bisa di akses oleh turunannya atau menjadi class tersebut public yang bisa di akses sembarang oleh class lain.

2.Inheritansi(Pewarisan)
Objek-objek yang berada di sekitar kita adalah objek objek yang saling terhubung secara hirarkis

3.Polimorfisme
Dalam java implementasi method suatu class dapat di ubah oleh sub classnya halini di kenal dengan overriding method.Deklarasi method sama tapi implementasi atau difinisanya berbeda(method/prilaku yang sama tapi implemntasinya /caranya yang berbeda beda inilah yang di sebut polimorfisme)

1.2 Program Pertama
Format sintakpenulisan program java adalah sebagai berikut

Class<nama class>
{
public static void main(String args[])
{
       Stetment;
}
}

Berikut contohnya penulisan coding java

 Class salam
{
public static void main(String args[])
{
       System.out.println("selamat belajar java dengan netbeans");
}
}

setelah anda jalankan klik F6 maka hasilnya kana mencul dengan tulisa
                   
                       selamat belajar java dengan netbeans

 1.6 Apa yang anda butuhkan ?
  1. Editor
  • Text editor(vi,kwrite,notepad,editplus dan editor lainya)
  • IDE (integrated development environment:Netbeans,JBuilder,Eclipse)
     2 .JDK(Java Developmemt Kit)
     3.Documentasi class java/java API
     4.Web browser

VARIABEL DAN OPRATOR
Stetment dan identifier

A.Stetment
Bentuk Statement atau pernyataan dalam suatu program di java adalah sebagai berikut

int i=;
import java.util.Calender;
System.out.println("selamat datang"+teman+"Di blog belajar java dengan netbeans");

pegai.tetap=true;

total=a+b+c+d+e;
sama denagn
total=a+b+c+
          d+e;
Setiap statement selalu di akhiri titik koma(;)

Blok adalah 2 tanda kurung kurawal {} yang menyatukan statement
contoh
{
x=x+1;
y=y +1;
}

Java membolehkan spasi dalam jumlah berapa saja (spasi,tab,baris baru)
contoh
class hello
 {
public static void main(String args[])
{
System.out.prinln("Hello word");
}
}

Bisa juga di tulis dengan bentuk seperti ini
conroh
class hello{ublic static void main(String args[]){ystem.out.prinln("Hello word");}}

B.Identifier
Dalam java ,identifer adalah nama yang di berikan untuk variabel,clas atau method.
identifier hanya boleh di awali dengan huruf,underscore,atau tanda dolar
Identifier adalah case sensitive

contoh

username
User_name
_sys_ver2
$change

JAVA KEYWORD

Java keyword adalah kata-kata/nama yang mempunyai arti khusus yang di kenali oleh java dan tidak boleh di gunakan untuk variabel,method atau class yang akan di buat

Berikut keyword java
abstract  | do |  inplemet |  private | throw | boolean | double  | import | protected | throws | break|  else  instancoef  |  public  |  transient  |  byte  |  extends  |  int  |  return  |  true  case  |  false  |  interface  |  short   |  try  |  catch  |  final  |  long  |  static  |  void  |  char  |  finally  |  native  |