No, you want the logic to be completely separate. I have a rule of thumb that you should be able to run the business logic, which here includes the database operations, without any GUI at all. You should be able to see everything running from a terminal/command line. That makes it easy to keep the logic close to the database.
Robert Ilin wrote:. . . all the database operations are executed on client side. . . . this is not a very good approach
That sounds better.
. . . separate the client side from the server side.
I don't know any FXML, but please explain why you want them out at client side.
So in the client app there will be the FXML files . . .
Please confirm that you have decided the functionality of your app before you tried working out those implementation details.
From what I ve read the server app will be structured as follows . . .
JavaFX FXML is an XML format that enables you to compose JavaFX GUIs in a fashion similar to how you compose web GUIs in HTML.
Quick! Before anybody notices! Cover it up with this tiny ad:
Two software engineers solve most of the world's problems in one K&R sized bookhttps://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton