Spring 四种配置数据源

一、spring默认的     DriverManagerDataSource

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

二、JDBC数据源 BasicDataSource

需要导入两种jar包

分别是：

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">    <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>    <property name="url" value="jdbc:mysql:///empdb"></property>    <property name="username" value="root"></property>    <property name="password" value=""></property></bean>

三、C3P0数据源  ComboPooledDataSource   

需要导入jar包：c3p0-0.9.1.2.jar

1.第一种方式：

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">    <property name="driverClass" value="com.mysql.jdbc.Driver"></property>    <property name="jdbcUrl" value="jdbc:mysql:///empdb"></property>    <property name="user" value="root"></property>    <property name="password" value=""></property></bean>

 

2..第二种方式：与database.properties连用

database.properties

jdbc.driver=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/empdb?useUnicode=true&characterEncoding=UTF-8jdbc.username=rootjdbc.password=

<!--1.C3P0数据源-->

<bean id="dataSource" 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>

<!--方式一：找到database.properties 文件-->
<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">    <property name="location" value="classpath:database.properties"></property></bean>

<!--方式二：找到database.properties 文件--><context:property-placeholder location="database.properties"></context:property-placeholder>

四、druib数据源 阿里巴巴 

                      DruidDataSource

需要导入jar包：com.alibaba.druid.jar

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