import java.sql.*;public class TestJdbc
{
public Connection con;public TestJdbc()
{}public Connection connect()
{
String url ="jdbc:mysql://localhost/sql_test";
String user="root";
String password="123456";try
{
Class.forName("com.mysql.jdbc.Driver");}
catch(Exception ex)
{
System.out.println(ex.getMessage());
}try
{
con=DriverManager.getConnection(url,user,password);}
catch(Exception ex)
{
System.out.println(ex.getMessage());
}
return con;
}
public static void main(String args[]){
TestJdbc tm=new TestJdbc();
Connection m=tm.connect();
if(m!=null){
System.out.println("成功!");
}
}
}
出现了如下的异常:
MESSAGE: java.net.ConnectionException: Connection refused: connect
STACKTRACE:
java.net.SocketException:java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MyselIO.<init><MysqlIO.java:284>
.......
请问这是怎么回事,怎么解决呢,请帮帮我啊,小弟跪求了!!!
{
public Connection con;public TestJdbc()
{}public Connection connect()
{
String url ="jdbc:mysql://localhost/sql_test";
String user="root";
String password="123456";try
{
Class.forName("com.mysql.jdbc.Driver");}
catch(Exception ex)
{
System.out.println(ex.getMessage());
}try
{
con=DriverManager.getConnection(url,user,password);}
catch(Exception ex)
{
System.out.println(ex.getMessage());
}
return con;
}
public static void main(String args[]){
TestJdbc tm=new TestJdbc();
Connection m=tm.connect();
if(m!=null){
System.out.println("成功!");
}
}
}
出现了如下的异常:
MESSAGE: java.net.ConnectionException: Connection refused: connect
STACKTRACE:
java.net.SocketException:java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MyselIO.<init><MysqlIO.java:284>
.......
请问这是怎么回事,怎么解决呢,请帮帮我啊,小弟跪求了!!!
你没有加端口号
String url ="jdbc:mysql://localhost:3306/sql_test";
1.the server is running
2.you're connecting to the correct port
>mysql
如果出现欢迎字样说明mysql已经启动了
否则,进mysql的bin目录,有个启动的可执行文件,点他就OK了。-------------------------------------------------
MySQL中文参考手册:
http://www.linuxforum.net/books/mysqlmanual/manual_Tutorial.html
报的异常里说连接被拒绝,你看下MYSQL是否打开了哦
这个地方绝对不能用user password在url里都包括了这些信息;我最近也有遇到过,直接DriverManager.getConnection(url);后才ok
---------------------------------------------------------
如果没有修改mysql端口号的话,不加端口号是可以连接成功的楼主的问题应该是mysql进程没有开启
楼主这样写可能会出毛病
DriverManager.getConnection(url,user,password);
一般这么写肯定没什么问题了
DriverManager.getConnection("jdbc:mysql://localhost/DataBaseName?user=UserName&password=Password&useUnicode=ture;characterEncoding=GBK");