首頁猿問我的數(shù)據(jù)庫連接不了，報(bào)錯(cuò)如下。

我的數(shù)據(jù)庫連接不了，報(bào)錯(cuò)如下。

Java MySQL

終有弱水替滄海4032800 2016-11-08 19:27:59

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:?** BEGIN NESTED EXCEPTION **?com.mysql.jdbc.CommunicationsExceptionMESSAGE: Communications link failure due to underlying exception:?** BEGIN NESTED EXCEPTION **?java.io.EOFExceptionSTACKTRACE:java.io.EOFException at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1963) at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:557) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1027) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2743) at com.mysql.jdbc.Connection.<init>(Connection.java:1553) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at util.DBHelp.getConnection(DBHelp.java:25) at util.DBHelp.main(DBHelp.java:32)** END NESTED EXCEPTION **

查看完整描述

1 回答

忘性最大的人

TA貢獻(xiàn)118條經(jīng)驗(yàn) 獲得超37個(gè)贊

瞧瞧代碼可以不

反對(duì) 回復(fù) 2016-11-08

終有弱水替滄海4032800
package util; import java.sql.Connection; import java.sql.DriverManager; public class DBHelp { private static final String driver="com.mysql.jdbc.Driver"; private static final String url="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8"; private static final String username="root"; private static final String password="0419"; private static Connection conn=null; static{ try { Class.forName(driver); } catch (ClassNotFoundException e) { e.printStackTrace(); } } //單例模式返回?cái)?shù)據(jù)庫連接對(duì)象 public static Connection getConnection() throws Exception{ if(conn==null){ conn = DriverManager.getConnection(url, username, password); } return conn; } public static void main(String[] args){ try { Connection conn = DBHelp.getConnection(); if(conn!=null){ System.out.println("數(shù)據(jù)庫連接成功"); } System.out.println("數(shù)據(jù)庫連接失敗"); } catch (Exception e) { e.printStackTrace(); } } } 可以得這是我的DBHelp類

回復(fù) 2016-11-09
忘性最大的人
額（︶︿︶）。。。。。強(qiáng)迫癥犯了。。。

回復(fù) 2016-11-09
終有弱水替滄海4032800
復(fù)制時(shí)格式對(duì)的，一黏貼就每格式了，不好意思哈

回復(fù) 2016-11-09