IMPLEMENTASI GUI MENGGUNAKAN SWING

 

🔹 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.

java
import 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.

java
public 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.

java
import 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.

java
import 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


Post a Comment

0 Comments