Spring_009_DataSource

1、导入相关的包：commons-dbcp.jar、commons-pool.jar、oracle 的驱动包

beans.xml配置文件如下：

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:aop="http://www.springframework.org/schema/aop"       xsi:schemaLocation="http://www.springframework.org/schema/beans           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd           http://www.springframework.org/schema/context           http://www.springframework.org/schema/context/spring-context-2.5.xsd           http://www.springframework.org/schema/aop           http://www.springframework.org/schema/aop/spring-aop-2.5.xsd"><context:annotation-config/><context:component-scan base-package="com.jimmy" /><bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">  <!-- results in a setDriverClassName(String) call -->  <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>  <property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:ORCL"/>  <property name="username" value="hibernate"/>  <property name="password" value="1"/></bean></beans>

dao的实现类如下：

package com.jimmy.dao.imp;import java.sql.Connection;import java.sql.SQLException;import javax.annotation.Resource;import javax.sql.DataSource;import org.springframework.stereotype.Component;import com.jimmy.dao.UserDao;import com.jimmy.model.User;@Component("u")public class UserOracleDao implements UserDao {private int daoId;private DataSource dataSource;public int getDaoId() {return daoId;}public void setDaoId(int daoId) {this.daoId = daoId;}public DataSource getDataSource() {return dataSource;}@Resourcepublic void setDataSource(DataSource dataSource) {this.dataSource = dataSource;}public void add(User u) {Connection conn=null;try {conn=dataSource.getConnection();conn.createStatement().executeUpdate("insert into school values(1,'fugao')");conn.commit();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}@Overridepublic String toString(){return "id="+daoId;}}

将dataSource注入到实现dao里面

 

二、采用配置文件的方式

beanx.xml配置文件如下：

<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"       xmlns:context="http://www.springframework.org/schema/context"       xmlns:aop="http://www.springframework.org/schema/aop"       xsi:schemaLocation="http://www.springframework.org/schema/beans           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd           http://www.springframework.org/schema/context           http://www.springframework.org/schema/context/spring-context-2.5.xsd           http://www.springframework.org/schema/aop           http://www.springframework.org/schema/aop/spring-aop-2.5.xsd"><context:annotation-config/><context:component-scan base-package="com.jimmy" /><bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">    <property name="locations">        <value>classpath:jdbc.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></beans>

 

jdbc.properties文件如下：

jdbc.driverClassName=oracle.jdbc.driver.OracleDriverjdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:ORCLjdbc.username=hibernatejdbc.password=1