Inserting Data into MySQL using Java

Question

I try to insert data into MySQL using Java and I have error all the time. I use this video to understand how to do to the connection.

This is my Java code:

import java.sql.*;

public class Main {

public static void main(String[] args) {
    // TODO Auto-generated method stub

    Connection conn = null;
    //DriverManager.registerDriver(new com.mysql.jdbc.Driver ());
    try {
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/try1-progrem", "root", "123456");
        Statement st = conn.createStatement();

        String username = "kola";
        String password = "24688642";

        String insert = "INSERT INTO login  VALUES ('"+username+"','"+password+"')";

        st.executeUpdate(insert);
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

}

}

Get the error:

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/try1-progrem at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Main.main(Main.java:11)

And here to SQL image: sql data:

** I learned from YouTube how to make the connection, if there is a good guild, I will glad to take him.

*EDIT1: build

The error is stemming from that Java can't find the MySQL JDBC driver on the classpath. Please include details about your build process. — Tim Biegeleisen, Jul 08 '19 at 09:32
possible duplication : https://stackoverflow.com/questions/5556664/how-to-fix-no-suitable-driver-found-for-jdbcmysql-localhost-dbname-error-w — Elarbi Mohamed Aymen, Jul 08 '19 at 09:33
Put connectorJ (mysql jdbc deriver) on classpath and try BTW, Driver class is also missing here — sitakant, Jul 08 '19 at 09:33
@TimBiegeleisen Or the dirver does not support the used DBMS version — Reporter, Jul 08 '19 at 09:33
add `mysql-connector-java-5.1.39.jar` in your apps classpath — manikant gautam, Jul 08 '19 at 09:34
i add image of the eclipse build ( hope that what you ask for ) — idan, Jul 08 '19 at 11:03

score 0 · Answer 1 · answered Jul 15 '19 at 15:35

To fix this you should follow the steps below:

You need to download the correct ConnectorJ from the link below.
After downloading the correct installer for your machine you will need to run the installer to install only the correct jdbc connector for you. (A series of prompts will lead you to selecting the connector and not all the MySQL downloads)
Then you can put the .jar file (connectorJDBC file) into your classpath appropriately and this should fix your problem as I encountered a similar problem while trying to connect to a SQL server with java.

Hopefully this fixes your problem, comment if it doesn't. :)

ConnectorJ Download

Inserting Data into MySQL using Java

1 Answers1