数据库的连接池

mysql读取配置文件，配置文件中设置最大链接数参数maxTotal

src下有文件jdbc.properties：

username=root
password=root
url=jdbc\:mysql\:///mydb
driverClassName=com.mysql.jdbc.Driver
maxTotal=10

其中，将链接数设置为10，在不关闭上次链接时，最多可得到10个数据库的链接
test.java测试如下：

import java.sql.Connection;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbcp2.BasicDataSourceFactory;

public class TestDS {
	public static void main(String[] args) throws Exception {
		Properties props = new Properties();
		props.load(TestDS.class.getResourceAsStream("/jdbc.properties"));
		DataSource ds = BasicDataSourceFactory.createDataSource(props);
		for (int i = 0; i < 100; i++) {
			Connection con = ds.getConnection();
			System.out.println((i+1)+":"+con+" END");
		}
	}
}

得到结果如下：

1#1359044626, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
2#1286084959, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
3#1151020327, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
4#1528637575, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
5#1389647288, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
6#12209492, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
7#1769597131, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
8#1205044462, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
9#947679291, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END
10#1355531311, URL=jdbc:mysql:///mydb, UserName=root@localhost, MySQL Connector Java END