
Search for IntelliJ download and install the community edition, choosing the drive and directory during setup. Launch IntelliJ, pin it, and use the right-click option to fix issues if needed.
Download and install MySQL community edition on Windows, including MySQL Server, MySQL Workbench, and MySQL Shell, then follow the setup steps and enter your password to finish.
create a JavaFX project in IntelliJ, name it car dash de la, and set up the my source directory. download MySQL connector jar and Java SDK to configure the project.
Configure Java SDK and MySQL Connector jar in the project, set VM options, and add the MySQL Connector as a dependency to run the application.
Demonstrate the two controllers in the welcome app, explain their roles, and show how to register the hello dash view xml with the hello controller.
Create a new JavaFX scene by adding a Java class, a controller, and an FXML, then register the controller and implement node handling with a single function and ID naming.
Explore an alternative approach to add functionality in a JavaFx app by implementing initialize in the controller, wiring a button action to update a label, and sharing logic across controls.
Discover how stage, scene, node, and parent structure a JavaFx app, reuse the same stage for new scenes with different nodes, and organize children inside a left vertical box.
Explain the Halo application by creating an XML loader, loading the hello view from hello view.xml to create a scene, then set the stage and show it.
Delete old parent, create a new main scene, resize to 1200 and 900, set stage max to 1200 and 900, update title to welcome, and add an icon from resources.
Design and style the main scene in JavaFX by updating the anchor pane, adding a welcome label with Arial bold italic 50 font, coloring text, and configuring an image view.
Learn to display images in a JavaFx image view by importing resources, copying image names, and assigning document relative paths, then position views with anchor pane spacing.
Create and customize a JavaFX menu bar in IntelliJ, resize and space it, set a background color from Qtcreator, add a main menu item and embed an image.
Create and connect a new vehicle scene in JavaFX by adding a menu item, creating its controller and FXML, and using Scene Builder to display the scene when clicked.
Clicking a menu item triggers the parent menu bar to load a new scene in the stage, since menu and menu item are children of the menu bar.
Create a menu item that loads the add new vehicle scene from FXML, wires IDs from the Hello view, and resizes the stage to 1200 by 900.
Create a new vehicle scene in JavaFx by building a form layout with labels and text fields, and an image view, using scene builder.
Continue building vehicle form layout in JavaFX by styling fields and the combo box with Arial bold italic 14, setting widths, adding prompts, and buttons for upload, save, main menu.
Learn to space text fields, labels, and a combo box in a JavaFX form using a 3-4-3 layout, with a 25 px field height and prep for IDs.
Create and name IDs for text fields, combo boxes, and buttons in a JavaFX UI using IntelliJ, mapping controls to identifiers like tf_vehicle, combo_condition, and button_upload_picture.
Create a database schema in MySQL Workbench named java fx course and build a vehicle table with vehicle_id, vehicle_name, manufacturer, kilometer_stood, price, and availability.
Create a reusable database connection class with a public static getConnection method returning a JDBC Connection for a MySQL database, enabling reuse and including an image view id for uploads.
Create variables for image view, text fields, a combo box, and buttons in the new vehicle controller, wire them to FXML IDs via Scene Builder, and implement initialize.
Create multiple public static variables to store image path, vehicle name, manufacturer, year, condition, currency, kilometers, price, and pieces, and declare a prepared statement for database operations.
Create observable lists for the vehicle condition and currency combo boxes and populate them with new, used, euro, and dollars in a JavaFx project.
Build a JavaFx vehicle image upload feature using a file chooser, obtain the file path, load the image, and display it in an image view in IntelliJ.
Create a robust JavaFX upload vehicle image feature that opens a file dialog on button click and handles null selections, uploading the image only when a file is chosen.
Create a professional file dialog by setting the title to upload vehicle picture, adding an image extension filter to the file chooser, and using the anchor pane's stage for display.
Create save functionality for the second button by collecting text field and combo box inputs, casting selections to strings, and storing them in string variables in the save event handler.
Validate text field and combo box inputs, show an input error alert if fields are empty or null, and proceed to the next lesson when inputs are valid.
Validate text field input and combo box selection, then convert km to double, price to double, and pieces to integer before saving to the database.
Establish a database connection, handle exceptions, and use a prepared insert statement to save vehicle data into the vehicle table with nine values.
Create a save function in JavaFx by using a prepared statement to set string, double, int, and file input stream parameters, then execute update to insert the vehicle.
Fix the save function by adding a construction year input and supporting a default image when no vehicle image is provided, then override it if an image is uploaded.
Implement a main menu action that loads hello-view.fxml via an FXML loader, updates the anchor pane root, and shows the new main scene on the stage.
Create a new vehicle table view scene in JavaFX by wiring the vehicle table FXML, adding an overview menu, and loading all vehicles from the database into a TableView.
Create a vehicle table scene layout in an fxml project by configuring an anchor pane, a label, and a table view with columns including id, vehicle name, manufacturer, and price.
Continue designing the vehicle table view layout in JavaFX, set width 1165 and height 585, apply three-pixel side margins, adjust the last column, and add a main menu button.
Assign IDs to the table view, each table column, and the menu button; configure the cursor for the vehicle table view in JavaFx with IntelliJ.
Create a model table class for vehicle with string variables for each database column, excluding picture, ensuring exact column names, and generate constructor and getters/setters to support the table view.
Create variables for a JavaFx TableView and its TableColumn instances in a controller, wire them to FXML IDs, and implement initialize method to set up the model table vehicle columns.
Create more variables in a JavaFX project by declaring public static strings, integers, doubles, and a blob, using observable lists and FXCollections to manage a vehicle model table.
Connect to the database, prepare a statement selecting vehicle_id, vehicle_name, manufacturer, construction_year, km, vehicle_condition, price, currency, and availability, and load results into an observable list for a JavaFX TableView.
Fetch records from vehicle table and display them in a JavaFX table view, printing vehicle id, name, manufacturer, year, km, condition, price, currency, and availability, and check the list size.
Fetch vehicle records into an observable list. Display them in a JavaFX TableView by wiring each column to a PropertyValueFactory, including id, manufacturer, year, km, price, currency, and availability.
Style and display records from the vehicle table in a JavaFX table view with IntelliJ, CSS, and FXML, adjusting fonts, colors, and column widths for a polished UI.
Finish getting records from the vehicle table and display them in a TableView by loading the vehicle table FXML with an XML loader and updating the stage and scene.
Create a setOnMouseClicked handler for the vehicle table to capture the selected id from any column and store it in a static variable. Navigate to a new scene on click.
Click a vehicle row in the java fx table to capture its id, then fetch and populate vehicle details with a prepared statement from MySQL.
Implement a setOnMouseClicked handler for the vehicle table in a JavaFX app, retrieving and printing vehicle name, manufacturer, year, km stood, and price from MySQL.
Implement a setOnMouseClicked handler to fetch a vehicle by ID from the table, load a new select vehicle scene with FXMLLoader, and display it in a 1200x900 stage.
Wire the onAction handler for the main menu button in the vehicle table controller to show the start scene, reusing the add new vehicle handler, then run the app.
Create a selected vehicle scene layout, Part 1, in JavaFX using Scene Builder, configuring an anchor pane with labels, text fields, image view, and multiple duplicated controls for vehicle details.
Continue the vehicle scene layout by setting text field and description label heights to 25, adjusting anchor pane spacing and field gaps, and planning to remove the image view.
Continue building the selected vehicle scene in JavaFX with IntelliJ, adjusting button labels, fonts, sizes, colors, and layout spacing, and run the application to preview changes.
Finish creating the selected vehicle scene layout by wiring the image view, text fields, and buttons, assigning IDs, and implementing actions for load picture, save picture, update, and delete.
Select a vehicle by its ID, store it in public static ID_number, fetch related data with a prepared statement, and display it with the vehicle image in selected vehicle controller.
Implement the finish of the selected vehicle function by loading the vehicle image from an input stream into the image view and populating data fields from static variables.
Set up the first button to upload a vehicle image, pass the anchor bean id to the selected vehicle controller, and configure the image view and path to enable upload.
Create save vehicle picture function by validating a selected file, showing an error alert if none, then updating the vehicle picture column via a prepared statement using the vehicle id.
Implement a button-driven update for vehicle data using a prepared statement to update the vehicle table, excluding the vehicle id, and convert inputs from text fields to correct types.
Update vehicle data using a prepared statement by binding string, double, and int parameters, then load the vehicle table scene via an FXML loader in a JavaFX app.
Finish updating vehicle data by testing the save picture and update buttons; verify an error when no picture is uploaded, then upload a new image to update the table view.
Implement a delete workflow in a JavaFX and MySQL app by confirming deletion of the selected vehicle, executing a prepared statement with its ID, and refreshing the vehicle table.
Create a new add new seller menu item in the JavaFX app, assign an icon, wire it to a controller and FXML, and display a new scene when selected.
Create a new seller scene in JavaFX with IntelliJ, configuring anchor pane, title, colors, and image view, and add labeled fields and buttons for name, phone, email, and address.
Style the add new seller scene by configuring button fonts, colors, cursors, and precise dimensions, then adjust layout spacing in the anchor pane.
Assign ids for the seller scene elements in the JavaFx app: image_view_seller, tf_sailor_name, tf_sailor_phone, tf_sailor_email, tf_sailor_address (address prompt), and buttons button_upload_picture, button_save, button_menu.
Create a seller table in the database using MySQL workbench, defining seller_id as an auto-increment integer primary key, plus seller_name, seller_phone, seller_email, seller_address, and a long blob picture.
Create and initialize a JavaFX controller by implementing the interface and initialize method, wiring the image view, text fields, buttons, and anchor to XML IDs from scene builder.
Create and wire the upload seller picture button in a JavaFx app, use a default image and a prepare statement, and show a file dialog to update image view seller.
Implement the save button in the add new seller controller to insert seller name, phone, email, address, and picture into the MySQL database with a prepared statement and input validation.
Finish create save function demonstrates using prepared statements to insert seller data, including name, phone, email, address, and a blob image into MySQL, with error checks and table refresh.
Create the main menu button functionality by wiring an on action event handler in the new controller and displaying the main scene when clicked.
Duplicate the first menu item to create a new seller table item, update its image and id, and resize the image to 35 by 35. Create a new seller table Java class and FXML file, register the controller, and wire an on action to load the new scene with the stage title 'seller table'.
Create a scene stealer table layout in java fx with an anchor pane, label, and table view; include id, name, telephone, email, and address columns; customize fonts and colors.
Finish the layout by adding margins to the table view and button on both sides, remove the label, and assign IDs for the table view, columns, and the button.
Create a model table seller class with fields seller_id, seller_name, seller_phone, seller_email, and seller_address; automatically generate a constructor, getters, and setters, ensuring column names match the database.
Implement the seller table controller by creating and wiring a table view and its columns to the seller model, mapping FXML IDs, and initializing the UI components.
Create and manage variables for prepared statements, result sets, and observable lists, linking to a seller model, and style a JavaFX table view with name, email, phone, and address.
Create a database connection, fetch seller data with a prepared statement, and display it in a JavaFX table view by binding columns to seller_id, seller_name, seller_phone, seller_email, and seller_address.
Create a main menu button for adding sellers by reusing the vehicle table on action, adjust the scrollbar, and show the seller table after saving.
Create a setOnMouseClicked handler for the seller table to capture the selected id, fetch related data, store in static variables, and load the selected seller scene.
Develop a selected seller scene layout in JavaFx, configuring an anchor pane, labels, text fields, and an image view, with id, name, email, and address fields.
Make the seller scene text field non-editable; style buttons with Arial bold italic 16, and set labels for upload picture, save picture, update seller data, and delete seller.
Fine-tune the selected seller scene layout in JavaFX by adjusting label and text field positions with the anchor pane, and set up IDs for image view, text fields, and buttons.
Create IDs for the seller scene in JavaFX with IntelliJ and MySQL; wire anchor bean, image view, and text fields and buttons for upload, save, update, delete, and table.
Explain how to pass a selected table row id in JavaFX, fetch data via a prepared statement, and populate a new controller's image and text fields using public static variables.
Display a selected seller's image in the image view, load it from an input stream with a try-catch, and populate the seller's id, name, phone, email, and address.
Develop and implement a JavaFX upload seller picture feature in IntelliJ, wiring the button to an action handler, showing a file dialog, and updating the seller image view.
Implement a save picture function for a selected seller by updating only the seller picture column via a prepared statement, using a file input stream and id-based targeting.
Implement update seller data in a java fx app using a prepared statement to update name, phone, email, and address for seller by id, via update button in table view.
Update seller data by loading the seller table FXML with an XML loader, then set a fixed 1200 by 900 stage and switch to the seller table view.
implement a delete seller data function in a JavaFx app with IntelliJ and MySQL, using a confirmation alert, delete via prepared statement by id, and refresh the table view.
Wire the seller table button with a new action handler and add exception handling for message load to switch to the table view scene when clicked.
Create a new controller named add new customer, register it in fxml, and add a menu item with an image to switch to the new scene in JavaFX.
Create a click function for the add new customer menu item by wiring its id and adding an action handler. Load the new customer scene from its xml.
Use MySQL workbench to create a new table named customer under your schema, with customer_id as integer primary key autoincrement and columns for customer_name, customer_phone, customer_email, and customer_address.
Create a customer scene layout in JavaFX using scene builder, add prompts for name, phone, email, and address, include an image view, and provide save and main menu buttons.
Finish customer scene layout by adjusting node positions in scene, aligning labels and text fields with the anchor pane, and styling buttons with Arial bold italic and 16 font size.
Create and assign IDs for text fields and buttons in the JavaFX scene, initialize node variables in a new controller, and set up a prepare statement variable.
Create a save function in a JavaFX app with IntelliJ and MySQL that validates customer input, shows an error alert if empty, and inserts into customer table with prepared statement.
Add onAction functionality to the main menu button by reusing the existing method from the new controller, ensuring the button switches to the main scene.
Create a customer table view by loading database records into a JavaFX table view and display it via a new menu item.
Create a customer table scene using an anchor pane layout, adding a 'customer table' label and a table view with id, name, phone, email, and address.
Create IDs for the table view, each table column, and buttons in a JavaFX scene, and prepare a modal table class for our customer.
Create a model table class for the customer by defining column constants (customer_id, customer_name, customer_phone, customer_email, customer_address) and generating a constructor and getters/setters in IntelliJ for a JavaFx MySQL project.
Implement the initialize method by wiring a javafx table view and columns for the customer data, linking fxml ids, and declaring a prepare statement, result set, and an observable list.
Style the TableView by copying and applying the style code to the customer table controller. Rename columns to underscore prefixed names: id, name, phone, email, address, then run the app.
Establish a database connection, prepare and execute a select star from customer, populate an observable list with Customer objects from the result set, and bind data to the table view.
Remove the table scroll bar, set up the main menu button to switch scenes with an action handler, and wire the button to load the main scene.
Load the customer form with an FXML loader, create a root node, set stage size to 1200 by 900, and display the customer table after saving.
Create a setOnMouseClicked handler for the table view to capture selected customer id, fetch name, email, phone, and address via a prepared statement, and switch to the selected customer scene.
Implement setOnMouseClicked on a JavaFx TableView to print customer name, phone, email, and address with System.out.println, then load the selected customer scene via the controller inside a try catch block.
Design and assemble a selected customer scene in java fx using scene builder to configure an anchor pane with labels, text fields, image view, and update, delete, and table actions.
Fine-tune a JavaFX customer scene by making the text field read-only and adjusting layout constraints and padding. Style buttons, set sizes and colors, and assign IDs to enable future functionality.
Wire id fields and variables for text fields and buttons in the JavaFX app, implement the initializer, and manage the selected customer data with static variables and static imports.
Learn to display a selected customer from a table view in a new scene by populating text fields for ID, name, phone, email, and address, converting ID to string.
Update a selected customer's data using a prepared statement, binding name, phone, email, and address, filtered by customer_id from the clicked table view, then switch to the table view scene.
Finish creating the update customer data function in a JavaFX app by wiring the update button to pass the selected customer to the controller and refresh the table view.
Create a delete button with a confirmation alert to remove the customer's data by ID from the database. Execute a prepared delete statement and refresh the customer table view.
Implement the button customer table to change the scene and display the customer table view, via an action event handler, with load method exception handling using try and catch.
Create a new deal workflow in a JavaFX app by adding a Deal class and XML, registering the controller, and configuring a deal menu with an image and do business.
Create a click function for the do business menu item to switch to deal scene, using the menu item id deal and deal.xml resources to update stage to do business.
Create a new scene layout for the deal in JavaFX by configuring deal.xml, scene builder, anchor pane, labels, font size 50, colors, an image view, and related controls.
Configure JavaFX scene elements in IntelliJ by adjusting button styles, sizes, and colors, aligning controls, and setting prompt texts for the combo box and text fields.
Create IDs for all user interface components in the JavaFX app, including combo boxes, a text field, and buttons, using identifiers like combo_code, combo_customer_name, date_day, date_month, tf_date_year, and button_submit.
Implement the interface and initialize method to create node variables in a JavaFX controller. Wire FXML controls (combo boxes, text fields, and buttons) using Scene Builder IDs.
Define numerous variables in a JavaFX and MySQL course, including public prepareStatement, resultSet, static strings for names and dates, a vehicle price, and observable lists.
Fix and align variable names in the fxml and controller for the date day combobox, and set its items to an observable array list of days 1 to 31.
Populate the date month combo box with January through December using an observable array list and fx collections, then set items to display all months in the combo box.
Fetch available vehicle names from the vehicle table using a prepared statement via a MySQL connection, store them in an observable list, and set the combo box items in JavaFX.
Populate a JavaFX combobox with customer names from a MySQL database. Load an observable list data_customer_name, query with a prepared statement, add results, and set the combobox items.
Fetch seller names from the MySQL database using a prepared statement, populate an observable list, and set it as the items for the seller name combobox in JavaFX.
Select a vehicle name from the combo box to fetch its id and pieces from the database using prepared statement, populate the pieces options, and store results in static variables.
Create the getSelectedItemComboVehicleName function to fetch the selected vehicle name from the combo box, cast to string, query the database for vehicle id and basis, and print the results.
Learn how to populate and update a JavaFX combo box with vehicle quantities using a for loop, clear prior items at the start, and debug the getSelectedItemComboVehicleName function.
Create getSelectedItemComboCustomerName function to capture selected customer name from the combo box, store it in public static string variable result_customer_name, and fetch customer_id from database with a prepared statement.
Create a getSelectedItemComboSellerName function in a JavaFx app to capture the selected seller name, query the seller table for its seller_id, print it, and save it to result_seller_ID.
Select a vehicle from the combo box to set the sold quantity with getSelectedVehicleCount. Retrieve the vehicle's price and currency from the database using the vehicle id.
Calculate the total price by multiplying the number of selected vehicles by the single price, store it in the public static double variable result_vehicle_total_price, and format for display.
Implement a submit button action that collects day and month selections from combo boxes and year from a text field, stores them in result_date_day, result_date_month, and result_date_year, and prints them.
present a submit button in a java fx app: validate combo box and year input, show an alert if empty, or switch to scene displaying deal details and total price.
Finish the create submit button function by loading a new Scene with FXMLLoader and updating the Stage and Scene, displaying an alert when no selection is made.
Create main menu functionality by wiring the button to switch scenes via an event handler, passing a message between controllers to return to the main scene in a JavaFX app.
Create a close deal scene layout in scene builder by arranging labels (vehicle name, customer name, sold date, total price), an image view, and two buttons on an anchor bean.
Continue building the close a deal scene in JavaFX by adding an image from resources, styling labels, and configuring buttons with Arial bold italic 16 and 430x60 sizes.
Finalize the deal scene layout by equalizing label heights to 25, aligning them, and setting precise top and left spacing to prepare labels to display data.
Create node IDs for all labels and buttons in the close a deal scene, adjust label background and text colors using Qtcreator, and set layout properties for the UI.
Create node variables in a javafx controller by implementing initialize, use label controls, copy ids from the xml, and wire them to the close deal action and phase one button.
Define public static variables for vehicle, customer, seller, date, and price, create a prepared statement for the id, calculate total price, and import these into the close a deal controller.
Display data in labels by assigning public static variables to each label's text, including vehicle, customer, and seller names, date, and a total price formatted with decimal format and currency.
Implement the button deal click to load the deal fxml, set the scene with root, configure stage 900x1200 and title do business, and show the new scene.
Implement a confirm button that reads the selected vehicle name from combo box, retrieves its id and basis, stores them in public static variables (result_vehicle_name, result_vehicle_id, result_count_of_vehicle), and prints them.
Implement a confirm button in JavaFX that prints ID and count values, validates stock via a query, and updates remaining vehicle pieces in the database.
Update the selected vehicle's pieces in a MySQL database via a JavaFX confirm button using a prepared statement; reduces from 20 to 17 after a sale.
Display only available vehicles in the combo box, update piece counts and availability when selling, and refresh the vehicle list in the database to reflect sold-out status.
Create a MySQL table named 'business' in MySQL Workbench with a primary key and foreign keys for vehicle, customer, and seller, plus sale details.
In this lesson, we set up a database connection and use a prepared statement to insert data into the business table with 11 parameters for IDs, dates, price, and currency.
Learn to insert sales data into the business table by updating vehicle bases, selecting available vehicles and customers, entering date details, submitting and confirming, and returning to the deal scene.
Create monthly and annual statistics for sellers, customers, and car dealer company owners, tracking vehicles sold and total sales for a selected month or year.
Duplicate the last menu, then create a new monthly statistics seller menu item with image view, controller, and FXML, and switch to the new scene.
Create a monthly statistics seller scene layout in scene builder, configuring an anchor pane with labels, fonts, colors, image view, and inputs for month, year, and seller.
Refine monthly statistics seller scene layout by adjusting button size to 430x70, applying Arial bold italic 16, updating background color and cursor to hand, and reconfiguring labels and combo boxes.
Create IDs for all user interface elements including combo_month, textfield_year, combo_seller_name, button_monthly_statistic_seller, button_mean_menu, label_seller_name, label_sell_date, label_vehicles_count, and label_total_sales.
Initialize the JavaFX controller by wiring combo boxes, text fields, buttons, and labels from the monthly statistics seller FXML, and declare prepared statement, results, and an observable data list.
Populate the month and seller name comboboxes in a JavaFX app by querying a MySQL database, filling an observable list, and binding it to the corresponding combo boxes.
Create a button-driven feature to fetch monthly seller statistics by selecting month and seller name and entering the year, using a prepared SQL query against the database.
retrieve monthly seller statistics from a MySQL database using a result set, extract currency, sum count of vehicles, and sum total price, then print each value to the terminal.
Run the application, choose statistics monthly for January 2022 and a seller, click the button to display eight sold pieces and their total price, then verify sums from the database.
Build a JavaFX monthly statistics feature in an IntelliJ workflow, using a while loop and decimal format to show total price, with input validation and alerts when fields are empty.
Create a JavaFx monthly seller statistics feature that shows euro currency, sale counts, and total price, with no sales alerts and null or zero handling.
Select month and seller from combo boxes, input the year, and display seller name, sale date, vehicle count, and total sales formatted with currency.
Create a new on-action event handler for the main menu button in the monthly statistics seller controller to change the scene and display the main scene.
Create a new menu item annual statistics seller in a JavaFX app using Scene Builder and XML, then wire its controller and XML to load the new scene.
Create an annual statistics seller scene layout in JavaFx using Scene Builder, configuring an anchor pane with labels, image view, text fields, a seller name combo box, and action buttons.
Finish the annual statistics seller scene layout by styling button backgrounds and cursor types, adjusting the anchor pane layout, and selectively removing unnecessary text fields, combo boxes, and image views.
Assign IDs for text field tf_year, combo box combo_seller_name, buttons button_annual_statistics_seller and button_main_menu, and labels label_seller_name, label_sale_date, label_vehicles_count, and label_total_sales in the annual statistics seller scene.
Create variables for the node and set items in the seller name combo box, initializing in the annual statistics controller and populating from the seller table.
Create the button annual statistics seller function by reusing monthly logic, removing month input, validating year and seller, and displaying total vehicles sold and total sales for the year.
Create the second main menu button in javafx to handle year changes, show an alert for no sales, clear labels, and display total sales for the selected year.
Create a new menu item annual statistics customer in JavaFX by duplicating the seller item, updating FXML and controller, adding an image, and wiring a click handler to switch scenes.
Design a JavaFX scene with Scene Builder to create the annual statistics customer layout, adding labels, an image view, text fields, a combo box, and buttons, with fonts and colors.
Run the application to verify layout and adjust alignment, style buttons: annual statistics customer and main menu, with font 16 Arial bold italic, 430 by 70, and a hand cursor.
Assign unique ids to the text field, combo box, two buttons, and four labels in the JavaFX scene, using names like tf_year and button_annual_statistics_customer.
Define and initialize node variables in the annual statistics customer controller, binding text field, combo box, button, and label IDs from the XML; prepare statement, result, errors, and data_customer list.
Fetch customer names from the database, store them in an observable list, and populate the combo box with combo_customer_name, verifying three customers in the table.
Create annual statistics for a selected customer by reading the combo box and year, querying currency, total sold vehicles, and total sales, with input validation and main menu navigation.
Create a new menu item for monthly statistics car dealers in a JavaFX app, duplicate the existing item, build a controller and FXML, and wire onAction to load the scene.
Create a JavaFX scene for monthly statistics of car dealers using fxml and scene builder, configuring anchor pane elements, labels, text fields, combo boxes, and image views with styling.
Create and assign IDs for JavaFX controls (combo box, text field, buttons, labels) in the car dealers statistics scene, wiring them in the controller with prepare statement and result set.
Create monthly statistics for car dealers by populating the months combo box, selecting year and currency, and displaying sold count and total price via SQL, plus a main menu navigation.
Create a new menu item and scene for annual statistics car dealers by duplicating the monthly item, updating text, id, image, and controller, and registering it to display the scene.
Create a JavaFX scene layout for annual statistics car dealers in scene builder, using an anchor pane with labels, an image view, text fields, and buttons—annual statistics and main menu.
Create and wire the text field, two buttons, and three labels by assigning ids, set the text field background color, and implement the initializer with public variables.
Create a click function for the annual statistics car dealer button, read year input, fetch currency, sold vehicles, and total sales with a prepared statement, then open the main menu.
Learn to create an executable jar from a JavaFX project in IntelliJ by configuring artifacts and the main class, enabling the car dealer app to run outside the IDE.
Welcome to JavaFx Framework, IntelliJ development environment and MySQL - Advanced course!
In this course, we will create an application to manage car dealerships.
We will create the layout with IntelliJ Scene Builder and the database with MySQL.
You will learn:
1- How to work with IntelliJ development environment
2- How to work with MySQL database and IntelliJ
3- How to create a professional layout with IntelliJ Scene Builder
4- How to create functionality for Node using IntelliJ development environment
5- How to create tables in your database and connect this with your created Node
6- How to query your database (insert, update and delete)
7- Uploading and save images in your database
8- How to create functionality for your IntelliJ Scene Builder layout and database with the IntelliJ development environment
9- How to create statistics(monthly and annually)
Finally, you will learn how to create an executable file from your application.
Everything you need is good programming knowledge for example, classes, methods variables and loops.
This course is not for beginners without programming knowledge.
You will learn how to save the input from your text fields and the selected data from your combo box in your database and
After that you will fetch the data from your database and show it in the combo box, text fields and TableView.
How to create your own file dialog to upload images .
You will also learn how to upload images and show them in ImageView. You will store images from ImageView in your table in your database, retrieve them from your table in your database and show them in ImageView.
In this course, we will use layouts with IntelliJ Scene Builder, application functionality with JavaFx framework, and the MySQL database. and you'll learn how to create statistics for a professional application.
You will also learn how to use IntelliJ Scene Builder to develop professional user interfaces, create menubar menus and menuItem and tableview Combobox Imageview Buttons Labels and Textfield. You'll also learn how to set and change text and background colors, and more.
Let us begin! I would be very happy to welcome you as a course participant today!