使用spring配置dbcp2和pool2

最新推荐文章于 2024-07-05 08:30:00 发布

werder

最新推荐文章于 2024-07-05 08:30:00 发布

阅读量5.7k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Java心水文章标签： spring mybatis

本文链接：https://blog.youkuaiyun.com/werder/article/details/54562868

Java心水专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了如何在Spring框架中集成DBCP2连接池和Pool2，为Mybatis提供高效的数据源管理。通过配置Spring，实现数据库连接的优化，提升应用程序的性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用mybatis,做个记录

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context"
    xmlns:task="http://www.springframework.org/schema/task"
    xsi:schemaLocation="
          http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
           http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
           http://www.springframework.org/schema/tx
           http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-4.0.xsd 
           http://www.springframework.org/schema/task  
          http://www.springframework.org/schema/task/spring-task-4.0.xsd
        ">

    <bean id="propertyConfigurer"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:jdbc.properties" />
    </bean>

    <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource"
        destroy-method="close">
        <property name="driverClassName" value="${db.driverClassName}" />
        <property name="url" value="${db.url}" />
        <property name="username" value="root" />
        <property name="password" value="password" />
        <property name="initialSize" value="10" />
        <property name="maxTotal" value="100" />
        <property name="maxIdle" value="100" />
        <property name="maxWaitMillis" value="-1" />
    </bean>

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--dataSource属性指定要用到的连接池 -->
        <property name="dataSource" ref="dataSource" />
        <!--configLocation属性指定mybatis的核心配置文件 -->
        <!-- <property name="mapperLocations" value="classpath:StockMapper/*.xml"/> -->
        <property name="configLocation" value="classpath:mybatisConfig.xml" />
    </bean>


    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.stock.mapper" />
        <!-- <property name="sqlSessionFactory" ref="sqlSessionFactory" /> -->
    </bean>

    <bean id="transactionManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>

    <tx:annotation-driven transaction-manager="transactionManager" />
</beans>