FinalExam - BAD
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106
import javafx.application.Application;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.geometry.Insets;
import javafx.scene.Scene;
import javafx.scene.control.*;
import javafx.scene.layout.BorderPane;
import javafx.scene.layout.VBox;
import javafx.stage.Stage;
import your.package.name.KueDAO;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MainApp extends Application {
private Connection connection;
private JenisKueDAO jenisKueDAO;
private KueDAO kueDAO;
private ObservableList<JenisKue> jenisKueList;
private ObservableList<Kue> kueList;
public static void main(String[] args) {
launch(args);
}
@Override
public void start(Stage primaryStage) {
// Membuat koneksi ke database
try {
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/nama_database", "username", "password");
jenisKueDAO = new JenisKueDAO(connection);
kueDAO = new KueDAO(connection);
} catch (SQLException e) {
e.printStackTrace();
}
// Menginisialisasi data awal
try {
jenisKueList = FXCollections.observableArrayList(jenisKueDAO.getAll());
kueList = FXCollections.observableArrayList(kueDAO.getAll());
} catch (SQLException e) {
e.printStackTrace();
}
// Membuat antarmuka pengguna
BorderPane root = new BorderPane();
root.setPadding(new Insets(10));
TableView<JenisKue> jenisKueTableView = new TableView<>(jenisKueList);
TableColumn<JenisKue, Integer> jenisKueIdColumn = new TableColumn<>("ID");
jenisKueIdColumn.setCellValueFactory(cellData -> cellData.getValue().idProperty().asObject());
TableColumn<JenisKue, String> jenisKueNamaColumn = new TableColumn<>("Nama");
jenisKueNamaColumn.setCellValueFactory(cellData -> cellData.getValue().namaProperty());
jenisKueTableView.getColumns().addAll(jenisKueIdColumn, jenisKueNamaColumn);
TableView<Kue> kueTableView = new TableView<>(kueList);
TableColumn<Kue, Integer> kueIdColumn = new TableColumn<>("ID");
kueIdColumn.setCellValueFactory(cellData -> cellData.getValue().idProperty().asObject());
TableColumn<Kue, String> kueNamaColumn = new TableColumn<>("Nama");
kueNamaColumn.setCellValueFactory(cellData -> cellData.getValue().namaProperty());
TableColumn<Kue, JenisKue> kueJenisColumn = new TableColumn<>("Jenis");
kueJenisColumn.setCellValueFactory(cellData -> cellData.getValue().jenisProperty());
TableColumn<Kue, Integer> kueQtyColumn = new TableColumn<>("Qty");
kueQtyColumn.setCellValueFactory(cellData -> cellData.getValue().qtyProperty().asObject());
TableColumn<Kue, Double> kueHargaJualColumn = new TableColumn<>("Harga Jual");
kueHargaJualColumn.setCellValueFactory(cellData -> cellData.getValue().hargaJualProperty().asObject());
kueTableView.getColumns().addAll(kueIdColumn, kueNamaColumn, kueJenisColumn, kueQtyColumn, kueHargaJualColumn);
Button refreshButton = new Button("Refresh");
refreshButton.setOnAction(event -> {
try {
jenisKueList.setAll(jenisKueDAO.getAll());
kueList.setAll(kueDAO.getAll());
} catch (SQLException e) {
e.printStackTrace();
}
});
VBox vbox = new VBox(10);
vbox.setPadding(new Insets(10));
vbox.getChildren().addAll(refreshButton, jenisKueTableView, kueTableView);
root.setCenter(vbox);
Scene scene = new Scene(root, 800, 600);
primaryStage.setScene(scene);
primaryStage.setTitle("Aplikasi CRUD");
primaryStage.show();
}
@Override
public void stop() {
// Menutup koneksi database saat aplikasi berhenti
try {
if (connection != null && !connection.isClosed()) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Java
INFO