常见连接池的基础使用实例（不使用DBUtil）

druid连接池

手动配置的方式

		//手动配置的方式使用的德鲁伊连接池
		DruidDataSource druidDataSource = new DruidDataSource();
		
		druidDataSource.setUrl("jdbc:mysql://localhost:3306/dangdang?useSSL=false&serverTimezone=UTC");
		druidDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
		druidDataSource.setUsername("root");
		druidDataSource.setPassword("root");
		
		DruidPooledConnection connection = druidDataSource.getConnection();
		Statement statement = connection.createStatement();
		ResultSet set = statement.executeQuery("select * from t_user");
		//获取查询的结果
		while (set.next()) {
			Object object = set.getObject("uid");
			System.out.println(object);
		}

加载配置文件的方式

		//加载配置文件的方式
		Properties properties = new Properties();
		properties.load(new FileInputStream("src/druid.properties"));
		
		DataSource DataSource = DruidDataSourceFactory.createDataSource(properties);
		Connection connection = DataSource.getConnection();
		
		Statement Statement = connection.createStatement();
		ResultSet set = Statement.executeQuery("select * from t_user");
		//获取查询的结果
		while (set.next()) {
			Object object = set.getObject("uid");
			System.out.println(object);
		}

c3p0连接池

c3p0连接池会默认加载项目src目录下的配置文件 src/c3p0.properties，若不进行手动set改变配置则会以配置文件为配置

		ComboPooledDataSource pooled = new ComboPooledDataSource();
		
		pooled.setDriverClass("com.mysql.cj.jdbc.Driver");
		pooled.setJdbcUrl("jdbc:mysql://localhost:3306/dangdang?useSSL=false&serverTimezone=UTC");
		pooled.setUser("root");
		pooled.setPassword("root");
		
		Connection connection = pooled.getConnection();
		Statement statement = connection.createStatement();
		ResultSet set = statement.executeQuery("select * from t_user");
		//获取查询的结果
		while(set.next()) {
			String string = set.getString("uname");
			System.out.println(string);
		}

dbcp连接池

dbcp的配置也是两种方式，一种是加载配置文件，下面以给出示例，另一种是手动set配置，参考Druid连接池的方法

		Properties properties = new Properties();
		properties.load(new FileInputStream("src/dbcp.properties"));
		
		DataSource dataSource = BasicDataSourceFactory.createDataSource(properties);
	
		Connection connection = dataSource.getConnection();
		Statement stat = connection.createStatement();
		ResultSet set = stat.executeQuery("select * from t_user");
		
		while(set.next()) {
			String uid = set.getString("uid");
			String uname = set.getString("uname");
			System.out.println(uid+"="+uname);