spring连接数据库

1.dao层需要添加一个DataSource类型的dataSource属性,并添加相应的get和set方法

private DataSource dataSource;
	
	public DataSource getDataSource() {
		return dataSource;
	}
	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}

2.

A.application里需要有相应的配置(直接写的方式)

<bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin:@localhost:1521/orcl"/>
        <property name="username" value="scott"/>
        <property name="password" value="123456"/>
    </bean>

<bean id="userDao" class="com.hcj.dao.impl.UserDaoImpl">
		<property name="dataSource" ref="dataSource"></property>
		
	</bean>

B.通过配置属性文件的方式

applicationContext.xml的配置如下

<bean
	class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<!-- classpath:hcj.properties为属性文件在工程下的位置，这里的hcj.propertise在src下 -->
			<value>classpath:hcj.properties</value>
		</property>
	</bean>
	
	<bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource" >
        <property name="driverClassName" value="${jdbc.driverClassName}"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        
    </bean>

属性文件中的配置如下

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521/orcl
jdbc.username=scott
jdbc.password=123456