some question about import jdbc in dos interface

Question

Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver

this is the error, i wanna know how to solve this, the Driver just works on IDEA but it do not work on dos interface.
this is jarFile'path C:\Program Files\Java\jdk1.8.0_172\jre\lib\ext\mysql-connector-java-8.0.12.jar

Answer 1

It seems the mysql connectivity library is not included in the project. Solve the problem following one of the proposed solutions:

MAVEN PROJECTS SOLUTION
Add the mysql-connector dependency to the pom.xml project file:

<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.39</version>
</dependency>
Here you are all the versions: https://mvnrepository.com/artifact/mysql/mysql-connector-java

ALL PROJECTS SOLUTION
Add the jar library manually to the project.

Right Click the project -- > build path -- > configure build path

In Libraries Tab press Add External Jar and Select your jar.

You can find zip for mysql-connector here

Explanation:
When building the project, java throws you an exception because a file (the com.mysql.jdbc.Driver class) from the mysql connectivity library is not found. The solution is adding the library to the project, and java will find the com.mysql.jdbc.Driver