各种连接池和DriverManager连接mysql数据库

• 测试各种连接池和DriverManager连接mysql数据库
• mysql version : 8.0

package mysql;

import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.commons.dbcp.BasicDataSource;

import com.alibaba.druid.pool.DruidDataSource;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;

/**
 *测试各种连接池连接mysql数据库
 */
public class ConnectionTest {
	private static final String DRIVER = "com.mysql.cj.jdbc.Driver";
	private static final String USER = "root";
	private static final String PASSWORD = "123456";
	private static final String DB_URL = "jdbc:mysql://localhost:3306/ljb_database?useSSL=false&serverTimezone=UTC";

	public static void main(String[] args) throws Exception {
		Connection conn = useDbcpConnection();
		executeQuery(conn);
		conn = useDriverConnection();
		executeQuery(conn);
		conn = useC3P0Connection();
		executeQuery(conn);
		conn = useHikariConnnection();
		executeQuery(conn);
		conn = useDruidConnection();
        executeQuery(conn);
	}

	private static Connection useDruidConnection() throws SQLException {
		Conne