spring数据库操作配置实例

spring数据库操作配置实例

---

1.datasource.properties

2.applicationContext.xml

---

1.datasource.properties

DATABASE.URL=jdbc:mysql://localhost:3306/test
DATABASE.DriverClassName=com.mysql.jdbc.Driver
DATABASE.UserName=root
DATABASE.Password=123456

---

2.applicationContext.xml

    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <value>datasource.properties</value>
        </property>
    </bean>

    <!-- the DataSource (parameterized for configuration via a PropertyPlaceHolderConfigurer) -->
    <bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${DATABASE.DriverClassName}"/>
        <property name="url" value="${DATABASE.URL}"/>
        <property name="username" value="${DATABASE.UserName}"/>
        <property name="password" value="${DATABASE.Password}"/>
    </bean>
   
   
    <bean id="jdbcTest" class="JdbcTest">
        <property name="dataSource" ref="dataSource"/>
    </bean>