mysql问题，在已经问过的问题里找到的都不好使

[paulhybryant]

import java.sql.*;
import java.io.*;
import java.util.*;
//import org.gjt.mm.mysql.Driver;

public class TestDB {

public static void main(String[] args) {
try
{
Connection conn=getConnection();
Statement stat=conn.createStatement();

stat.execute("CREATE TABLE Greetings (Name CHAR(20))");
stat.execute("INSERT INTO Greetings VALUES('Hello,World!')");

ResultSet result=stat.executeQuery("SELECT * FROM Greetings");
result.next();
System.out.println(result.getString(1));
result.close();

stat.execute("DROP TABLE Greetings");

stat.close();
conn.close();
}
catch(SQLException ex)
{
while(ex!=null)
{
ex.printStackTrace();
ex=ex.getNextException();
}
}
catch(IOException ex)
{
ex.printStackTrace();
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(InstantiationException e)
{
e.printStackTrace();
}
catch(IllegalAccessException e)
{
e.printStackTrace();
}
}

public static Connection getConnection() throws SQLException,IOException,ClassNotFoundException,InstantiationException,IllegalAccessException
{
String driver="org.gjt.mm.mysql.Driver";
Class.forName(driver).newInstance();
String url="jdbc:mysql:test";
String username="root";
String password="840104";

return DriverManager.getConnection(url,username,password);
}
}

classpath也设置了，在.java目录下也放了解压后的org.*的东西，
但是运行的时候总是报告
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at TestDB.getConnection(TestDB.java:78)
at TestDB.main(TestDB.java:17)
请问为什么？

[zrtl]

DriverManager.getConnection(url,username,password);
你的URL字段串里写法不对呀，应该是这样的格式
jdbc:mysql://hostname:3306/database

[paulhybryant]

那样写也不行

[paulhybryant]

好了，谢谢

[zrtl]

org.gjt.mm.mysql.Driver这个驱动路径你认定正确的吗，不如换一个
http://finalz.3322.org/tools/mysql-connector-java-3.1.1-alpha-bin.jar
驱动这样写
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
conn=DriverManager.getConnection("jdbc:mysql://hostname:3306/database", "root", "840104");