Java教程

spring配置第三方的Bean(数据库连接池)

本文主要是介绍spring配置第三方的Bean(数据库连接池),对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

mysql驱动和druid连接池依赖配置:

 <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.21</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
    </dependencies>

maven会自动导入对应的包:

xml配置Bean:

<bean class="com.alibaba.druid.pool.DruidDataSource" id="dataSource">
        <property name="username" value="root"></property>
        <property name="password" value="123456"></property>
        <property name="url" value="jdbc:mysql://localhost:3306/db1"></property>
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    </bean>

 

 

 测试代码:

    /**
     * 数据库连接池
     */
    @Test
    public void fun7(){
        System.out.println("begin!");
        DruidDataSource dataSource = ioc.getBean("dataSource", DruidDataSource.class);
        System.out.println(dataSource);
    }

运行结果:

begin!
{
	CreateTime:"2022-05-28 19:57:28",
	ActiveCount:0,
	PoolingCount:0,
	CreateCount:0,
	DestroyCount:0,
	CloseCount:0,
	ConnectCount:0,
	Connections:[
	]
}

进程已结束,退出代码为 0

 

 

创建资源文件:

 

 内容:

mysql.username=root
mysql.password=123456
mysql.url=jdbc:mysql://localhost:3306/db1
mysql.driverClassName=com.mysql.jdbc.Driver

xml配置:

<bean class="com.alibaba.druid.pool.DruidDataSource" id="dataSource">
        <property name="username" value="${mysql.username}"></property>
        <property name="password" value="747699"></property>
        <property name="url" value="jdbc:mysql://localhost:3306/db1"></property>
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    </bean>
    <context:property-placeholder location="db.properties"></context:property-placeholder>

再次运行:

begin!
{
    CreateTime:"2022-05-28 20:09:48",
    ActiveCount:0,
    PoolingCount:0,
    CreateCount:0,
    DestroyCount:0,
    CloseCount:0,
    ConnectCount:0,
    Connections:[
    ]
}

进程已结束,退出代码为 0

没有问题! 

 

这篇关于spring配置第三方的Bean(数据库连接池)的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!