JAVA数据源开发到spring配置

这边是学习JAVA的一些学习笔记。勿喷！！！

1.创建一个测试类  DataSourceTest.java   

package com.itheima.test.dao;

2.pom.xml加入依赖

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.22</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.0.9.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.9</version>
        </dependency>
        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.2</version>
        </dependency>

    </dependencies>

3. 先测试c3p0的连接

    /*
    c3p0 直接读取数据库
     */
    @Test
    public void test_c3p0() throws PropertyVetoException, SQLException {
        ComboPooledDataSource dataSources = new ComboPooledDataSource();
        dataSources.setDriverClass("com.mysql.cj.jdbc.Driver");
        nect=true&characterEncoding=utf-8
        dataSources.setJdbcUrl("jdbc:mysql://localhost:3306/mysql?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull&autoReconnect=true");
        dataSources.setUser("root");
        dataSources.setPassword("123456");
        Connection connection = dataSources.getConnection();
        System.out.println(connection + "-=======--11111");
        connection.close();
    }

这里要注意  serverTimezone=Asia/Shanghai  这个一定要写，不然得报错

打印结果  com.mchange.v2.c3p0.impl.NewProxyConnection@4909b8da-=======--11111  表示成功

4. 测试一下druid的连接

    /*
    druid 直接连接数据库
     */
    @Test
    public void test_druid() throws SQLException {
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/mysql?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull&autoReconnect=true");
        dataSource.setUsername("root");
        dataSource.setPassword("123456");
        DruidPooledConnection connection = dataSource.getConnection();
        System.out.println(connection + "22222");
        connection.close();
    }

5. 读取配置文件中的属性来配置

    5.1 先在test目录下创建 resources目录，并右键 标记目录为  测试资源根

    5.2  在资源目录下创建 jdbc.properties 这个可以自定义名字

    5.3  里面配置一下名称    

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mysql?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull&autoReconnect=true
jdbc.username=root
jdbc.password=123456

    5.4 编写代码，这边读取配置文件有两种方式。 ResourceBundle 比较简单

/*
    读取配置文件 创建连接
     */
    @Test
    public void test_c3p0_prop() throws IOException, PropertyVetoException, SQLException {
        //读取配置文件方式一
//        Properties prop = new Properties();
//        InputStream resource = ClassLoader.getSystemResourceAsStream("jdbc.properties");
//        prop.load(resource);
//        String driver = prop.getProperty("jdbc.driver");

        ResourceBundle rb = ResourceBundle.getBundle("jdbc");
        String driver = rb.getString("jdbc.driver");
        String url = rb.getString("jdbc.url");
        String username = rb.getString("jdbc.username");
        String pwd = rb.getString("jdbc.password");
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        dataSource.setDriverClass(driver);
        dataSource.setJdbcUrl(url);
        dataSource.setUser(username);
        dataSource.setPassword(pwd);
        Connection connection = dataSource.getConnection();

        System.out.println(connection);
        //resource.close();
    }

6. 利用spring注入来实现

    6.1 在test的resources下创建spring配置 applicationContext.xml

          

    <bean id="jdbc_c3p0" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.cj.jdbc.Driver"></property>
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/mysql?useSSL=false&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=Asia/Shanghai&amp;zeroDateTimeBehavior=convertToNull&amp;autoReconnect=true"></property>
        <property name="user" value="root"></property>
        <property name="password" value="123456"></property>
    </bean>

   6.2 代码调用

       这边注释的也是可以用。DataSource dataSource = context.getBean(DataSource.class);   这个和 ComboPooledDataSource bean = context.getBean(ComboPooledDataSource.class); 在 配置文件中如果有两个，就会报错，保险起见，指定名称 jdbc_c3p0

    @Test
    public void testc3p0_ioc() throws SQLException {
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        //ComboPooledDataSource bean = context.getBean(ComboPooledDataSource.class);
        //DataSource dataSource = context.getBean(DataSource.class);
        DataSource dataSource = context.getBean("jdbc_c3p0", DataSource.class);
        Connection connection = dataSource.getConnection();
        System.out.println(connection+"9999");
        connection.close();
    }

7. 可以将数据库连接的信息，统一放到对应的配置文件去，例如 c3p0.properties, drid.properties? 然后注入配置取这里的值。

    在 applicationContext.xml 里配置如下：

    <context:property-placeholder location="jdbc.properties"></context:property-placeholder>
    <bean id="jdbc_c3p0_02" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

这边 context需要头部指定一下

xmlns:context="http://www.springframework.org/schema/context"

在 xsi:schemaLocation中加入以下这个，以空格分隔。 

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd

同样程序不变

    @Test
    public void testc3p0_ioc02() throws SQLException {
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        DataSource dataSource = context.getBean("jdbc_c3p0_02", DataSource.class);
        Connection connection = dataSource.getConnection();
        System.out.println(connection+"8888");
        connection.close();
    }