課程
/后端開(kāi)發(fā)
/Java
/JAVA遇見(jiàn)HTML——JSP篇
為什么我的結(jié)果一直是數(shù)據(jù)庫(kù)連接異常
2015-04-19
源自:JAVA遇見(jiàn)HTML——JSP篇 8-3
正在回答
?DriverManager.getConnection(url,?uesrname,?password);
改成:conn=DriverManager.getConnection(url,?uesrname,?password);
你這里沒(méi)賦值,conn是null,所以會(huì)輸出數(shù)據(jù)庫(kù)連接異常
奮斗的小牧童 提問(wèn)者
Bill_2
數(shù)據(jù)庫(kù)是MySQL,控制臺(tái)沒(méi)報(bào)錯(cuò),輸出結(jié)果“數(shù)據(jù)庫(kù)連接異常!”
package?util; import?java.sql.Connection; import?java.sql.DriverManager; import?java.sql.SQLException; public?class?DBHelper?{ ???? ????private?static?final?String?driver?=?"com.mysql.jdbc.Driver";//數(shù)據(jù)庫(kù)驅(qū)動(dòng) ????//連接數(shù)據(jù)庫(kù)的URL地址 ????private?static?final?String?url?=?"jdbc:mysql://localhost:3306/test"?; ????private?static?final?String?uesrname?=?"root"; ????private?static?final?String?password?="root"; ????//靜態(tài)代碼塊負(fù)責(zé)加載驅(qū)動(dòng) ????private?static?Connection?conn?=?null; ????static ????{ ????????try?{ ????????????Class.forName(driver); ???????????? ????????}?catch?(Exception?e)?{ ????????????System.out.println("找不到驅(qū)動(dòng)程序類?,加載驅(qū)動(dòng)失?。?); ????????????e.printStackTrace(); ????????} ????} ???? ????//單例模式返回?cái)?shù)據(jù)庫(kù)連接對(duì)象 ????public?static?Connection?getConnection()?throws?Exception{ ????????if(conn?==?null){ ????????????DriverManager.getConnection(url,?uesrname,?password); ????????????return?conn; ????????} ????????return?conn; ????} ???? ????public?static?void?main(String[]?args)?{ ????????try?{ ????????????Connection?conn?=?DBHelper.getConnection(); ????????????if(conn?!=null){ ????????????????System.out.println("數(shù)據(jù)庫(kù)連接正常"); ????????????}else{ ????????????????System.out.println("數(shù)據(jù)庫(kù)連接異常!"); ????????????} ????????}?catch?(Exception?e)?{ ????????????e.printStackTrace(); ????????} ???????? ????} }
請(qǐng)把錯(cuò)誤信息貼出來(lái),還有你使用的數(shù)據(jù)庫(kù)是什么。這樣有助于我們解答問(wèn)題。
舉報(bào)
Java Web入門(mén)級(jí)教程JSP,帶你輕松的學(xué)習(xí)JSP基礎(chǔ)知識(shí)
1 回答數(shù)據(jù)庫(kù)連接異常
1 回答連接數(shù)據(jù)庫(kù)
3 回答連接數(shù)據(jù)庫(kù)
3 回答和數(shù)據(jù)庫(kù)連接
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號(hào)-11 京公網(wǎng)安備11010802030151號(hào)
購(gòu)課補(bǔ)貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動(dòng)學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號(hào)
2015-04-20
?DriverManager.getConnection(url,?uesrname,?password);
改成:conn=DriverManager.getConnection(url,?uesrname,?password);
你這里沒(méi)賦值,conn是null,所以會(huì)輸出數(shù)據(jù)庫(kù)連接異常
2015-04-19
數(shù)據(jù)庫(kù)是MySQL,控制臺(tái)沒(méi)報(bào)錯(cuò),輸出結(jié)果“數(shù)據(jù)庫(kù)連接異常!”
2015-04-19
請(qǐng)把錯(cuò)誤信息貼出來(lái),還有你使用的數(shù)據(jù)庫(kù)是什么。這樣有助于我們解答問(wèn)題。