请教各位一个关于数据库的问题。
大家好,我在java中连接mysql数据库,可是有错误,特来请教
代码:
import java.sql.*;
public class MySql
{
public static void main(String[] args)
{
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url = "jdbc:mysql://localhost/jdon:3306?user=root&password=sun";
Connection conn = DriverManager.getConnection(url);
Statement state = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from jivewatch";
ResultSet rs = state.executeQuery(sql);
while(rs.next())
{
System.out.println("1:"+rs.getString(1));
System.out.println("2:"+rs.getString(2));
}
state.close();
}
catch(Exception e)
{
System.out.println(""+e);
e.printStackTrace();
}
}
};
错误提示:
java.sql.SQLException: Communication failure during handshake. Is there a server
running on localhost:3306?
java.sql.SQLException: Communication failure during handshake. Is there a server
running on localhost:3306?
at org.gjt.mm.mysql.MysqlIO.init(Unknown Source)
at org.gjt.mm.mysql.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Unknown Source)
at org.gjt.mm.mysql.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at MySql.main(MySql.java:11)
请按任意键继续 . . .
说明:
我在dos模式下用该用户名和密码已经登陆我要连接的数据库了,可在程序中就不行。急切等待。。。。