How to create a user directory?

Question

Java

I want to create an application on a computer, a kind of user guide, so that you can create a user and enter him into the database, delete, edit his data. Even familiar with the basics of DDL, DML, etc.
A kind of - Todo list only on your computer.
The Internet is full of information about how to create a database, but about how to cut and connect the whole application to this database and the interface and logic in java, this is a problem. That is, to make the interface separately, to make the database separately, everything is clear what is possible. The question is - how to connect all this between each other, the interface logic in java and the database. For example, when I click, I can access the database and do some manipulation. Or I don't understand something? Who writes programs for wasps, please - enlighten me where to start and how to move. Maybe I wrote nonsense, I don’t know ...

Answer 1

Good afternoon!
Well, firstly, specify whether the database should be local or you can store user data remotely.
If the database must be local, then look towards sqlite, it is even possible to use embedded db (h2, postgres, etc.). Next, decide on ORM technology. For example, hibernate, eclipselink, ormlite, room, etc.
Now, regarding the interface: you can use JavaFX.
If I had to write in Java, I would choose Spring + JavaFX. In Spring, I would add all the necessary dependencies like hibernate, spring data, etc.
If the database is remote, then on the same Spring you need to raise a restful service that will create accounts for users, implement crud records, etc. This will result in a client-server application