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;
//靜態代碼塊負責加載驅動
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("數據庫連接正常");
}else{
System.out.println("數據庫連接異常");
}
}?catch?(Exception?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
}代碼如上？請問要怎么處理？
添加回答
舉報
0/150
提交
取消