2018.9.14

• apached的commonds组件：

  commons-dbutils-1.4.jar：封装并简化了JDBC
  commons-dbcp-1.4.jar：apache commons提供的数据连接池组件，命名为DBCP
  commons-pool-1.3.jar：DBCP连接池依赖该jar包

• mysql-connector-java-5.1.28-bin.jar：MySQL的JDBC驱动包，用JDBC连接MySQL数据库必须使用该JAR包。

---

JDBCUtils：用来创建数据库连接池对象

public class JDBCUtils {
    public static final String DRIVER_CLASS_NAME = "com.mysql.jdbc.Driver";
    public static final String URL = "jdbc:mysql://localhost:3306/gip";
    public static final String USERNAME = "root";
    public static final String PASSWORD = "root";

    private static BasicDataSource dataSource = new BasicDataSource();
    static {
        dataSource.setDriverClassName(DRIVER_CLASS_NAME);
        dataSource.setUrl(URL);
        dataSource.setUsername(USERNAME);
        dataSource.setPassword(PASSWORD);
    }

    public static DataSource getDataSource() {
        return dataSource;
    }