java.net.ConnectException: Connection refused: connect 雷人解决方法,希望高手解释原因
源代码如下,
<%@ page import ="java.io.*"%>
<%@ page import ="java.util.*"%>
<%@ page import ="java.sql.*"%>
<%
String dbUrl="jdbc:mysql://localhost:3306/bookstore?useUnicode=true&characterEncoding=GB2312";
String dbUser="root";
String dbPwd="6965050";
String driverName="com.mysql.jdbc.Driver";
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
Class.forName(driverName);
con = java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
if(con!=null)
System.out.println("connect successfully!");
%>
错误页面
root cause
javax.servlet.ServletException: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused: connect
STACKTRACE:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:518)
at java.net.Socket.connect(Socket.java:468)
at java.net.Socket. <init>(Socket.java:365)
at java.net.Socket. <init>(Socket.java:208) 后面还有一大堆错误
我的环境变量什么都没有设置错误,具体我的错误和我的软件版本和环境变量可以看这个贴http://topic.csdn.net/u/20090413/18/a50872d9-7ab7-4dd0-b547-a1eb83deaaab.html
我的操作系统是!!!!!VISTA!!!!!!! 一直出现Connection refused: connect 错误,,,,,
当我把原代码中 localhost换成127.0.0.1,,,,,,奇迹出现了,竟然能访问数据库了,,,,,,,
希望高手说明这时啥原因,,,这也太雷人了吧,,,不这样试下,岂不是要冤死。。。。。。。。。。。。。是VISTA的原因???
希望有高手能发个新帖把原因什么解释下,免得再有像我这样的倒霉小白走这样的弯路。。。