java.sql.SQLException:No suitable driver found for http://localhost:3306/school

于 2015-02-11 21:24:00 发布 · 378 阅读

文章标签：

#java #数据库

本文解决了使用Java连接MySQL数据库时出现的错误：找不到适合的驱动。通过将URL配置从'http'改为'jdbc:mysql'，成功解决了问题。

1、错误描述

java.sql.SQLException:No suitable driver found for http://localhost:3306/school

2、错误原因

Class.forName("com.mysql.jdbc.Driver");
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
try 
{
	conn = DriverManager.getConnection("http://localhost:3306/school", "root", "root");
	stat = conn.createStatement();
	stat.execute("");
} 
catch (SQLException e) 
{
	e.printStackTrace();
}

由于连接数据库的URL写的有问题

3、解决办法

将上述“conn = DriverManager.getConnection("http://localhost:3306/school", "root", "root");”改写成“conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/school", "root", "root");”