資料庫連接配接出現Communications link failure

在進行簡單的資料庫操作時出現以下錯誤：

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 31,008 milliseconds ago.  The last packet sent successfully to the server was 30,981 milliseconds ago.

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

    at java.lang.reflect.Constructor.newInstance(Unknown Source)

    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)

    at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)

    at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4912)

    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1663)

    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)

    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2190)

    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2221)

    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2016)

    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)

    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

    at java.lang.reflect.Constructor.newInstance(Unknown Source)

    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)

    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)

    at java.sql.DriverManager.getConnection(Unknown Source)

    at java.sql.DriverManager.getConnection(Unknown Source)

    at cn.itcast.mybatis.jdbc.JdbcTest.main(JdbcTest.java:30)

Caused by: java.net.SocketException: Software caused connection abort: recv failed

    at java.net.SocketInputStream.socketRead0(Native Method)

    at java.net.SocketInputStream.socketRead(Unknown Source)

    at java.net.SocketInputStream.read(Unknown Source)

    at java.net.SocketInputStream.read(Unknown Source)

    at sun.security.ssl.InputRecord.readFully(Unknown Source)

    at sun.security.ssl.InputRecord.read(Unknown Source)

    at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)

    at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)

    at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)

    at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)

    at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186)

    ... 18 more

上面紅色的字就是出錯的地方，對應我這個位置

上面的密碼被我模糊化了，你們就填你們對應的資料密碼就ok了。

修改資料庫的連接配接，就可以解決問題了

資料庫連接配接寫成下面這樣就可以了

// 加載資料庫驅動

Class.forName("com.mysql.jdbc.Driver");

// 通過驅動管理類擷取資料庫連接配接

connection = (Connection) DriverManager

                    .getConnection(

                            "jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&useSSL=false",

                            "root", "*********");

"*********"：寫成你們的資料庫連接配接密碼

這樣我的問題就解決了。