Program Java Sederhana Insert Update Delete Database + Login JFrame

Menjawab salah satu thread di forum (http://forum.toufik.web.id/showthread.php?tid=45) tentang membuat program java insert update delete yang terkoneksi dengan database maka saya buat tutorial ini.
yang perlu disiapkan:
Xampp sebagai server databasenya
database ->
Netbeans

Oke langsung aja lihat dulu programnya seperti berikut:

Untuk membuat pertama buat dulu project baru di netbeans lalu tambahkan 2 buah jframe, 1 untuk login dan satunya lagi untuk mengelola data mahasiswa.
cara menambahkan jframe adalah klik kanan pada package lalu pilih new dan pilih jframe from.

setelah itu buat designnya seperti berikut:
Design untuk from login:

dan berikut design untuk from kelola mahasiswa nya....

lalu untuk menghubungkan aplikasi dengan database tambahkan JDBC driver ke library.. caranya klik kanan pada library tambah library dan pilih JDBC drivernya. setelah itu kita bisa mulai kodingnya.

untuk form login masuk ke source dan tambahkan syntax berikut:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 
 *
 * @author TOUFIK HIDAYAT
 * WEBSITE : TOUFIK.WEB.ID
 */
package toufikwebid;

import java.sql.*;
import javax.swing.JOptionPane;
/**
 *
 * @author Achmad
 */
public class Login extends javax.swing.JFrame {
    Connection con;
    Statement stt;
    ResultSet rss;
    
    public Login() {
        initComponents();
        Koneksi();
    }
   
    public void Koneksi(){
    try{
        Class.forName("com.mysql.jdbc.Driver");
        String database = "jdbc:mysql://localhost:3306/db_mahasiswa";
        String user = "root";
        String pass = "123456";
        con = DriverManager.getConnection(database,user,pass);
        stt = con.createStatement();
        }
        catch(ClassNotFoundException e){
        JOptionPane.showMessageDialog(null,"Gagal Koneksi karena "+e.toString(),"Pesan",JOptionPane.ERROR_MESSAGE);
        } catch (SQLException e) {
            JOptionPane.showMessageDialog(null,"Gagal Koneksi karena "+e.toString(),"Pesan",JOptionPane.ERROR_MESSAGE);
        }
    }
    
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">                          
    private void initComponents() {

jLabel1 = new javax.swing.JLabel();
        txtpasword = new javax.swing.JPasswordField();
        txtusername = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        tblmasuk = new javax.swing.JButton();
        tblmasuk1 = new javax.swing.JButton();
        jLabel4 = new javax.swing.JLabel();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("FORM LOGIN");
        getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

jLabel1.setFont(new java.awt.Font("Times New Roman", 0, 24)); // NOI18N
        jLabel1.setText("LOGIN USER!!!!");
        getContentPane().add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(260, 50, -1, -1));
        getContentPane().add(txtpasword, new org.netbeans.lib.awtextra.AbsoluteConstraints(260, 160, 250, -1));
        getContentPane().add(txtusername, new org.netbeans.lib.awtextra.AbsoluteConstraints(260, 120, 250, -1));

jLabel3.setText("Password");
        getContentPane().add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 170, -1, -1));

jLabel2.setText("Username");
        getContentPane().add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 120, -1, -1));

tblmasuk.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
        tblmasuk.setText("LOGIN!");
        tblmasuk.addMouseMotionListener(new java.awt.event.MouseMotionAdapter() {
            public void mouseMoved(java.awt.event.MouseEvent evt) {
                tblmasukMouseMoved(evt);
            }
        });
        tblmasuk.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tblmasukActionPerformed(evt);
            }
        });
        getContentPane().add(tblmasuk, new org.netbeans.lib.awtextra.AbsoluteConstraints(340, 190, -1, -1));

tblmasuk1.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
        tblmasuk1.setText("CANCEL!");
        tblmasuk1.addMouseMotionListener(new java.awt.event.MouseMotionAdapter() {
            public void mouseMoved(java.awt.event.MouseEvent evt) {
                tblmasuk1MouseMoved(evt);
            }
        });
        tblmasuk1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tblmasuk1ActionPerformed(evt);
            }
        });
        getContentPane().add(tblmasuk1, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 190, -1, -1));

jLabel4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/toufikwebid/loginBack.png"))); // NOI18N
        getContentPane().add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(-60, -10, 600, 310));

getAccessibleContext().setAccessibleName("LOGIN COPYRIGHT TOUFIK.WEB.ID");

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

