…
.
Projects :
- Software Analisa Data : CRUD
- File Type : java
- Environtment : Apache Netbeans IDE 17
- Resource : https://github.com/whitecyber-faris/project-dev-2
.
CRUD adalah singkatan dari Create, Read, Update, dan Delete. CRUD adalah operasi dasar yang dapat dilakukan pada data dalam basis data atau aplikasi. CRUD memungkinkan pengguna untuk membuat data baru, membaca data yang ada, mengubah data yang ada, atau menghapus data yang tidak diperlukan. CRUD adalah konsep penting dalam pemrograman web dan pengembangan perangkat lunak.
Source Code :
/*
* Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
* Click nbfs://nbhost/SystemFileSystem/Templates/GUIForms/JFrame.java to edit this template
*/
package form;
/**
*
* @author GK3v
*/
import java.sql.*;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;
public class FrmData extends javax.swing.JFrame {
public Statement st;
public ResultSet rs;
Connection cn = Koneksi.KoneksiDatabase.BukaKoneksi();
int jawab;
public FrmData() {
initComponents();
TampilData();
}
private void Bersih(){
txtNIK.setText("");
txtNama.setText("");
txtTlp.setText("");
txtAlm.setText("");
btnSimpan.setText("Simpan");
txtNIK.setEditable(true);
}
private void CariData(){
try {
st = cn.createStatement();
rs = st.executeQuery("SELECT * FROM biodata WHERE " + cmbCari.getSelectedItem() + " LIKE '%" + txtCari.getText() + "%'" );
DefaultTableModel model = new DefaultTableModel();
model.addColumn("No.");
model.addColumn("NIK");
model.addColumn("Nama");
model.addColumn("Telp");
model.addColumn("Alamat");
int no = 1;
model.getDataVector().removeAllElements();
model.fireTableDataChanged();
model.setRowCount(0);
while (rs.next()) {
Object[] data = {
no ++,
rs.getString("NIK"),
rs.getString("nama"),
rs.getString("telepon"),
rs.getString("alamat")
};
model.addRow(data);
tblData.setModel(model);
}
} catch (Exception e) {
}
}
private void TampilData(){
try {
st = cn.createStatement();
rs = st.executeQuery("SELECT * FROM biodata");
DefaultTableModel model = new DefaultTableModel();
model.addColumn("No.");
model.addColumn("NIK");
model.addColumn("Nama");
model.addColumn("Telp");
model.addColumn("Alamat");
int no = 1;
model.getDataVector().removeAllElements();
model.fireTableDataChanged();
model.setRowCount(0);
while (rs.next()) {
Object[] data = {
no ++,
rs.getString("NIK"),
rs.getString("nama"),
rs.getString("telepon"),
rs.getString("alamat")
};
model.addRow(data);
tblData.setModel(model);
}
} catch (Exception e) {
}
}
/**
* 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();
txtNIK = new javax.swing.JTextField();
txtNama = new javax.swing.JTextField();
txtTlp = new javax.swing.JTextField();
txtAlm = new javax.swing.JTextField();
btnSimpan = new javax.swing.JButton();
btnHapus = new javax.swing.JButton();
btnBatal = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
tblData = new javax.swing.JTable();
jLabel5 = new javax.swing.JLabel();
cmbCari = new javax.swing.JComboBox<>();
txtCari = new javax.swing.JTextField();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jLabel1.setText("NIK");
jLabel2.setText("Nama Lengkap");
jLabel3.setText("No Telp");
jLabel4.setText("Alamat");
btnSimpan.setText("Simpan");
btnSimpan.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnSimpanActionPerformed(evt);
}
});
btnHapus.setText("Hapus");
btnHapus.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnHapusActionPerformed(evt);
}
});
btnBatal.setText("Batal");
btnBatal.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnBatalActionPerformed(evt);
}
});
tblData.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 [] {
"NIK", "Nama", "Telp", "Alamat"
}
));
tblData.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
tblDataMouseClicked(evt);
}
});
jScrollPane1.setViewportView(tblData);
jLabel5.setText("Cari Data");
cmbCari.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "NIK", "nama" }));
txtCari.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
txtCariKeyPressed(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()
.addGap(21, 21, 21)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel4)
.addComponent(jLabel3)
.addComponent(jLabel2)
.addComponent(jLabel1))
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(btnSimpan)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(btnHapus)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(btnBatal))
.addComponent(txtNIK)
.addComponent(txtNama)
.addComponent(txtAlm)
.addComponent(txtTlp))
.addGap(44, 44, 44))
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 375, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel5)
.addGap(18, 18, 18)
.addComponent(cmbCari, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(txtCari)))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(20, 20, 20)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(txtNIK, 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(jLabel2)
.addComponent(txtNama, 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(txtTlp, 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(jLabel4)
.addComponent(txtAlm, 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(btnSimpan)
.addComponent(btnHapus)
.addComponent(btnBatal))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 285, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5)
.addComponent(cmbCari, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(txtCari, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(18, Short.MAX_VALUE))
);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void btnSimpanActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
st = cn.createStatement();
if (txtNIK.getText().equals("") || txtNama.getText().equals("") || txtTlp.getText().equals("") || txtAlm.getText().equals("") ){
JOptionPane.showMessageDialog(null, "Data Tidak Boleh Kosong", "Validasi Data", JOptionPane.INFORMATION_MESSAGE);
return;
}
if (btnSimpan.getText() == "Simpan") {
String cek = "SELECT * FROM biodata WHERE NIK = '" + txtNIK.getText() + "'";
rs = st.executeQuery(cek);
if ( rs.next()) {
JOptionPane.showMessageDialog(null, "Ups... NIK ini sudah ada");
} else {
String sql = "INSERT INTO biodata VALUES ('" + txtNIK.getText() + "','" + txtNama.getText() + "','" + txtTlp.getText() + "','" + txtAlm.getText() + "')";
st.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data Berhasil Disimpan");
Bersih();
TampilData();
}
} else {
// aksi ubah data
String update = "UPDATE biodata SET nama = '" + txtNama.getText() + "', telepon = '" + txtTlp.getText() + "', alamat = '" + txtAlm.getText() + "' WHERE NIK = '" + txtNIK.getText() + "'";
st.executeUpdate(update);
JOptionPane.showMessageDialog(null, "Data Berhasil Diupdate");
Bersih();
TampilData();
}
} catch (Exception e) {
}
}
private void tblDataMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
txtNIK.setText(tblData.getValueAt(tblData.getSelectedRow(), 1).toString());
txtNama.setText(tblData.getValueAt(tblData.getSelectedRow(), 2).toString());
txtTlp.setText(tblData.getValueAt(tblData.getSelectedRow(), 3).toString());
txtAlm.setText(tblData.getValueAt(tblData.getSelectedRow(), 4).toString());
txtNIK.setEditable(false);
btnSimpan.setText("Ubah");
}
private void btnHapusActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if (txtNIK.getText().equals("")) {
JOptionPane.showMessageDialog(this, "Silahkan Pilih Data yang mau dihapus !");
} else {
int jawab = JOptionPane.showConfirmDialog(null, "Data ini akan dihapus, lanjutkan ?", "Konfirmasi", JOptionPane.YES_NO_OPTION);
} if (jawab == 0) {
try {
st = cn.createStatement();
String sql = "DELETE FROM biodata WHERE NIK = '" + txtNIK.getText() + "'";
st.executeUpdate(sql);
JOptionPane.showMessageDialog(null, "Data Berhasil Dihapus");
TampilData();
Bersih();
} catch (Exception e) {
JOptionPane.showMessageDialog(null,e);
}
}
}
private void btnBatalActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
Bersih();
}
private void txtCariKeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
CariData();
}
/**
* @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(FrmData.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(FrmData.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(FrmData.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(FrmData.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 FrmData().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton btnBatal;
private javax.swing.JButton btnHapus;
private javax.swing.JButton btnSimpan;
private javax.swing.JComboBox<String> cmbCari;
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.JScrollPane jScrollPane1;
private javax.swing.JTable tblData;
private javax.swing.JTextField txtAlm;
private javax.swing.JTextField txtCari;
private javax.swing.JTextField txtNIK;
private javax.swing.JTextField txtNama;
private javax.swing.JTextField txtTlp;
// End of variables declaration
}