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