数据库的连接池
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