No suitable driver found for jdbc:mysql://localhost:3306/stu_mis

发生这个错误真的很郁闷呀！！

好在解决了。参考：

http://www.channaly.info/mysql-connectorj-no-suitable-driver-found-for-jdbcmysqllocalhost3306/

虽然现还不懂为什么要注册驱动！

Mysql connector/J : No suitable driver found for jdbc:mysql://localhost:3306/

by admin on May 31st, 2012

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.