DataSource Java 官方 DBCP

DBCP使用的比较少, 大多用 c3p0

c3p0与dbcp区别

dbcp没有自动回收空闲连接的功能

c3p0有自动回收空闲连接功能

基础使用, DBCP是用连接池实现的

		BasicDataSource basicDataSource = new BasicDataSource();

		basicDataSource.setDriverClassName("com.mysql.jdbc.Driver");

		basicDataSource.setUrl("jdbc:mysql://127.0.0.1/mydb");
		basicDataSource.setUsername("root");
		basicDataSource.setPassword("root");

		basicDataSource.setMaxActive(3);

		try {
			Connection connection1 = basicDataSource.getConnection();
			Connection connection2 = basicDataSource.getConnection();
			Connection connection3 = basicDataSource.getConnection();

			System.out.println(connection1.hashCode());
			System.out.println(connection2.hashCode());
			System.out.println(connection3.hashCode());

			connection3.close();

			Connection connection4 = basicDataSource.getConnection();

			System.out.println(connection4.hashCode()); // 输出同3

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

可以使用属性文件创建datasource

	public void testProperties() {

		Properties properties = new Properties();

		try {
			properties.load(DBCPTest.class
					.getResourceAsStream("jdbc.properties"));
		} catch (IOException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}

		try {
			BasicDataSource basicDataSource = (BasicDataSource) BasicDataSourceFactory
					.createDataSource(properties);

			System.out.println(basicDataSource.getConnection());
			//输出 : jdbc:mysql://127.0.0.1:3306/mysql, UserName=root@localhost, MySQL-AB JDBC Driver

		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

属性对应设置方法, 源代码中对应

    private final static String PROP_DEFAULTAUTOCOMMIT = "defaultAutoCommit";
    private final static String PROP_DEFAULTREADONLY = "defaultReadOnly";
    private final static String PROP_DEFAULTTRANSACTIONISOLATION = "defaultTransactionIsolation";
    private final static String PROP_DEFAULTCATALOG = "defaultCatalog";
    private final static String PROP_DRIVERCLASSNAME = "driverClassName";
    private final static String PROP_MAXACTIVE = "maxActive";
    private final static String PROP_MAXIDLE = "maxIdle";
    private final static String PROP_MINIDLE = "minIdle";
    private final static String PROP_INITIALSIZE = "initialSize";
    private final static String PROP_MAXWAIT = "maxWait";
    private final static String PROP_TESTONBORROW = "testOnBorrow";
    private final static String PROP_TESTONRETURN = "testOnReturn";
    private final static String PROP_TIMEBETWEENEVICTIONRUNSMILLIS = "timeBetweenEvictionRunsMillis";
    private final static String PROP_NUMTESTSPEREVICTIONRUN = "numTestsPerEvictionRun";
    private final static String PROP_MINEVICTABLEIDLETIMEMILLIS = "minEvictableIdleTimeMillis";
    private final static String PROP_TESTWHILEIDLE = "testWhileIdle";
    private final static String PROP_PASSWORD = "password";
    private final static String PROP_URL = "url";
    private final static String PROP_USERNAME = "username";
    private final static String PROP_VALIDATIONQUERY = "validationQuery";
    private final static String PROP_VALIDATIONQUERY_TIMEOUT = "validationQueryTimeout";