jdbc localhost mysql,找不到'jdbc：mysql：// localhost：3306 / mysql的合适驱动程序

Using Java, I get this error when attempting to connect to a mysql database:

java.sql.SQLException: No suitable driver found for

jdbc:mysql://localhost:3306/mysql at

java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at MyTest1.main(MyTest1.java:28)

I'm using the mysql-connector-java-5.1.18-bin.jar driver. It is in my build path. I have restarted MySQL. I've also logged on from the command line with root and no password and it connected fine. I'm not currently seeing a port 3306 in netstat. Previously I was getting a different error (I didn't change the code). The error was "jdbc mysql Access denied for user 'root'@'localhost password NO"

try {

Class.forName("com.mysql.jdbc.Driver");

}

catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

try {

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

Connection con = DriverManager.getConnection(url, "root", "");

}

catch (Exception e){

e.printStackTrace();

}

解决方案

In this particular case (assuming that the Class#forName() didn't throw an exception; your code is namely continuing with running instead of throwing the exception), this SQLException means that Driver#acceptsURL() has returned false for any of the loaded drivers.

And indeed, your JDBC URL is wrong:

String url = "'jdbc:mysql://localhost:3306/mysql";

Remove the singlequote:

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

See also: