JDBC資料庫連接配接管理類

package org.zhanghua.jspservlet.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.util.Properties;

import javax.sql.DataSource;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

public class DBConnection {

public static final String FILENAME = "/sql.properties";

private String driver;

private String url;

private String username;

private String password;

public DBConnection() throws Exception {

// 讀取sql.properties屬性檔案

Properties properties = new Properties();

properties.load(getClass().getResourceAsStream(FILENAME));

driver = properties.getProperty("driver");

url = properties.getProperty("url");

username = properties.getProperty("username");

password = properties.getProperty("password");

Class.forName(driver);

}

public Connection getConnection() throws Exception {

Connection connection = null;

connection = DriverManager.getConnection(url, username, password);

return connection;

}

public DataSource getDataSource() {

BasicDataSource dataSource = new BasicDataSource();

dataSource.setDriverClassName(driver);

dataSource.setUrl(url);

dataSource.setUsername(username);

dataSource.setPassword(password);

return dataSource;

}

public String getDriver() {

return driver;

}

public void setDriver(String driver) {

this.driver = driver;

}

public String getUrl() {

return url;

}

public void setUrl(String url) {

this.url = url;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public static void main(String[] args) throws Exception {

Connection connection = new DBConnection().getConnection();

System.out.println("連接配接的資料庫：" + connection.getCatalog());

}

}