Connect to mysql database using JDBC in java from command line #jdbc

#jdbc #javatomysql #javadatabaseconnectivity #howtoconnectjavatomysql #javaconnection #sqlconnection #database #databaseconnectioninjava

In this video Lesson, I am gonna describe the MySQL Relational Database Management System.
I presume that you are having some knowledge on RDBMS and the MySQL language.

Steps of JDBC Program are as follows :

Allocate a Connection object, for connecting to the database server.
Allocate a Statement object, under the Connection created earlier, for holding a SQL command.
Write a SQL query and execute the query, via the Statement and Connection created.
Process the query result.
Close the Statement and Connection.

Note that there is little programming involved in using JDBC programming. You only have to specify the database-URL, write the MySQL query, and process the query result. The rest of the codes are kind of "standard JDBC program".
Lets try to understand the sql poackage classes and others:
Connection URL: The connection URL for the mysql database is jdbc:mysql://localhost/javaexpert where jdbc is the API, mysql is the database, localhost is the server name on which mysql is running, we may also use IP address, like 3306 is the port number if you change the port number while installing Mysql to your PC and javaExpert is the database name. We may use any database, in such case, we need to replace the javaexpert with your database name.
Username: The default username for the mysql database is root.
Password: It is the password given by the user at the time of installing the mysql database. In this example, we are going to use 0000 as the password.

To Load the jar file by Setting classpath:
Temporary setting

How to set the permanent classpath?

Learn programming languages for beginners, in this youtube channel you will learn such technologies such as python ,Html, css , javascript, php, java & database connection. We are into programming languages training, we run our own institute by the name of Credible Academy.
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Want Learn C Programming Language? Buy C language Training
Don't Wait enroll Now get discount upto : 92% off

------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------

Are You looking for CORE JAVA Training ? Buy JavaExpert Training
Unlock the hurdle of getting good command in programming, Now.

------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
Thanks for Watching,
Follow us on