source code

/*
 * 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 uas;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
/**
 *
 * @author KaeL
 */
public class Study extends javax.swing.JFrame {
private static Connection koneksi; //Koneksi
private DefaultTableModel model; //Model Tabel
    /**
     * Creates new form Study
     */
    public Study() {
        //buat model tabel / header tabel

model=new DefaultTableModel();

this.jTableForm.setModel(model);

model.addColumn("ID");
model.addColumn("NamaSiswa");
model.addColumn("AlamatSiswa");
model.addColumn("KelasSiswa");
        initComponents();
    }

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

        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jTextFieldNama = new javax.swing.JTextField();
        jTextFieldAlamat = new javax.swing.JTextField();
        jTextFieldKelas = new javax.swing.JTextField();
        jLabelKode = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jButtonAdd = new javax.swing.JButton();
        jButtonEdit = new javax.swing.JButton();
        jButtonDelete = new javax.swing.JButton();
        jButtonRefresh = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jLabel1.setText("Nama Siswa");

        jLabel2.setText("Alamat Siswa");

        jLabel3.setText("Kelas Siswa");

        jLabel4.setText("Data Siswa Eresha");

        jLabelKode.setText("0");

        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);
            }
        });
        jScrollPane1.setViewportView(jTable1);

        jButtonAdd.setText("Add");
        jButtonAdd.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButtonAddActionPerformed(evt);
            }
        });

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

        jButtonDelete.setText("Delete");
        jButtonDelete.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButtonDeleteActionPerformed(evt);
            }
        });

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

        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(jLabel1)
                    .addComponent(jLabel2)
                    .addComponent(jLabel3))
                .addGap(78, 78, 78)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel4)
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jTextFieldNama, javax.swing.GroupLayout.PREFERRED_SIZE, 170, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jLabelKode))
                    .addComponent(jTextFieldAlamat, javax.swing.GroupLayout.PREFERRED_SIZE, 170, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jTextFieldKelas, javax.swing.GroupLayout.PREFERRED_SIZE, 170, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addContainerGap(15, Short.MAX_VALUE)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jButtonAdd)
                        .addGap(48, 48, 48)
                        .addComponent(jButtonEdit)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jButtonDelete)
                        .addGap(44, 44, 44)
                        .addComponent(jButtonRefresh))
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 375, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(jTextFieldNama, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabelKode))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel2)
                    .addComponent(jTextFieldAlamat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel3)
                    .addComponent(jTextFieldKelas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 275, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(32, 32, 32)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButtonAdd)
                    .addComponent(jButtonEdit)
                    .addComponent(jButtonDelete)
                    .addComponent(jButtonRefresh))
                .addContainerGap(40, Short.MAX_VALUE))
        );

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

    private void jButtonAddActionPerformed(java.awt.event.ActionEvent evt) {                                         
        // TODO add your handling code here:
        Connection c=buka_koneksi(); //panggil function koneksi

  if("Add".equals(this.jButtonAdd.getText())) //Jika Button Add teks nya Add

 {

 this.jButtonAdd.setText("Save"); //Buat Teks Button Add yaitu Save

 this.jButtonEdit.setText("Cancel");

 this.jButtonDelete.enable(false);

 this.jButtonRefresh.enable(false);

 this.jLabelKode.setText("0"); //Kosongkan Nilai LabelKode

 this.jTextFieldNama.setText("");

 this.jTextFieldAlamat.setText("");

 this.jTextFieldKelas.setText("");

 }else if("Save".equals(this.cmbAdd.getText()))

 {

 //bikin sql query tambah data

 String sqlkode="Insert into anggota (`nama`,`alamat`,`kelas`) "

 + "values ('"+this.jTextFieldNama.getText()+"',"

 + "'"+this.jTextFieldAlamat.getText()+"',"

 + "'"+this.jTextFieldKelas.getText()+"')";

  try { //jalankan query tersebut

 PreparedStatement p2=(PreparedStatement) c.prepareStatement(sqlkode);

 p2.executeUpdate();

 p2.close();

  } catch (SQLException ex) {

  JOptionPane.showMessageDialog(this, "Terjadi kesalahan "+ex.getMessage());

  }

 this.jButtonAdd.setText("Add");

 this.jButtonEdit.setText("Edit");

 this.jButtonDelete.enable(true);

 this.jButtonRefresh.enable(true);

 }else if("Update".equals(this.jButtonAdd.getText()))

 {//bikin query update data

 String sqlkode="Update anggota SET `nama`='"+this.jTextFieldNama.getText()+"',"

 + "`alamat`='"+this.jTextFieldAlamat.getText()+"',"

 + "`tlp`='"+this.jTextFieldKelas.getText()+"' "

 + "Where ID='"+this.jLabelKode.getText()+"'";

  try {

 PreparedStatement p2=(PreparedStatement) c.prepareStatement(sqlkode);

 p2.executeUpdate();

 p2.close();

  } catch (SQLException ex) {

  JOptionPane.showMessageDialog(this, "Terjadi kesalahan "+ex.getMessage());

  }

 this.jButtonAdd.setText("Add");

 this.jButtonEdit.setText("Edit");

 this.jButtonDelete.enable(true);

 this.jButtonRefresh.enable(true);

 }
    }                                         

    private void jButtonEditActionPerformed(java.awt.event.ActionEvent evt) {                                           
        // TODO add your handling code here:
        if("Edit".equals(this.jButtonEdit.getText()))

 {

 this.jButtonAdd.setText("Update");

 this.jButtonEdit.setText("Cancel");

 this.jButtonDelete.enable(false);

 this.jButtonRefresh.enable(false);

 }else if("Cancel".equals(this.jButtonEdit.getText()))

 {

 this.jButtonAdd.setText("Add");

 this.jButtonEdit.setText("Edit");

 this.jButtonDelete.enable(true);

 this.jButtonRefresh.enable(true);

 }
    }                                         

    private void jButtonDeleteActionPerformed(java.awt.event.ActionEvent evt) {                                             
        // TODO add your handling code here:
        Connection c=buka_koneksi();

 String sqlkode="Delete from anggota "

 + "Where ID='"+this.jLabelKode.getText()+"'";

  try {

 PreparedStatement p2=(PreparedStatement) c.prepareStatement(sqlkode);

 p2.executeUpdate();

 p2.close();

  } catch (SQLException ex) {

  JOptionPane.showMessageDialog(this, "Terjadi kesalahan "+ex.getMessage());

  }
    }                                           

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

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

    /**
     * @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(Study.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(Study.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(Study.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(Study.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() {private static Connection buka_koneksi() {

  if (koneksi==null) {

  try {

  String url="jdbc:mysql://localhost:3306/datasiswa"; //nama database datasiswa

  String user="root"; //user mysql

  String password=""; //password mysql



  DriverManager.registerDriver(new com.mysql.jdbc.Driver());

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

  }catch (SQLException t) {

  System.out.println("Error membuat koneksi");

  }

  }

 return koneksi;

  }


    // Variables declaration - do not modify                   
    private javax.swing.JButton jButtonAdd;
    private javax.swing.JButton jButtonDelete;
    private javax.swing.JButton jButtonEdit;
    private javax.swing.JButton jButtonRefresh;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabelKode;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextField jTextFieldAlamat;
    private javax.swing.JTextField jTextFieldKelas;
    private javax.swing.JTextField jTextFieldNama;
    // End of variables declaration                 
}

private void ambil_data_tabel()


  model.getDataVector().removeAllElements();

  model.fireTableDataChanged();

  try { 

  Connection c=buka_koneksi();

  Statement s= c.createStatement();

  String sql="Select * from anggota";

  ResultSet r=s.executeQuery(sql);

 

  while (r.next()) {

  Object[] o=new Object[4];

  o[0]=r.getString("id");

  o[1]=r.getString("nama");

  o[2]=r.getString("alamat");

  o[3]=r.getString("kelas");

 

 

  model.addRow(o);

  }

  r.close();

  s.close();

  ambil_tabel_klik();

  }catch(SQLException e) {

  System.out.println("Terjadi kesalahan "+e.getMessage());

  }

private void ambil_tabel_klik()

{

  int i=this.jTable1.getSelectedRow();

 

  if(i==-1)

  {

  return;

  }

  String kode=(String) model.getValueAt(i, 0);

  this.jLabelKode.setText(kode);

  String nama=(String) model.getValueAt(i, 0);

  this.jTextFieldNama.setText(nama);

  String alamat=(String) model.getValueAt(i, 1); 

  this.jTextFieldAlamat.setText(alamat);

  String tlp=(String) model.getValueAt(i, 2);

  this.jTextFieldKelas.setText(kelas);

}