Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class ViewSubject extends Application {
- private final TableView<Subject> table = new TableView<>();
- private final ObservableList<Subject> data
- = FXCollections.observableArrayList();
- final HBox hb = new HBox();
- private Connection connect = null;
- private Statement statement = null;
- private final PreparedStatement preparedStatement = null;
- private ResultSet resultSet = null;
- public static void main(String[] args) {
- launch(args);
- }
- @Override
- public void start(Stage stage) throws ClassNotFoundException, SQLException {
- Scene scene = new Scene(new Group());
- stage.setTitle("Add Subject");
- stage.setWidth(650);
- stage.setHeight(550);
- stage.setResizable(false);
- final Label label = new Label("Subject Details");
- label.setFont(new Font("Calibri", 20));
- TableColumn sub = new TableColumn("Subject Name");
- sub.setMinWidth(350);
- sub.setCellValueFactory(
- new PropertyValueFactory<Subject, String>("subName"));
- sub.setCellFactory(TextFieldTableCell.forTableColumn());
- sub.setOnEditCommit(
- new EventHandler<TableColumn.CellEditEvent<Subject, String>>() {
- @Override
- public void handle(TableColumn.CellEditEvent<Subject, String> t) {
- ((Subject) t.getTableView().getItems().get(
- t.getTablePosition().getRow())).setSubName(t.getNewValue());
- }
- }
- );
- TableColumn code = new TableColumn("Subject Code");
- code.setMinWidth(130);
- code.setCellValueFactory(
- new PropertyValueFactory<Subject, String>("subCode"));
- code.setCellFactory(TextFieldTableCell.forTableColumn());
- code.setCellFactory(TextFieldTableCell.forTableColumn());
- code.setOnEditCommit(
- new EventHandler<TableColumn.CellEditEvent<Subject, String>>() {
- @Override
- public void handle(TableColumn.CellEditEvent<Subject, String> t) {
- ((Subject) t.getTableView().getItems().get(
- t.getTablePosition().getRow())).setSubCode(t.getNewValue());
- }
- }
- );
- TableColumn rev = new TableColumn("Revision");
- rev.setMinWidth(130);
- rev.setCellValueFactory(
- new PropertyValueFactory<Subject, String>("subRev"));
- rev.setCellFactory(TextFieldTableCell.forTableColumn());
- rev.setCellFactory(TextFieldTableCell.forTableColumn());
- rev.setOnEditCommit(
- new EventHandler<TableColumn.CellEditEvent<Subject, String>>() {
- @Override
- public void handle(TableColumn.CellEditEvent<Subject, String> t) {
- ((Subject) t.getTableView().getItems().get(
- t.getTablePosition().getRow())).setSubCode(t.getNewValue());
- }
- }
- );
- table.setItems(data);
- table.getColumns().addAll(sub, code, rev);
- final VBox vbox = new VBox();
- vbox.setSpacing(10);
- vbox.setPadding(new Insets(20, 20, 20, 20));
- vbox.getChildren().addAll(label, table);
- ((Group) scene.getRoot()).getChildren().addAll(vbox);
- stage.setScene(scene);
- stage.show();
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager
- .getConnection("jdbc:mysql://localhost:3306/project?"
- + "user=root&password=virus");
- statement = connect.createStatement();
- resultSet = statement
- .executeQuery("select * from subject");
- writeResultSet(resultSet);
- } catch (ClassNotFoundException | SQLException e) {
- throw e;
- } finally {
- close();
- }
- }
- private void writeResultSet(ResultSet resultSet) throws SQLException {
- while (resultSet.next()) {
- String subname = resultSet.getString("subname");
- String code = resultSet.getString("subcode");
- String rev = resultSet.getString("subrev");
- data.add(new Subject(subname, code, rev));
- }
- }
- private void close() {
- try {
- if (resultSet != null) {
- resultSet.close();
- }
- if (statement != null) {
- statement.close();
- }
- if (connect != null) {
- connect.close();
- }
- } catch (SQLException e) {
- }
- }
- }
- public class Subject {
- private final SimpleStringProperty sub;
- private final SimpleStringProperty code;
- private final SimpleStringProperty rev;
- Subject(String subName, String subCode, String subRev) {
- this.sub = new SimpleStringProperty(subName);
- this.code = new SimpleStringProperty(subCode);
- this.rev = new SimpleStringProperty(subRev);
- }
- public String getSubName() {
- return sub.get();
- }
- public void setSubName(String subName) {
- sub.set(subName);
- }
- public String getSubCode() {
- return code.get();
- }
- public void setSubCode(String subCode) {
- code.set(subCode);
- }
- public String getSubRev() {
- return rev.get();
- }
- public void setSubRev(String subRev) {
- rev.set(subRev);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement