This Java and JavaFX application, developed using IntelliJ IDEA, provides a user-friendly interface for connecting to a MySQL database, generating queries, and viewing query results.
- Seamless integration with MySQL database.
- User-friendly GUI for query generation.
- Real-time display of query results on the interface.
- Java Development Kit (JDK) installed.
- MySQL Server and MySQL Connector/J set up.
- IntelliJ IDEA IDE installed.
-
Clone or download the repository to your local machine.
-
Open the project in IntelliJ IDEA.
-
Set up the MySQL database connection in the
DatabaseConnector.javafile by providing the necessary connection details. -
Execute the sql schema files.
-
Add credentials in
.propertiesfiles -
Launch the application and Enter the desired query in the provided input fields.
-
Click the "Execute" button to execute the query.
-
View the query results displayed on the interface.
You can customize the application according to your specific requirements. Feel free to modify the GUI design, add additional features, or enhance the query execution logic as needed.
This application relies on the following dependencies:
- JavaFX: The JavaFX library is required for building the graphical user interface.
- MySQL Connector/J: The MySQL Connector/J library is used for connecting to the MySQL database.
- MySQL Workbench: A Free RDBMS.
Please ensure that these dependencies are properly set up in your project.
This project is licensed under the MIT License.