JDBC数据库连接的创建

//利用配置文件来连接数据库

package com.amake.util;

import java.io.IOException;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;


import com.mysql.jdbc.Connection;

public class DBUtil {

//在main方法中验证是否连接成功。

public static void main(String[] args){
DBUtil util=new DBUtil();//实例化一个对象
try {
Connection conn=util.getconnection();//调用getconnection这个方法来验证数据库是否连接成功
System.out.println(conn);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

public Connection getconnection() throws IOException{
Properties pop=new Properties();
String driver=null;
String url=null;
String username=null;
String password=null;
pop.load(this.getClass().getClassLoader().getResourceAsStream("DBConfig.properties"));
driver=pop.getProperty("driver");
url=pop.getProperty("url");
username=pop.getProperty("username");
password=pop.getProperty("password");
/*System.out.println(driver);
System.out.println(url);
System.out.println(username);*/
try {
Class.forName(driver);    //加载数据库驱动
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
//数据库连接
return (Connection) DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;

}

}

//配置文件properties如下，注意配置文件要建在src目录下

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/jdbc_db
username=root

password=root