package com.wfb;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class DBUtil {
private static final String URL = "jdbc.mysql://127.0.0.1:3306/imooc";
private static final String USER = "root";
private static final String PASSWORD = "root";
public static void main(String[] args) throws Exception{
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//获得数据库的链接
Connection conn = DriverManager.getConnection(URL, USER, PASSWORD);
//通过数据库的连接操作数据库,实现增删改查
Statement sta = conn.createStatement();
ResultSet rs = sta.executeQuery("select name from imooc_goddess");
while(rs.next()){
System.out.println(rs.getString("name"));
}
}
}
这是报的异常
Exception in thread "main" java.sql.SQLException: No suitable driver found for jdbc.mysql://127.0.0.1:3306/imooc
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.wfb.DBUtil.main(DBUtil.java:22)
mysql-connector-java-5.1.18-bin.jar已经附加成功了 之前的web 项目可以
现在单独的练习 一直出现问题 数据库 以及表名都没有错误
将驱动加入了:C:\Program Files\Java\jre7\lib\ext中,仍然报错
求大神解答