UTS Perancangan Perangkat Lunak

package Sistem_Informasi_Penjualan_Motor;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.Statement;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

import javax.swing.table.DefaultTableModel;

public class Data_Kendaraan extends javax.swing.JFrame {

    private DefaultTableModel tabmode;

    public Connection conn;

    public ResultSet rs;

    public PreparedStatement pst;

public Data_Kendaraan() throws SQLException {

        initComponents();

        conn = null;

        conn = DriverManager.getConnection("jdbc:mysql://localhost/penjualanmotor","root","");

        UpdateTabel();

        setLocationRelativeTo(null);

    }

private void UpdateTabel() {

        try {

            String sql = "SELECT * FROM tb_kendaraan;";

            pst = conn.prepareStatement(sql);

            rs = pst.executeQuery();

            DefaultTableModel dtm = (DefaultTableModel)tabel_data.getModel();

        dtm.setRowCount(0);

        String [] data = new String[5];

        int i = 1;

      

        while(rs.next()) {

            data[0] = rs.getString("kode_kendaraan");

            data[1] = rs.getString("merek_motor");

            data[2] = rs.getString("penyedia");

            data[3] = rs.getString("harga");

            data[4] = rs.getString("tgl_input");

           

            dtm.addRow(data);

            i++;

        }

        }

        catch (Exception e) {

            JOptionPane.showMessageDialog(null, e);

        }

    }

private void hapus_text() {

            txtkode.setText("");

            txtmerek.setText("");

            txtpenyedia.setText("");

            txtharga.setText("");

            txttanggal.setText("");

        }

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

if(txtkode.getText().trim().equals("")){

            JOptionPane.showMessageDialog(null,"Maaf, KODE belum di isi!");

            txtkode.requestFocus();

        }

        else if(txtmerek.getText().trim().equals("")){

            JOptionPane.showMessageDialog(null,"Maaf, MEREK MOTOR belum di isi!");

            txtmerek.requestFocus();

        }

        else if(txtpenyedia.getText().trim().equals("")){

            JOptionPane.showMessageDialog(null,"Maaf, PENYEDIA belum di isi!");

            txtpenyedia.requestFocus();

           

        }

        else if(txtharga.getText().trim().equals("")){

            JOptionPane.showMessageDialog(null,"Maaf, HARGA belum di isi!");

            txtharga.requestFocus();

        }

        else if(txttanggal.getText().trim().equals("")){

            JOptionPane.showMessageDialog(null,"Maaf, Tanggal belum di isi!");

            txttanggal.requestFocus();

        }

        else{

            String kode = "", merek = "", penyedia = "", harga="", tanggal="";

            try {

                Connection con = new koneksi().getConnection();

                kode = txtkode.getText();

                merek = txtmerek.getText();

                penyedia = txtpenyedia.getText();

                harga = txtharga.getText();

                tanggal = txttanggal.getText();

                String sql = "insert into tb_kendaraan values('"+kode+"','"+merek+"','"+penyedia+"','"+harga+"','"+tanggal+"')";

                Statement st = con.createStatement();

                st.executeUpdate(sql);

                JOptionPane.showMessageDialog(null, "Data BERHASIL tersimpan" , "Informasi", JOptionPane.INFORMATION_MESSAGE);

                UpdateTabel();

            } catch (Exception e) {

                JOptionPane.showMessageDialog(null, "Data GAGAL tersimpan" , "Informasi", JOptionPane.INFORMATION_MESSAGE);

            }

        }

}

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

        // TODO add your handling code here:

        String kodek = txtkode.getText();

         try {

               

                Connection con = new koneksi().getConnection();

                String sql = ("delete from tb_kendaraan where kode_kendaraan=('"+kodek+"');");

               

                Statement st = con.createStatement();

                st.executeUpdate(sql);

                JOptionPane.showMessageDialog(null, "Data BERHASIL DiHapus" , "Informasi", JOptionPane.INFORMATION_MESSAGE);

                hapus_text();

               

                UpdateTabel();

            } catch (Exception e) {

                JOptionPane.showMessageDialog(null, "Data GAGAL DiHapus" , "Informasi", JOptionPane.INFORMATION_MESSAGE);

            }

    }

private void tabel_dataMouseClicked(java.awt.event.MouseEvent evt) {                                       

        // TODO add your handling code here:

        int row = tabel_data.getSelectedRow();

            txtkode.setText((String)tabel_data.getValueAt(row, 0));

            txtmerek.setText((String)tabel_data.getValueAt(row, 1));

            txtpenyedia.setText((String)tabel_data.getValueAt(row, 2));

            txtharga.setText((String)tabel_data.getValueAt(row, 3));

            txttanggal.setText((String)tabel_data.getValueAt(row, 4));

    } 

public static void main(String args[]) {

        /* Set the Nimbus look and feel */

        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">

        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.

         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html

         */

        try {

            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {

                if ("Nimbus".equals(info.getName())) {

                    javax.swing.UIManager.setLookAndFeel(info.getClassName());

                    break;

                }

            }

        } catch (ClassNotFoundException ex) {

            java.util.logging.Logger.getLogger(Data_Kendaraan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (InstantiationException ex) {

            java.util.logging.Logger.getLogger(Data_Kendaraan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (IllegalAccessException ex) {

            java.util.logging.Logger.getLogger(Data_Kendaraan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        } catch (javax.swing.UnsupportedLookAndFeelException ex) {

            java.util.logging.Logger.getLogger(Data_Kendaraan.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);

        }

        //</editor-fold>

       

        /* Create and display the form */

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

            public void run() {

                try {

                    new Data_Kendaraan().setVisible(true);

                } catch (SQLException ex) {

                    Logger.getLogger(Data_Kendaraan.class.getName()).log(Level.SEVERE, null, ex);

                }

            }

        });

    }

    // Variables declaration - do not modify                    

    private javax.swing.JButton btndelete;

    private javax.swing.JButton btnedit;

    private javax.swing.JButton btninput;

    private javax.swing.JButton btnreset;

    private javax.swing.JLabel jLabel1;

    private javax.swing.JLabel jLabel2;

    private javax.swing.JLabel jLabel3;

    private javax.swing.JLabel jLabel4;

    private javax.swing.JLabel jLabel5;

    private javax.swing.JLabel jLabel6;

    private javax.swing.JPanel jPanel1;

    private javax.swing.JPanel jPanel2;

    private javax.swing.JScrollPane jScrollPane1;

    private javax.swing.JTable tabel_data;

    private javax.swing.JTextField txtharga;

    private javax.swing.JTextField txtkode;

    private javax.swing.JTextField txtmerek;

    private javax.swing.JTextField txtpenyedia;

    private javax.swing.JTextField txttanggal;

    // End of variables declaration                  

}