Java程序连接mysql时出错是为什么？

[spoonling55]

mysql-connector-java-5.0.8-bin.jar驱动包放在C:\jdk1.6.0_12\jre\lib\ext下
classpath:.;C:\Tomcat 6.0\lib\mysql-connector-java-5.0.8-bin.jar;C:\jdk1.6.0_12\jre\lib\ext\mysql-connector-java-5.0.8-bin.jar;C:\Tomcat 6.0\lib\servlet-api.jar;%JAVA_HOME%\lib\tools.jar;%JAVA_HOME%\lib\dt.jar;

程序如下：

import java.sql.*;

public class Test
{
public static void main(String[] args)
{
String url = "jdbc:mysql://localhost/coffeebreak";
//jdbc:mysql://127.0.0.1:3306/coffeebreak
Connection con;
String createString;
createString = "create table COFFEES"+
"(COF_NAME varchar(32),"+
"SUP_ID int,"+
"PRICE float,"+
"SALES int,"+
"TOTAL int)";
Statement stmt;
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.print("ClassNotFoundException:");
System.err.println(e.getMessage());
}
try
{
con = DriverManager.getConnection(url,"root","admin");
stmt = con.createStatement();
stmt.executeUpdate(createString);
stmt.close();
con.close();
}
catch(SQLException e)
{
System.err.println("SQLException"+e.getMessage());
}
}
}

编译，运行java Test后
SQLExceptionUnknown database "coffeebreak"

这是为什么呢？是不是我的mysql没有启动？怎么启动？还是jdbc驱动没有加载上？怎么加载？

[spoonling55]

我是新手，望高手指点，感谢感谢

[shadow55]

SQLExceptionUnknown database "coffeebreak" 找不到数据库啊，
jdbc:mysql://localhost/coffeebreak ---->jdbc:mysql://localhost:3306/coffeebreak

[spoonling55]

这回我加上了jdbc:mysql://localhost:3306/coffeebreak中的3306为什么还是出现SQLExceptionUnknown database "coffeebreak"的错误呢？请大哥指点。。

[plmxsyuts6]

1.你当时装mysql时端口号是默认的么？默认是3306
另外最好引入驱动
jdbc:mysql://localhost:3306/friend

具体http://blog.csdn.net/plmxsyuts6/archive/2009/03/08/3969347.aspx