private void tblmasukActionPerformed(java.awt.event.ActionEvent evt) {                                         
        try{
            String sql = "SELECT * FROM user WHERE Username = '"+txtusername.getText()+"' and Password = '"+String.valueOf(txtpasword.getPassword())+"'";
            rss = stt.executeQuery(sql);
            if(rss.next()){
                String user = rss.getString(1);
                String password = rss.getString(2);
                JOptionPane.showMessageDialog(null, "Berhasil Login");
              this.setVisible(false); //Close frame login
     dataMahasiswa mhsForm = new dataMahasiswa();  
     mhsForm.setVisible(true);  
     mhsForm.setLocationRelativeTo(null); 
     
            }else{
                JOptionPane.showMessageDialog(null, "Gagal Login","Pesan",JOptionPane.ERROR_MESSAGE);
            }
        }catch(Exception e){
            e.printStackTrace();
        }
    }

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

}

private void tblmasuk1MouseMoved(java.awt.event.MouseEvent evt) {                                     
        // TODO add your handling code here:
    }

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

/* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {

public void run() {
             Login mhsForm = new Login();  
     mhsForm.setVisible(true);  
     mhsForm.setLocationRelativeTo(null); 
                
          
            }
        });
    }
    // Variables declaration - do not modify                     
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JButton tblmasuk;
    private javax.swing.JButton tblmasuk1;
    private javax.swing.JPasswordField txtpasword;
    private javax.swing.JTextField txtusername;
    // End of variables declaration                   
}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

package toufikwebid;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author toufik
 */
public class dataMahasiswa extends javax.swing.JFrame {
 Connection con;
    Statement stt;
    
    /**
     * Creates new form dataMahasiswa
     */
    public dataMahasiswa() {
        initComponents();
        tampilkandata();
        
    }

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

jLabel2 = new javax.swing.JLabel();
        txtNim = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        cmbJur = new javax.swing.JComboBox();
        rbTidur = new javax.swing.JRadioButton();
        rbNgaji = new javax.swing.JRadioButton();
        rbMusik = new javax.swing.JRadioButton();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        taAlamat = new javax.swing.JTextArea();
        jLabel7 = new javax.swing.JLabel();
        btnInsert = new javax.swing.JButton();
        jScrollPane2 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        txtNama = new javax.swing.JTextField();
        txtAgama = new javax.swing.JTextField();
        jScrollPane3 = new javax.swing.JScrollPane();
        jTextArea1 = new javax.swing.JTextArea();
        jLabel1 = new javax.swing.JLabel();
        btnUpdate = new javax.swing.JButton();
        btnDelete = new javax.swing.JButton();
        jLabel8 = new javax.swing.JLabel();

setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());

jLabel2.setText("NIM                           :");
        getContentPane().add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 104, -1, -1));
        getContentPane().add(txtNim, new org.netbeans.lib.awtextra.AbsoluteConstraints(115, 101, 304, -1));

jLabel3.setText("Nama                       : ");
        getContentPane().add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 135, -1, -1));

jLabel4.setText("Jurusan                   :");
        getContentPane().add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 166, -1, -1));

cmbJur.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Pilih Jurusan", "Sistem Komputer", "Design Grafis", "Akuntansi ", "DLL" }));
        getContentPane().add(cmbJur, new org.netbeans.lib.awtextra.AbsoluteConstraints(115, 163, 304, -1));

rbTidur.setText("Tidur");
        getContentPane().add(rbTidur, new org.netbeans.lib.awtextra.AbsoluteConstraints(280, 190, -1, -1));

rbNgaji.setText("Mengaji");
        getContentPane().add(rbNgaji, new org.netbeans.lib.awtextra.AbsoluteConstraints(200, 190, -1, -1));

rbMusik.setText("Musik");
        getContentPane().add(rbMusik, new org.netbeans.lib.awtextra.AbsoluteConstraints(130, 190, -1, -1));

jLabel5.setText("Hobi                         :");
        getContentPane().add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 190, -1, -1));

jLabel6.setText("Agama                     : ");
        getContentPane().add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 220, -1, -1));

taAlamat.setColumns(20);
        taAlamat.setRows(5);
        jScrollPane1.setViewportView(taAlamat);

getContentPane().add(jScrollPane1, new org.netbeans.lib.awtextra.AbsoluteConstraints(120, 250, 302, -1));

jLabel7.setText("Alamat                     :");
        getContentPane().add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 250, -1, -1));

