package?util;
import?java.sql.Connection;
import?java.sql.DriverManager;
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://dl；3306/shopping?useUnicode=true&characterEncoding=UTF";
private?static?final?String?username?=?"root";//數(shù)據(jù)庫(kù)的用戶名
private?static?final?String?password?=?"localhost";//數(shù)據(jù)庫(kù)的密碼
private?static?Connection?conn?=?null;
//靜態(tài)代碼塊負(fù)責(zé)加載驅(qū)動(dòng)
static{
try{
Class.forName(driver);//利用反射加載驅(qū)動(dòng)
}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ù)連接正常！");
}
}?catch?(Exception?e)?{
System.out.println("數(shù)據(jù)庫(kù)連接異常?。?);
}
}
}