How to open MySQL command line: https://www.tutorialspoint.com/how-to-open-mysql-command-line-on-windows10

Key points:

• Connection between application and database
• How to retrieve the data from database
• How to insert data into database

JBDC - Java Database Connectivity

set path=%path%;C:\mysql-connector-java-5.1.49;

javac -cp "C:\mysql-connector-java-5.1.49\mysql-connector-java-5.1.49-bin.jar;" JDBCExample.java

executeUpdate() : This method is used for execution of DML statement(INSERT, UPDATE and DELETE) which is return int value, count of the affected rows.

executeQuery() : This method is used to retrieve data from database using SELECT query.