We use Visual Studio Code to write Java to connect to a MySQL database running locally on your computer. The video covers getting the JAR file, checking the SQL, building the Java code to connect, and a good set of try/catch statements.
The first half of the video details installing the JAR file for Java. It is wrong. Select Platform Independent version. Then download the file and put it in a folder, extract and put into a folder.
This video was recorded for my database students at Pittsburgh Technical College.