I am trying to display this SQL query in a table.

String query = "SELECT COUNT(`appointmentId`),EXTRACT(MONTH FROM `start`) FROM `appointment` WHERE YEAR(start) = '" + year + "' GROUP BY EXTRACT(MONTH FROM `start`)";

Unfortunately I cannot alter the database. I am trying to list the total appointments per month on a table or perhaps a TextArea. Any ideas please?


Recommended Answers

The obvious JavaFX way to display a ResultSet is a TableView. You will find lots of examples with a quick Google, such as this one from GitHub

Jump to Post

All 2 Replies

Thank you very much! That helped alot! I really appreciate it!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.