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ū)動
static{
try{
Class.forName(driver);
}catch(Exception?ex){
ex.printStackTrace();
}
}
//單例模式返回?cái)?shù)據(jù)庫連接對象
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ù)庫連接正常");
}else{
System.out.println("數(shù)據(jù)庫連接異常");
}
}?catch?(Exception?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
}代碼如上？請問要怎么處理？
添加回答
舉報(bào)
0/150
提交
取消