CODEWITHSUNDEEP
javamysqljdbcintellij-idea
Nimp
Nimp

Reputation: 471

Use JDBC/Mysql Connector in intellij idea

I'm new in Java, and I need to establish a connection to a MySQL server (local), I have add the libraries in Intellij idea but it seems not work, the IDE can't find the class i think... I become crazy I'm searching since two hours... I come from visual studio/c# dev environment and i think that i should miss something...

Here you can have a pic from my IDE and the simple code that I wanted use. You can also deduce that I have import the jar in my project (mysql-jdbc).

IDE pic

Edit : here is the code, the comment show where the error appear :

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.*;
import org.*;
import com.mysql.jdbc.Driver;


public class JdbcLogin {
    public String Login;
    public String MotDePasse;
    private boolean Logged = false;

    public void StartBdd(){
        String driverName = "com.mysql.jdbc.Driver";
        Class.forName(driverName); // here is the ClassNotFoundException

        String serverName = "localhost";
        String mydatabase = "suptodo";
        String url = "jdbc:mysql://" + serverName + "/" + mydatabase;

        String username = "root";
        String password = "azerty";
        Connection connection = DriverManager.getConnection(url, username, password);
    }
}

Upvotes: 29

Views: 110401

Answers (5)

Pronab Roy
Pronab Roy

Reputation: 1178

It's easy to configure. First just open the IntelliJ IDE and follow this simple step:

File->Project Structure->Libraries

Then click on the plus(+) sign and select From Maven.... enter image description here

After you'll get a search box. There you should put:

mysql:mysql-connector-java:5.1.40

enter image description here

This will solve the issue.

Upvotes: 57

maurapids2396
maurapids2396

Reputation: 19

As an Update this will work with mysql:mysql-connector-java:8.0.18 as the other version will generate a new problem and won't connect to the database server.

Upvotes: 0

Mubarak Tahir
Mubarak Tahir

Reputation: 207

If it says time zone unrecognized you can add this piece of code to the URL:

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost?useTimezone=true&serverTimezone=UTC","USER-NAME","PASSWORD");

Don't forget to wrap it with a try-catch.

Upvotes: 3

renzherl
renzherl

Reputation: 161

Solution#1:Drop the mysql-connector-java-version-bin.jar file to your project, right click on it, select "Add as library".

Solution#2:Build and run with command line, for example(Windows)

  • javac yourclassname
  • java -cp".;mysql-connector-java-version-bin.jar" yourclassname

Upvotes: 6

Mohammed Mukhtar
Mohammed Mukhtar

Reputation: 1741

You have to add 'mysql:mysql-connector-java:5.1.40' from maven or add it as java library as shown:

enter image description here

Upvotes: 36

Related Questions