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