测试手动创建数据源

1、导入数据源的坐标

  <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</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>4.11</version>
        </dependency>
    </dependencies>

2、创建c3p0数据源

    @Test
    //测试手动创建c3p0数据源
    public void test1() throws Exception {
        //创建数据源
        ComboPooledDataSource comboPooledDataSource = new ComboPooledDataSource();
        //设置数据库连接参数
        comboPooledDataSource.setDriverClass("com.mysql.jdbc.Driver");
        comboPooledDataSource.setJdbcUrl("jdbc:mysql://localhost:3306/db1");
        comboPooledDataSource.setUser("root");
        comboPooledDataSource.setPassword("123456");
        //获取数据源的资源
        Connection connection = comboPooledDataSource.getConnection();
        System.out.println(connection);
        //关闭connection
        connection.close();
    }

3、 创建druid数据源

   @Test
    //测试手动创建druid数据源
    public void test2() throws Exception {
        //创建数据源
        DruidDataSource druidDataSource = new DruidDataSource();
        //设置数据源参数
        druidDataSource.setDriverClassName("com.mysql.jdbc.Driver");
        druidDataSource.setUrl("jdbc:mysql://localhost:3306/db1");
        druidDataSource.setUsername("root");
        druidDataSource.setPassword("123456");
        //获取数据源资源
        DruidPooledConnection connection = druidDataSource.getConnection();
        System.out.println(connection);
        connection.close();
    }

4、导入配置文件形式

        //读取配置文件
        ResourceBundle resourceBundle = ResourceBundle.getBundle("jdbc");
        String driver = resourceBundle.getString("jdbc.driver");
        String url = resourceBundle.getString("jdbc.url");
        String username = resourceBundle.getString("jdbc.username");
        String password = resourceBundle.getString("jdbc.password");