eclipse导入mysql8.0驱动,如何将JDBC mysql驱动程序添加到Eclipse项目中？

I have downloaded the mysql-connector-java-5.1.24-bin.jar

I have created a lib folder in my project and put the jar in there.

properties of project->build path->add JAR and selected the JAR above.

I still get java.sql.SQLException: No suitable driver found for jdbc:mysql//localhost:3306/mysql

I am using mysql 5.5

The code:

package DBTest;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.sql.*;

import java.util.*;

/**

* Servlet implementation class TenUsers

*/

@WebServlet("/TenUsers")

public class TenUsers extends HttpServlet {

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

PrintWriter out = response.getWriter();

String mySqlUrl = "jdbc:mysql://localhost:3306/mysql";

Properties userInfo = new Properties();

userInfo.put("user", "root");

userInfo.put("password", "SabababArba");

try{

Connection connection = DriverManager.getConnection(mySqlUrl, userInfo);

}catch(Exception e) {

out.println(e);

}

}

}

If I add Class.forName("com.mysql.jdbc.Driver"); before Connection connection = DriverManager.getConnection(mySqlUrl, userInfo); I get java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

解决方案

Try to insert this:

DriverManager.registerDriver(new com.mysql.jdbc.Driver());

before getting the JDBC Connection.