发生这个错误真的很郁闷呀!!
好在解决了。参考:
http://www.channaly.info/mysql-connectorj-no-suitable-driver-found-for-jdbcmysqllocalhost3306/
虽然现还不懂为什么要注册驱动!
Mysql connector/J : No suitable driver found for jdbc:mysql://localhost:3306/
I am developing Java servet, JSP and Mysql. I had trouble with using mysql-connector-java-5.0.8-bin.jar driver. I am very new to Java and to make Mysql driver working, It take me quit some time to find out the missing part. I think it would be a good idea to share my experience with those who are new to Java and mysql jdbc driver.
package org.servetapp.controller;
import java.sql.*;
try {
String url = "jdbc:mysql://localhost:3306/mysql";
Connection con = DriverManager.getConnection(url, "root", "pwdR00t");
}
catch (SQLException ex) {
Logger.getLogger(SqlCommandController.class.getName()).log(Level.SEVERE, null, ex);
}
When I run this code I got the following message from SQLException: No suitable driver found for jdbc:mysql://localhost:3306/…
After googling some time I got this working with :
package org.servetapp.controller;
import java.sql.*;
try {
String url = "jdbc:mysql://localhost:3306/mysql";
Class.forName("com.mysql.jdbc.Driver").newInstance(); // register driver.
Connection con = DriverManager.getConnection(url, "root", "pwdR00t");
}
catch (SQLException ex) {
Logger.getLogger(SqlCommandController.class.getName()).log(Level.SEVERE, null, ex);
}
According to official mysql documenthttp://dev.mysql.com/doc/refman/5.1/en/connector-j-usagenotes-connect-drivermanager.html You need to register the driver withClass.forName("com.mysql.jdbc.Driver").newInstance() to use it.