java.sql.SQLException:没有为jdbc:mysql://localhost:3306/tun_3306找到合适的驱动程序

Question

我是java的新手，我正在尝试制作简单的身份验证接口。

我正在尝试使用DriverManager执行简单的查询。你能帮我理解一下这里有什么问题吗？

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-连接器-java-x.jar

Answer 2

如果你想在Java中使用'MySql‘，你需要从MySql的网站下载'JConnector’。之后，您需要设置“Classpath”。您可以使用以下命令

    set CLASSPATH="PathtOfMySqlConnector.jar"

或者你可以设置它，你可以设置Java的bin路径。希望能帮上忙。

Answer 3

从这里下载mysql-连接器并将其添加到应用程序类路径中。

也许你会发现这个本教程