数据源连接测试

1.首先需要打开MySQL并创建名为test的数据库，这里为了方便测试直接在命令行里执行：

mysql -hlocalhost -uroot -p

CREATE DATABASE test；

SHOW DATABASE;

 2.需要在配置文件中导入几个坐标

<dependencies>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.28</version>
    </dependency>
    <dependency>
        <groupId>c3p0</groupId>
        <artifactId>c3p0</artifactId>
        <version>0.9.1.2</version>
    </dependency>
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.10</version>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>3.8.2</version>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>org.testng</groupId>
        <artifactId>testng</artifactId>
        <version>RELEASE</version>
        <scope>compile</scope>
    </dependency>
</dependencies>

3.连接测试

@Test
//测试手动创建c3p0数据源
public void test1() throws Exception{
    ComboPooledDataSource dataSource=new ComboPooledDataSource();
    dataSource.setDriverClass("com.mysql.jdbc.Driver");
    dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/test");
    dataSource.setUser("root");
    dataSource.setPassword("1234");
    Connection connection=dataSource.getConnection();
    System.out.println(connection);
    connection.close();

}

@Test
//测试手动创建druid数据源
public void test2() throws Exception {
    DruidDataSource dataSource = new DruidDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/test");
    dataSource.setUsername("root");
    dataSource.setPassword("1234");
    DruidPooledConnection connection=dataSource.getConnection();
    System.out.println(connection);
    connection.close();
}

@Test
//测试手动创建c3p0数据源(加载properties配置文件)
public void test3() throws Exception{
//读取配置文件
    ResourceBundle rb =ResourceBundle.getBundle("jdbc");
    String driver =rb.getString("jdbc.driver");
    String url =rb.getString("jdbc.url");
    String username =rb.getString("jdbc.username");
    String password =rb.getString("jdbc.password");
//创建数据源对象 设置连接参数
    ComboPooledDataSource dataSource=new ComboPooledDataSource();
    dataSource.setDriverClass(driver);
    dataSource.setJdbcUrl(url);
    dataSource.setUser(username);
    dataSource.setPassword(password);
    Connection connection=dataSource.getConnection();
    System.out.println(connection);
    connection.close();

}

库代码：

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=root
jdbc.password=1234