btnInsert.setText("Insert!");
        btnInsert.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnInsertActionPerformed(evt);
            }
        });
        getContentPane().add(btnInsert, new org.netbeans.lib.awtextra.AbsoluteConstraints(128, 347, -1, -1));

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"
            }
        ));
        jTable1.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jTable1MouseClicked(evt);
            }
        });
        jScrollPane2.setViewportView(jTable1);

getContentPane().add(jScrollPane2, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 393, 630, 91));
        getContentPane().add(txtNama, new org.netbeans.lib.awtextra.AbsoluteConstraints(115, 132, 304, -1));
        getContentPane().add(txtAgama, new org.netbeans.lib.awtextra.AbsoluteConstraints(120, 220, 302, -1));

jTextArea1.setColumns(20);
        jTextArea1.setRows(5);
        jScrollPane3.setViewportView(jTextArea1);

getContentPane().add(jScrollPane3, new org.netbeans.lib.awtextra.AbsoluteConstraints(439, 78, 269, 263));

jLabel1.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N
        jLabel1.setText("KELOLA DATA MAHASISWA");
        getContentPane().add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(86, 0, -1, -1));

btnUpdate.setText("Update!");
        btnUpdate.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnUpdateActionPerformed(evt);
            }
        });
        getContentPane().add(btnUpdate, new org.netbeans.lib.awtextra.AbsoluteConstraints(211, 347, -1, -1));

btnDelete.setText("Delete!");
        btnDelete.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                btnDeleteActionPerformed(evt);
            }
        });
        getContentPane().add(btnDelete, new org.netbeans.lib.awtextra.AbsoluteConstraints(292, 347, -1, -1));

jLabel8.setIcon(new javax.swing.ImageIcon(getClass().getResource("/toufikwebid/digital-waves-2776.jpg"))); // NOI18N
        getContentPane().add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 720, 500));

pack();
    }// </editor-fold>                        
String getHobi()
{
    if(rbMusik.isSelected())
    {
        return "Musik";
    }
    else if(rbNgaji.isSelected())
    {
        return "Mengaji";
    }
    else
    {
        return "Tidur";
    }
}
    private void btnInsertActionPerformed(java.awt.event.ActionEvent evt) {                                          
        
        try{
       String sql = "INSERT INTO datam VALUES('"+txtNim.getText()+"','"+txtNama.getText()+"',"
                    + "'"+(String)cmbJur.getSelectedItem()+"','"+getHobi().toString()+"',"
                    + "'"+txtAgama.getText()+"','"+taAlamat.getText()+"')";         
            stt.executeUpdate(sql);
            JOptionPane.showMessageDialog(null, "Data Mahasiswa Telah di Tambahkan");  
            tampilkandata();
          }
        catch(Exception e){
            JOptionPane.showMessageDialog(null, "Gagal Tambah karena"+e);   
        }
         
    }

private void jTable1MouseClicked(java.awt.event.MouseEvent evt) {                                     
        
        txtNim.enable(false);
        int pilih = jTable1.getSelectedRow();
                if(pilih == -1)
                {
                    return;
                }
                String nim = (String) jTable1.getValueAt(pilih, 0);
                txtNim.setText(nim);
                String nama = (String) jTable1.getValueAt(pilih, 1);
                txtNama.setText(nama);
                String jurusan = (String) jTable1.getValueAt(pilih, 2);
                cmbJur.setSelectedItem(jurusan);
                String hobi = (String) jTable1.getValueAt(pilih, 3);
                if(rbMusik.getText().toString().equals(hobi)){
                    rbMusik.setSelected(rootPaneCheckingEnabled);
                    rbNgaji.setSelected(false);
                    rbTidur.setSelected(false);
                }
                else if(rbNgaji.getText().toString().equals(hobi)){
                    rbNgaji.setSelected(rootPaneCheckingEnabled);
                     rbMusik.setSelected(false);
                    rbTidur.setSelected(false);
                }
                else{
                    rbTidur.setSelected(rootPaneCheckingEnabled);;
                     rbNgaji.setSelected(false);
                     rbMusik.setSelected(false);
                }
                String agama = (String) jTable1.getValueAt(pilih, 4);
                txtAgama.setText(agama);
                String alamat = (String) jTable1.getValueAt(pilih, 5);
                taAlamat.setText(alamat);
                System.out.println(nim+nama+jurusan+hobi+agama+alamat);
                System.out.print(rbMusik.getText());
    }

private void btnUpdateActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
        
         try{
       String sql = "Update datam set nim ='"+txtNim.getText()+"',nama ='"+txtNama.getText()+"',"
                    + "jurusan ='"+(String)cmbJur.getSelectedItem()+"',hobi ='"+getHobi().toString()+"',"
                    + "agama='"+txtAgama.getText()+"',alamat='"+taAlamat.getText()+"' where nim ='"+txtNim.getText()+"'";         
            stt.executeUpdate(sql);
            JOptionPane.showMessageDialog(null, "Data Mahasiswa Telah di Update");  
        tampilkandata();
          }
        catch(Exception e){
            JOptionPane.showMessageDialog(null, "Gagal Update karena"+e);   
        }
    }

private void btnDeleteActionPerformed(java.awt.event.ActionEvent evt) {                                          
        // TODO add your handling code here:
         try{
       String sql = "Delete from datam where nim ='"+txtNim.getText()+"'";         
            stt.executeUpdate(sql);
            JOptionPane.showMessageDialog(null, "Data Mahasiswa Telah di Hapus");  
            tampilkandata();
          }
        catch(Exception e){
            JOptionPane.showMessageDialog(null, "Gagal Hapus karena"+e);   
        }

}

/**
     * @param args the command line arguments
     */
    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(dataMahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(dataMahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(dataMahasiswa.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(dataMahasiswa.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() {
                new dataMahasiswa().setVisible(true);
                
            }
        });
    }
     public void Koneksi(){
    try{
        Class.forName("com.mysql.jdbc.Driver");
        String database = "jdbc:mysql://localhost:3306/db_mahasiswa";
        String user = "root";
        String pass = "123456";
        con = DriverManager.getConnection(database,user,pass);
        stt = con.createStatement();//membuat statement
        }
        catch(Exception e){
        JOptionPane.showMessageDialog(null,"Gagal Koneksi karena "+e.toString(),"Pesan",JOptionPane.ERROR_MESSAGE);
        }
    }
     public void tampilkandata() {
         jTextArea1.setText("");
     DefaultTableModel tabelMhs = new DefaultTableModel();
        tabelMhs.addColumn("Nim");
        tabelMhs.addColumn("Nama");
        tabelMhs.addColumn("Jurusan");
        tabelMhs.addColumn("Hobi");
        tabelMhs.addColumn("Agama");
        tabelMhs.addColumn("Alamat");
        try {
            Koneksi();
            String sql = "select * from datam";
            ResultSet res=stt.executeQuery(sql);
            while (res.next()) {
                tabelMhs.addRow(new Object[]{res.getString(1),res.getString(2),res.getString(3),res.getString(4),res.getString(5),res.getString(6)});
                jTextArea1.append("Nim: "+res.getString(1)+"\nNama :"+res.getString(2)+"\nJurusan: "+res.getString(3)+"\nHobi: "+res.getString(4)+"\nAgama: "+res.getString(5)+"\nAlamat: "+res.getString(6)+"\n==========================\n");
            }
           jTable1.setModel(tabelMhs);
           
        }
        catch(Exception e){
            JOptionPane.showMessageDialog(null, "gagal menampilkan data karena "+e.toString(),"Pesan",JOptionPane.ERROR_MESSAGE);
        }
    
     }

// Variables declaration - do not modify                     
    private javax.swing.JButton btnDelete;
    private javax.swing.JButton btnInsert;
    private javax.swing.JButton btnUpdate;
    private javax.swing.JComboBox cmbJur;
    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.JLabel jLabel8;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextArea jTextArea1;
    private javax.swing.JRadioButton rbMusik;
    private javax.swing.JRadioButton rbNgaji;
    private javax.swing.JRadioButton rbTidur;
    private javax.swing.JTextArea taAlamat;
    private javax.swing.JTextField txtAgama;
    private javax.swing.JTextField txtNama;
    private javax.swing.JTextField txtNim;
    // End of variables declaration                   
}

Males baca?
Download Program jadinya ==> Download Disini
Password RAR : www.toufik.web.id

Sekian Hari ini
Salam Toufik

3 komentar:

rani22 Januari 2015 pukul 05.16
saya sudah coba tapi saat dijalankan muncul tulisan gagal koneksi dan seterusnya... itu kenapa yah?tolong bantuannya kak toufik...
BalasHapus
Balasan
Unknown17 Mei 2015 pukul 05.05
kalau untuk databasenya gimana?
butuh berapa field?
terima kasih
BalasHapus
Balasan

Tambahkan komentar

Ada pertanyaan atau sekedar ninggalin jejak silahkan comment di bawah
==komen anda berarti buat kami==

Statistik

Program Java Sederhana Insert Update Delete Database + Login JFrame

3 komentar:

Popular Posts

Recent Comments