启动项目时出错,错误信息如下:

首先代码没有错误,并且导入了mysql jar包

public class DbConnection {
//public String url="jdbc:mysql://172.16.52.73:3307/student?useUnicode=true&characterEncoding=UTF-8";
//public String dbpwd="123456";
public String url="jdbc:mysql://localhost:3306/book?useUnicode=true&characterEncoding=UTF-8";
public String dbuser="root";
public String dbpwd="";
public Connection con=null;

public Connection connection() throws SQLException{
try {
con= DriverManager.getConnection(url, dbuser, dbpwd);
return con;
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}

public void close(Connection con,PreparedStatement ps,ResultSet rs) throws SQLException{
if(con!=null){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
}
}


java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/book?useUnicode=true&characterEncoding=UTF-8

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


解决方法是将MySQL-connector-Java-3.1.14-bin.jar的jar包加入C:\Program Files\Java\jre1.6.0_02\lib\ext文件夹下,问题解决。

Logo

更多推荐