How to add the JDBC MySQL driver to an Eclipse project?

MySQLMySQLi DatabaseJava 8

To add the JDBC MySQL driver to an Eclipse project, you need to follow the below steps.

The first step is as follows:

Step1: Create a dynamic web project with some name in Eclipse.

Step2: After pressing the Dynamic Web Project, a new window will open. Now give the project name. The screenshot is as follows:

After clicking the Finish button, you will get a project structure. The screenshot is as follows:

Therefore, I have a project name JDBCJarFiles and in WEB-INF, there is a lib folder. You can add JDBC jar files in lib folder. Now, paste the jar files here. The screenshot is as follows:

Now create a Java class to test if it connects to the database or not. First create a class and give class name and click the finish button. The following is the screenshot:

After clicking the finish button, you will get a window like this.

After that write the following code to test the Database connection. Here, we have database name ‘test’, username=’root’ and password is ‘123456’.

The Java code is as follows:

import java.sql.Connection;
import java.sql.DriverManager;
public class JdbcConnectionDemo {
   public static void main(String[] args) {
      String JdbcURL = "jdbc:mysql://localhost:3306/test?useSSL=false";
      String Username = "root";
      String password = "123456";
      Connection con = null;
      try {
         System.out.println("Connecting to database..............."+JdbcURL);
         con=DriverManager.getConnection(JdbcURL, Username, password);
         System.out.println("Connection is successful!!!!!!");
      }
      catch(Exception e) {
         e.printStackTrace();
      }
   }
}

The screenshot of code is as follows:

The following is the output:

Connecting to database...............jdbc:mysql://localhost:3306/test?useSSL=false
Connection is successful!!!!!!

The snapshot of sample output:

raja
Published on 27-Feb-2019 11:19:03
Advertisements