java.sql.SQLExc0019：没有找到适合jdbc的驱动程序：mysql://localhost:3306/tun_recrut

Question

我是新的java和我试图使简单的身份验证界面。

1/MyDBConnection.java

package com.esprit.tunRecrut.util;

    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.SQLException;
    import java.util.logging.Level;
    import java.util.logging.Logger;


        public class MyDBConnection {

            /**
             * Déclaration des variables pour la connexion
             */
            private String url = "jdbc:mysql://localhost:3306/tun_recrut";
            private String login = "root";
            private String pwd = "";
            private static MyDBConnection instance;
            public static Connection connection;

            private MyDBConnection() {
                try {
                    connection = DriverManager.getConnection(url,login,pwd);

                } catch (SQLException ex) {
                    Logger.getLogger(MyDBConnection.class.getName()).log(Level.SEVERE, null, ex);
                }
            }

            public static Connection getConnection() {
                return connection;
            }

            public static MyDBConnection getInstance() {
                if(instance==null)
                    instance = new MyDBConnection();
                return instance;
            }


        }

2/Crud.java

package com.esprit.tunRecrut.util;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;


public class Crud {

    MyDBConnection mc = MyDBConnection.getInstance();

    public boolean execute(String sql){
        try {
            Statement statement = mc.getConnection().createStatement();
            statement.executeUpdate(sql);
            return true;
        } catch (SQLException ex) {
            Logger.getLogger(Crud.class.getName()).log(Level.SEVERE, null, ex);
            return false;
        }
    }

    public ResultSet exeRead(String sql){
        try {
            Statement statement = mc.getConnection().createStatement();
            ResultSet rs;
            rs = statement.executeQuery(sql);
            return rs;
        } catch (SQLException ex) {
            Logger.getLogger(Crud.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }

    }


}

在我的userDao中。JAVA

public User findUserByEmailAndPassword(String email, String password) {


     User user=null;
    try {
        String sql = "SELECT * FROM user WHERE email_address = '" + email + "' AND password = '" + password + "'";
        ResultSet rs = crud.exeRead(sql);
        while (rs.next()) {

            user = new User(rs.getInt("id"), rs.getString("type"), rs.getString("email_address"));

        }
        return user;

    } catch (SQLException ex) {
        Logger.getLogger("Client controller").log(Level.SEVERE, " fail");
       // Logger.getLogger("Client DAO").log(Level.SEVERE, null, ex);
        return null;
    }
}

Answer 1

从这里下载mysql连接器，并将其添加到您的应用程序类路径

Answer 2

如果你想使用'MySql'与Java你需要下载'JConnector'从MySql的网站。之后，您需要设置类路径。您可以使用以下命令

    set CLASSPATH="PathtOfMySqlConnector.jar"

或者你可以像设置Java的bin路径一样设置它。希望能有帮助。

Answer 3

类路径上可能缺少mysql-connector-java-x.x.x.jar