jdbc-javafx

jdbc-javafx: Santa Monica College spring 2014 project

CS 56: Advanced Java Programming & CS 60: Database Concepts and Applications

SQL:

• uses JDBC's Connector/J to connect to a MySQL database
• database has Student and Course tables related by an Enroll table
• DML scripts included, for initializing and populating the database
• uses stored functions to get derived (non-column) data for select statements
• uses stored procedures, triggered on insert and update, to enforce data validation

Java:

• uses JavaFX for UI, with FXML for layout and CSS for styling
• displays a TableView object for each database table in its own Tab
• uses TextField objects to get user input for qualifying select, insert, delete, and update statements
• displays ingoing SQL statements and error messages in TextAreas
• uses custom TableModel, ColumnModel, and DataModel classes to organize the relevant data

Built With

• css
• java
• shell
• windows