Aplikasi RCUD dengan Java di BlueJ

Assalamualaikum,
Hallo Gaess...

Pada postingan "Membuat Database dengan Java di BlueJ" kita telah belajar membuat database dengan bahasa Pemrograman Java. maka postingan kali ini adalah lanjutannya yaitu membuat aplikasinya.

Sebelum kita mulai RCUD itu apa sih? RCUD adalah kependekan dari Read (Membaca), Create(Membuat), Update(Memperbarui), dan Delete (Menghapus).

Read (Membaca) merupakan sebuah pengertian yang berarti membaca data-data yang telah diinput kedalam database. Dalam pemrograman java biasanya menggunakan JTable.

Create(Membuat) merupakan sebuah kondisi dimana operator memasukan/meng-input data-data kedalam database. Contoh yang paling sering kita jumpai adalah form pendaftaran online.

Update(Memperbarui) merupakan sebuah kondisi dimana operator merubah/meng-edit data pada database. Contoh yang paling sering kita jumpai adalah merubah password email atau media sosial.

Delete(Menghapus) namanya aja menghapus yang pasti menghapus data di database. Nenek-nenek salto sambil foto selfie juga tau keless !!! #mulaiAlay

Ini penampakan dari aplikasinya.. Beekiicooott.. ehh... Cekidooott..

Dan ini adalah Source Code nya...

