package?util;
import?java.sql.Connection;
import?java.sql.DriverManager;
public?class?DBHelper?{
private?static?final?String?driver="com.mysql.jdbc.Driver";
private?static?final?String?url="jdbc:mysql://localhost:3006/imooc";
private?static?final?String?username="root";
private?static?final?String?password="123456";
private?static?Connection?conn=null;
//靜態(tài)代碼塊負(fù)責(zé)加載驅(qū)動(dòng)
static{
try{
Class.forName(driver);
}catch(Exception?ex){
ex.printStackTrace();
}
}
//單例模式返回?cái)?shù)據(jù)庫(kù)連接對(duì)象
public?static?Connection?getConnection()?throws?Exception{
if(conn==null){
conn=DriverManager.getConnection(url,?username,?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)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
}代碼如上?請(qǐng)問(wèn)要怎么處理?
1 回答
已采納

夢(mèng)影劍魂
TA貢獻(xiàn)66條經(jīng)驗(yàn) 獲得超21個(gè)贊
?private?static?final?String?url="jdbc:mysql://localhost:3006/imooc";你把端口號(hào)改成3006了??如果沒(méi)有,默認(rèn)的應(yīng)該是3306
添加回答
舉報(bào)
0/150
提交
取消