问题描述
本人菜鸟下了个有数据库的项目,用的mysql,我安装了MySQLConnector_J。网上说要个包,我从构建路径那里添加了还是出现这样的错求解答com.mysql.jdbc.CommunicationsException:Communicationslinkfailureduetounderlyingexception:**BEGINNESTEDEXCEPTION**java.net.SocketExceptionMESSAGE:java.net.ConnectException:Connectionrefused:connectSTACKTRACE:java.net.SocketException:java.net.ConnectException:Connectionrefused:connectatcom.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)atcom.mysql.jdbc.Connection.createNewIO(Connection.java:2555)atcom.mysql.jdbc.Connection.<init>(Connection.java:1485)atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)atjava.sql.DriverManager.getConnection(DriverManager.java:664)atjava.sql.DriverManager.getConnection(DriverManager.java:247)atcn.zyq.utils.db_connection.getConnection(db_connection.java:24)atcn.zyq.view.Login.jButton1ActionPerformed(Login.java:218)atcn.zyq.view.Login.access$0(Login.java:203)atcn.zyq.view.Login$1.actionPerformed(Login.java:78)atjavax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)atjavax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)atjavax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)atjavax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)atjava.awt.Component.processMouseEvent(Component.java:6527)atjavax.swing.JComponent.processMouseEvent(JComponent.java:3321)atjava.awt.Component.processEvent(Component.java:6292)atjava.awt.Container.processEvent(Container.java:2234)atjava.awt.Component.dispatchEventImpl(Component.java:4883)atjava.awt.Container.dispatchEventImpl(Container.java:2292)atjava.awt.Component.dispatchEvent(Component.java:4705)atjava.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)atjava.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)atjava.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)atjava.awt.Container.dispatchEventImpl(Container.java:2278)atjava.awt.Window.dispatchEventImpl(Window.java:2739)atjava.awt.Component.dispatchEvent(Component.java:4705)atjava.awt.EventQueue.dispatchEventImpl(EventQueue.java:746)atjava.awt.EventQueue.access$400(EventQueue.java:97)atjava.awt.EventQueue$3.run(EventQueue.java:697)atjava.awt.EventQueue$3.run(EventQueue.java:691)atjava.security.AccessController.doPrivileged(NativeMethod)atjava.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)atjava.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)atjava.awt.EventQueue$4.run(EventQueue.java:719)atjava.awt.EventQueue$4.run(EventQueue.java:717)atjava.security.AccessController.doPrivileged(NativeMethod)atjava.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)atjava.awt.EventQueue.dispatchEvent(EventQueue.java:716)atjava.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)atjava.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)atjava.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)atjava.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)atjava.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)atjava.awt.EventDispatchThread.run(EventDispatchThread.java:82)**ENDNESTEDEXCEPTION**Lastpacketsenttotheserverwas24msago.atcom.mysql.jdbc.Connection.createNewIO(Connection.java:2621)atcom.mysql.jdbc.Connection.<init>(Connection.java:1485)atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)atjava.sql.DriverManager.getConnection(DriverManager.java:664)atjava.sql.DriverManager.getConnection(DriverManager.java:247)atcn.zyq.utils.db_connection.getConnection(db_connection.java:24)atcn.zyq.view.Login.jButton1ActionPerformed(Login.java:218)atcn.zyq.view.Login.access$0(Login.java:203)atcn.zyq.view.Login$1.actionPerformed(Login.java:78)atjavax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)atjavax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)atjavax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)atjavax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)atjavax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)atjava.awt.Component.processMouseEvent(Component.java:6527)atjavax.swing.JComponent.processMouseEvent(JComponent.java:3321)atjava.awt.Component.processEvent(Component.java:6292)atjava.awt.Container.processEvent(Container.java:2234)atjava.awt.Component.dispatchEventImpl(Component.java:4883)atjava.awt.Container.dispatchEventImpl(Container.java:2292)atjava.awt.Component.dispatchEvent(Component.java:4705)atjava.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)atjava.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)atjava.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)atjava.awt.Container.dispatchEventImpl(Container.java:2278)atjava.awt.Window.dispatchEventImpl(Window.java:2739)atjava.awt.Component.dispatchEvent(Component.java:4705)atjava.awt.EventQueue.dispatchEventImpl(EventQueue.java:746)atjava.awt.EventQueue.access$400(EventQueue.java:97)atjava.awt.EventQueue$3.run(EventQueue.java:697)atjava.awt.EventQueue$3.run(EventQueue.java:691)atjava.security.AccessController.doPrivileged(NativeMethod)atjava.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)atjava.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)atjava.awt.EventQueue$4.run(EventQueue.java:719)atjava.awt.EventQueue$4.run(EventQueue.java:717)atjava.security.AccessController.doPrivileged(NativeMethod)atjava.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)atjava.awt.EventQueue.dispatchEvent(EventQueue.java:716)atjava.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)atjava.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)atjava.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)atjava.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)atjava.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)atjava.awt.EventDispatchThread.run(EventDispatchThread.java:82)
解决方案
解决方案二:
检查你的MySQL驱动包和连接的MySQL数据库版本是否一致.看这个情况能够连接,但是连接后发生错误.错误应该是由驱动包不匹配造成的.