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

来源:互联网 发布:佛山美工设计 编辑:程序博客网 时间:2024/06/06 03:29

启动项目时出错,错误信息如下:
首先代码没有错误,并且导入了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-8at 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文件夹下,问题解决。

阅读全文
1 0
原创粉丝点击