jsp连接mysql的错误:
Servlet.service() for servlet jsp threw exceptionjava.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:519) at java.net.Socket.connect(Socket.java:469) at java.net.Socket.<init>(Socket.java:366) at java.net.Socket.<init>(Socket.java:209) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:293)
源码:
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); String url="jdbc:mysql://localhost/test1?user=root&password=123&useUnicode=true&characterEncoding=8859_1"; Connection conn=DriverManager.getConnection(url);
端口号不是默认的:所以出错了。改后:
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); String url="jdbc:mysql://localhost:3307/test1?user=root&password=123&useUnicode=true&characterEncoding=8859_1"; Connection conn=DriverManager.getConnection(url);
运行成功了。