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.Driver
jdbc.url=jdbc:mysql://localhost:3306/empdb?useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.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>