//import yang dibutuhkan
import java.awt.Component;
import java.awt.Dimension;
import java.awt.HeadlessException;
import java.awt.Toolkit;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

    public class SeminarS2K extends javax.swing.JFrame {
        private Connection con;
        private Statement stat;
        private ResultSet res;
    
        public SeminarS2K() 
        {
            setTitle("Pendaftaran Seminar S2K"); //Tittle pada applikasi
            Tampilan(); //memanggil public void Tampilan();
            koneksi();//memanggil public void Koneksi();
            tabel();//memanggil public void Tabel();
            
            //membuat layout tampil di tengah pada saat di tampilkan
            Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
            Dimension frameSize = getSize();
            setLocation(
            (screenSize.width - frameSize.width) / 2,
            (screenSize.height - frameSize.height) / 2);
        }
        
        public void koneksi() //mengkoneksikan aplikasi dengan database seminar
        {
           try {
               Class.forName("com.mysql.jdbc.Driver");//driver JDBC
               con=DriverManager.getConnection("jdbc:mysql://localhost:3306/seminar", "root", "");//Lokasi dari database
               stat=con.createStatement();
            }
            catch (ClassNotFoundException | SQLException e) {
                JOptionPane.showMessageDialog(null, e);
            }
        }
    
        private void kosongkan() //variabel kosongkan untuk menghapus data yang diinput pada :
        { 
            npm.setText(""); //JTextField NIM
            nma.setText(""); //JTextField Nama
            kls.setText(""); //JTextField kelas
            tlp.setText(""); //JTextField Alamat
            npm.requestFocus(); //kursor kembali ke JTextField NPM
        } 
     
        public void tabel(){
            DefaultTableModel tb = new DefaultTableModel ();
            tb.addColumn("NPM"); //tambahkan NPM pada kolom tabel
            tb.addColumn("Nama"); //tambahkan Nama pada kolom tabel 
            tb.addColumn("Kelas"); //tambahkan Kelas pada kolom tabel
            tb.addColumn("No Telp"); //tambahkan No Telp pada kolom tabel
            tbl.setModel(tb);
            
            try { res=stat.executeQuery("select * from peserta"); 
                while (res.next()) { 
                    tb.addRow(new Object[]{ res.getString("NPM"),
                        res.getString("nama"), 
                        res.getString("kelas"),
                        res.getString("NoTelp") 
                    }  ); 
                }
            }catch (SQLException e) { 
                JOptionPane.showMessageDialog(null, e); 
            } 
        }
                               
        private void Tampilan() 
        {
            jLabel1 = new javax.swing.JLabel();
            jLabel2 = new javax.swing.JLabel();
            jLabel3 = new javax.swing.JLabel();
            jLabel4 = new javax.swing.JLabel();
            npm = new javax.swing.JTextField();
            nma = new javax.swing.JTextField();
            kls = new javax.swing.JTextField();
            tlp = new javax.swing.JTextField();
            Cari = new javax.swing.JButton();
            Reset = new javax.swing.JButton();
            Simpan = new javax.swing.JButton();
            Hapus = new javax.swing.JButton();
            jScrollPane1 = new javax.swing.JScrollPane();
            tbl = new javax.swing.JTable();
            Ganti = new javax.swing.JButton();
            jLabel5 = new javax.swing.JLabel();
            jLabel6 = new javax.swing.JLabel();
            jLabel7 = new javax.swing.JLabel();

            setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

            jLabel1.setText("NPM");
            jLabel2.setText("NAMA");
            jLabel3.setText("Kelas");
            jLabel4.setText("No Telp");
            
            Cari.setText("Cari");
            Cari.addActionListener(new java.awt.event.ActionListener()
            {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                CariActionPerformed(evt);
            }
        }
        );

            Reset.setText("Reset");
            Reset.addActionListener(new java.awt.event.ActionListener() 
            {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                ResetActionPerformed(evt);
            }
        }
        );

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

        Hapus.setText("Hapus");
        Hapus.addActionListener(new java.awt.event.ActionListener() 
        {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                HapusActionPerformed(evt);
            }
        }
        );

        tbl.setGridColor(new java.awt.Color(0, 0, 0));
        jScrollPane1.setViewportView(tbl);

        Ganti.setText("Ganti");
        Ganti.addActionListener(new java.awt.event.ActionListener() 
        {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                GantiActionPerformed(evt);
            }
        }
        );

        jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel5.setText("APLIKASI PENDAFTARAN SEMINAR ");

        jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel6.setText("UNIVERSITAS INDRAPRASTA PGRI");

        jLabel7.setHorizontalAlignment(javax.swing.SwingConstants.CENTER);
        jLabel7.setText("S2K / 2014");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            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, false)
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 554, Short.MAX_VALUE)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(layout.createSequentialGroup()
                            .addComponent(Simpan)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(Ganti)
                            .addGap(14, 14, 14)
                            .addComponent(Hapus))
                        .addGroup(layout.createSequentialGroup()
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                .addComponent(jLabel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(jLabel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(jLabel4, javax.swing.GroupLayout.DEFAULT_SIZE, 43, Short.MAX_VALUE))
                            .addGap(18, 18, 18)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                .addComponent(npm, javax.swing.GroupLayout.DEFAULT_SIZE, 120, Short.MAX_VALUE)
                                .addComponent(nma)
                                .addComponent(kls)
                                .addComponent(tlp))
                            .addGap(18, 18, 18)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                .addComponent(Reset, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(Cari, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                            .addGap(18, 18, 18)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 276, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addComponent(jLabel7, javax.swing.GroupLayout.PREFERRED_SIZE, 276, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 276, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(17, 17, 17)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(npm, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(Cari)
                    .addComponent(jLabel5, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel2)
                            .addComponent(nma, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(Reset))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel3)
                            .addComponent(kls, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel4)
                            .addComponent(tlp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jLabel6, javax.swing.GroupLayout.PREFERRED_SIZE, 22, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jLabel7)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(Simpan)
                    .addComponent(Hapus)
                    .addComponent(Ganti))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 229, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(24, 24, 24))
        );

        pack();
    }                        

    private void CariActionPerformed(java.awt.event.ActionEvent evt) {                                     
      try { 
          koneksi();
          res = stat.executeQuery("select * from peserta where "+ "NPM='"+npm.getText()+"'" );
          if (res.next()) 
          {
              nma.setText(res.getString("nama"));  
              kls.setText(res.getString("kelas"));
              tlp.setText(res.getString("NoTelp"));
            }
            else {
                JOptionPane.showMessageDialog(null, "Data Tidak Ditemukan");
            }
        } catch (SQLException | HeadlessException e) { 
            JOptionPane.showMessageDialog(null, e);
        }       // TODO add your handling code here:
    }                                    

    private void ResetActionPerformed(java.awt.event.ActionEvent evt) {                                      
        kosongkan();        // TODO add your handling code here:
    }                                     

    private void SimpanActionPerformed(java.awt.event.ActionEvent evt) {                                       
        koneksi();
        try {
            stat.executeUpdate("insert into peserta values (" 
            + "'" + npm.getText()+"'," 
            + "'" + nma.getText()+"',"
            + "'" + kls.getText()+"',"
            + "'" + tlp.getText()+ "')" ); 
            kosongkan();
            tabel();
            JOptionPane.showMessageDialog(null, "Berhasil Menyimpan Data");
        }catch (SQLException | HeadlessException e) { 
            JOptionPane.showMessageDialog(null, "Data Belum Lengkap");
        }
    }                                      

    private void GantiActionPerformed(java.awt.event.ActionEvent evt) 
    {                                      
        koneksi();
        try {
            stat.executeUpdate("update peserta set"
            +" NPM='"+npm.getText()+"',"
            +" nama='"+nma.getText()+"'," 
            +" kelas='"+kls.getText()+"',"
            + "NoTelp='"+tlp.getText()+"'" 
            + " where " + "NPM='"+npm.getText()+"'" ); 
            kosongkan();
            tabel();
            JOptionPane.showMessageDialog(null, "Berhasil Mengupdate Data");
        }catch (SQLException | HeadlessException e) { 
            JOptionPane.showMessageDialog(null, "Data Belum Lengkap : "+e);
        }               // TODO add your handling code here:        // TODO add your handling code here:
    }                                     

    private void HapusActionPerformed(java.awt.event.ActionEvent evt) {                                      
       koneksi();
       try {
            stat.executeUpdate("delete from peserta where "
                + "NPM='"+npm.getText()
                +"'" );
            kosongkan();
            tabel();
            JOptionPane.showMessageDialog(null, "Berhasil Dihapus");
        } catch (HeadlessException | SQLException e) {
            JOptionPane.showMessageDialog(null, "Gagal Dihapus/Koneksi Terputus "+e);
        }      // TODO add your handling code here:
    }                                     

    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(SeminarS2K.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(SeminarS2K.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(SeminarS2K.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(SeminarS2K.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new SeminarS2K().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify                     
    private javax.swing.JButton Cari;
    private javax.swing.JButton Ganti;
    private javax.swing.JButton Hapus;
    private javax.swing.JButton Reset;
    private javax.swing.JButton Simpan;
    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.JLabel jLabel7;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextField kls;
    private javax.swing.JTextField nma;
    private javax.swing.JTextField npm;
    private javax.swing.JTable tbl;
    private javax.swing.JTextField tlp;                
}

Sebenarnya codingan diatas gak murni dibuat di BlueJ. Saya membuat design nya dengan menggunakan netbean IDE sisanya dibuat diBlueJ. Menurut saya hal itu tidak jadi masalah karena editor BlueJ hanya bertujuan untuk mengerti dasar-dasar pemrograman java, yang penting memahami algoritma dan logikanya membuat aplikasi RCUD.

Aplikasi tersebut merupakan satu kesatuan dari database yang dibuat sebelumnya. Jadi sebelum menjalankan aplikasinya anda wajib menjalankan source code databasenya.

Ok deh. itu saja dulu. Semoga membatu.

Wassalamualikum Wr.Wb
ryan*/