🔹 Struktur Aplikasi
Aplikasi ini tetap menggunakan OOP, hanya saja kita menambahkan Swing untuk antarmuka grafis.
Struktur kode tetap sama, hanya ditambahkan:
MainFrame→ GUI utama untuk menampilkan tabel siswa dan form input.- Event Handling → Menghubungkan GUI dengan
SiswaDAO.
1️⃣ KoneksiDB.java (Koneksi ke MySQL)
Tetap sama seperti sebelumnya.
javaimport java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class KoneksiDB {
private static final String URL = "jdbc:mysql://localhost:3306/db_siswa";
private static final String USER = "root";
private static final String PASSWORD = "";
public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(URL, USER, PASSWORD);
} catch (SQLException e) {
System.out.println("Koneksi gagal: " + e.getMessage());
}
return conn;
}
}
2️⃣ Siswa.java (Model Data Siswa)
Tetap sama seperti sebelumnya.
javapublic class Siswa {
private int id;
private String nama;
private int usia;
public Siswa(int id, String nama, int usia) {
this.id = id;
this.nama = nama;
this.usia = usia;
}
public int getId() {
return id;
}
public String getNama() {
return nama;
}
public void setNama(String nama) {
this.nama = nama;
}
public int getUsia() {
return usia;
}
public void setUsia(int usia) {
this.usia = usia;
}
}
3️⃣ SiswaDAO.java (Operasi CRUD di MySQL)
Tetap sama, hanya ditambahkan fungsi getById() untuk mendapatkan data spesifik.
javaimport java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class SiswaDAO {
public void tambahSiswa(String nama, int usia) {
String query = "INSERT INTO siswa (nama, usia) VALUES (?, ?)";
try (Connection conn = KoneksiDB.getConnection();
PreparedStatement stmt = conn.prepareStatement(query)) {
stmt.setString(1, nama);
stmt.setInt(2, usia);
stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
public List<Siswa> getAllSiswa() {
List<Siswa> daftarSiswa = new ArrayList<>();
String query = "SELECT * FROM siswa";
try (Connection conn = KoneksiDB.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(query)) {
while (rs.next()) {
daftarSiswa.add(new Siswa(rs.getInt("id"), rs.getString("nama"), rs.getInt("usia")));
}
} catch (SQLException e) {
e.printStackTrace();
}
return daftarSiswa;
}
public void updateSiswa(int id, String nama, int usia) {
String query = "UPDATE siswa SET nama=?, usia=? WHERE id=?";
try (Connection conn = KoneksiDB.getConnection();
PreparedStatement stmt = conn.prepareStatement(query)) {
stmt.setString(1, nama);
stmt.setInt(2, usia);
stmt.setInt(3, id);
stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void hapusSiswa(int id) {
String query = "DELETE FROM siswa WHERE id=?";
try (Connection conn = KoneksiDB.getConnection();
PreparedStatement stmt = conn.prepareStatement(query)) {
stmt.setInt(1, id);
stmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}
public Siswa getById(int id) {
String query = "SELECT * FROM siswa WHERE id=?";
try (Connection conn = KoneksiDB.getConnection();
PreparedStatement stmt = conn.prepareStatement(query)) {
stmt.setInt(1, id);
ResultSet rs = stmt.executeQuery();
if (rs.next()) {
return new Siswa(rs.getInt("id"), rs.getString("nama"), rs.getInt("usia"));
}
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}
4️⃣ MainFrame.java (Tampilan GUI)
Gunakan JTable untuk menampilkan daftar siswa & tombol CRUD.
javaimport javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.List;
public class MainFrame extends JFrame {
private SiswaDAO siswaDAO = new SiswaDAO();
private JTable table;
private DefaultTableModel tableModel;
private JTextField txtNama, txtUsia;
private JButton btnTambah, btnEdit, btnHapus;
public MainFrame() {
setTitle("Manajemen Data Siswa");
setSize(500, 400);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setLayout(new BorderLayout());
// Table
tableModel = new DefaultTableModel(new String[]{"ID", "Nama", "Usia"}, 0);
table = new JTable(tableModel);
loadTable();
// Form Input
JPanel panelForm = new JPanel(new GridLayout(3, 2));
panelForm.add(new JLabel("Nama:"));
txtNama = new JTextField();
panelForm.add(txtNama);
panelForm.add(new JLabel("Usia:"));
txtUsia = new JTextField();
panelForm.add(txtUsia);
// Tombol CRUD
JPanel panelButton = new JPanel(new FlowLayout());
btnTambah = new JButton("Tambah");
btnEdit = new JButton("Edit");
btnHapus = new JButton("Hapus");
panelButton.add(btnTambah);
panelButton.add(btnEdit);
panelButton.add(btnHapus);
// Event Listener
btnTambah.addActionListener(e -> tambahSiswa());
btnEdit.addActionListener(e -> editSiswa());
btnHapus.addActionListener(e -> hapusSiswa());
add(new JScrollPane(table), BorderLayout.CENTER);
add(panelForm, BorderLayout.NORTH);
add(panelButton, BorderLayout.SOUTH);
}
private void loadTable() {
tableModel.setRowCount(0);
List<Siswa> siswaList = siswaDAO.getAllSiswa();
for (Siswa s : siswaList) {
tableModel.addRow(new Object[]{s.getId(), s.getNama(), s.getUsia()});
}
}
private void tambahSiswa() {
String nama = txtNama.getText();
int usia = Integer.parseInt(txtUsia.getText());
siswaDAO.tambahSiswa(nama, usia);
loadTable();
}
private void editSiswa() {
int selectedRow = table.getSelectedRow();
if (selectedRow >= 0) {
int id = (int) tableModel.getValueAt(selectedRow, 0);
String nama = txtNama.getText();
int usia = Integer.parseInt(txtUsia.getText());
siswaDAO.updateSiswa(id, nama, usia);
loadTable();
}
}
private void hapusSiswa() {
int selectedRow = table.getSelectedRow();
if (selectedRow >= 0) {
int id = (int) tableModel.getValueAt(selectedRow, 0);
siswaDAO.hapusSiswa(id);
loadTable();
}
}
public static void main(String[] args) {
SwingUtilities.invokeLater(() -> new MainFrame().setVisible(true));
}
}
📌 Kesimpulan
✅ CRUD dengan MySQL terintegrasi dengan GUI (Swing)
✅ Data disajikan dalam tabel dengan JTable
✅ Fungsi CRUD dapat diakses dengan tombol
0 Comments