jdbc.properties 放在classptah目录下
datasource.type=mysql
datasource.driverClassName=com.mysql.jdbc.Driver
datasource.url=jdbc\:mysql\://127.0.0.1\:3306/tzexam?useUnicode\=true&characterEncoding\=UTF-8
datasource.username=rw_all_db
datasource.password=rw_all_db
hibernate.dialect=org.hibernate.dialect.MySQLDialect
#datasource.type=oracle
#datasource.driverClassName=oracle.jdbc.driver.OracleDriver
#datasource.url=jdbc\:oracle\:thin\:@192.168.1.88\:1521\:tzexam?useUnicode\=true&characterEncoding\=utf-8
#datasource.username=root
#datasource.password=root
#hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
applicationContext.xml
EL表达式方式取值
<!-- <bean class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
<property name="location" value="classpath:jdbc.properties"></property>
</bean> -->
<!-- 导入src目录下的jdbc.properties文件 -->
<context:property-placeholder location="classpath:jdbc.properties"/>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${datasource.driverClassName}"></property>
<property name="url" value="${datasource.url}"></property>
<property name="username" value="${datasource.username}"></property>
<property name="password" value="${datasource.password}"></property>
</bean>
package com.test;
import java.sql.SQLException;
import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.ioc.web.UserController;
public class Test3 {
public static void main(String[] args) throws SQLException {
ApplicationContext context = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
BasicDataSource dataSource = (BasicDataSource) context.getBean("dataSource");
System.out.println(dataSource.getConnection());
}
}
结果:
org.apache.commons.dbcp.PoolableConnection@5d740a0f