spring中常用数据源----用于当做资料，方便查找

最新推荐文章于 2024-02-28 11:24:21 发布

TomorrowOkk

最新推荐文章于 2024-02-28 11:24:21 发布

阅读量151

点赞数

本文链接：https://blog.csdn.net/qq_40756936/article/details/109168650

版权

1.C3p0数据源

<dependency>
    <groupId>com.mchange</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.5.2</version>
</dependency>
<bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
    <property name="url" value="jdbc:mysql:///ddd"></property>
    <property name="user" value="root"></property>
    <property name="password" value="root"></property>
</bean>

2.Dbcp数据源

<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-dbcp2</artifactId>
    <version>2.1.1</version>
</dependency>
<bean name="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
     <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    <property name="url" value="jdbc:mysql:///ddd"></property>
    <property name="username" value="root"></property>
    <property name="password" value="root"></property>
</bean>

3.Druid数据源(阿里) 注意，要写：destroy-method=”close”

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.20</version>
</dependency>
<bean name="dataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method=”close”>
    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    <property name="url" value="jdbc:mysql:///ddd"></property>
    <property name="username" value="root"></property>
    <property name="password" value="root"></property>
</bean>

4.Spring自动数据源

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>$4.3.0.RELEASE</version>
</dependency>

<bean name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    <property name="url" value="jdbc:mysql:///ddd"></property>
    <property name="username" value="root"></property>
    <property name="password" value="root"></property>
</bean>

5.Hikari(光)数据源

<dependency>
    <groupId>hikari-cp</groupId>
    <artifactId>hikari-cp</artifactId>
    <version>2.8.0</version>
</dependency>
<bean name="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="shutdown">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
    <property name="jdbcUrl" value="jdbc:mysql:///ddd"></property>
    <property name="username" value="root"></property>
    <property name="password" value="root"></property>
</bean>