vista 操作系统上使用JDBC连接mysql5.0

Question

我在mysql中建了数据库，也建了张表。可是在用myeclipse6.5 写程序测试：
package test;import java.sql.*;public class ConnTo { public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("success loading mysql Driver");
} catch (Exception ex) {
ex.printStackTrace();
}

try{
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
System.out.println("success connection to the db");
}catch(Exception ex){
ex.printStackTrace();
}
}
}报如下的错误：success loading mysql Driver
com.mysql.jdbc.CommunicationsException: Communications link failureLast packet sent to the server was 0 ms ago.
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.ConnTo.main(ConnTo.java:16)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
... 6 more

Answer 1

ct=DriverManager.getConnection("jdbc:mysql://localhost/mydata?user=root&password=root");

Answer 2

java.net.ConnectException: Connection refused: connect 
  String url = "jdbc:mysql://localhost/数据库名?user=root&password=root&useUnicode=true&characterEncoding=gb2312";
            Connection conn = DriverManager.getConnection(url);
            Statement stmt = conn.createStatement();试试

Answer 3

Caused by: java.net.ConnectException: Connection refused: connect 说明端口号不正确，或者服务器没起来。