JDBC問題
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://localhost:3306/shopping?useUnicode=true&characterEncoding=UTF-8";?
private static final String username="root";//數(shù)據(jù)庫的用戶名
private static final String password="Aa123456";//數(shù)據(jù)庫的密碼
? ??
private static Connection conn=null;
//靜態(tài)代碼塊負責加載驅(qū)動
static?
{
try
{
Class.forName(driver);
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
//單例模式返回數(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 ex)
{
ex.printStackTrace();
}
}
}
為什么我沒寫密碼就報錯,視頻中都沒寫密碼
2016-07-12
你設(shè)置的MySQL的密碼?
2016-01-04
設(shè)置了密碼的話就得加上密碼吧!