JDBC in java part 2 | jdbc connection with MYSQL

Java – JDBC Connection Example (MySQL)
--------------------------------------
Connection with MySQL Driver.

Handling a connection requires following steps:

1) Load the driver
2) Open database connection
3) Close database connection

1) Load JDBC driver
The easiest way to do this is to use Class.forName()
on the class that implements the java.sql.Driver
interface.

Class.forName("com.mysql.jdbc.Driver");

2) Open database connection
After the driver has been registered with the
DriverManager, you can obtain a Connection instance
that is connected to a particular database by
calling DriverManager.getConnection():

Connection connection = DriverManager
.getConnection("jdbc:mysql://localhost:3306/db_name", "root", "password");

Once a Connection is established, it can be
used to create Statement and PreparedStatement
objects, as well as retrieve metadata about
the database.

3) Close database connection
This step is as much important as opening a connection.
Any connection left open is waste of resource and
lead to various exceptions.

Must Watch these two video first of DATABASE
https://www.youtube.com/watch?v=gx22aVIart8&t=1229s
https://www.youtube.com/watch?v=CsSWYybcCYY&t=183s

XAMPP installation for MYSQL
https://www.youtube.com/watch?v=_8yJeLc1xL0&t=215s