jsp连接mysql的错误.端口号的问题

    技术2022-05-20  36

    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);

    运行成功了。


    最新回复(0)