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>