spring_DBCP数据库连接池_DataSource配置创建获取

package com.bjsxt.dao.impl;

import java.sql.Connection;
import java.sql.SQLException;

import javax.annotation.Resource;
import javax.sql.DataSource;

import org.springframework.stereotype.Component;

import com.bjsxt.dao.UserDao;
import com.bjsxt.model.User;

@Component("userDaoImpl")
public class UserDaoImpl implements UserDao {
private DataSource dataSource;

public DataSource getDataSource() {
return dataSource;
}

@Resource(name = "myDataSource")
public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}

@Override
public void save(User user) {
try {
Connection cnn = dataSource.getConnection();
cnn.createStatement().executeUpdate(
"insert into user values (null,'zhangsan')");
System.out.println("a save");

} catch (SQLException e) {
e.printStackTrace();
}
}

}

<?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.xsd
         http://www.springframework.org/schema/context
         http://www.springframework.org/schema/context/spring-context.xsd
         http://www.springframework.org/schema/aop 
         http://www.springframework.org/schema/aop/spring-aop.xsd">

<context:annotation-config />
<!-- 自动扫描初始化对象 -->
<context:component-scan base-package="com.bjsxt" />
<!-- 配置数据源DataSource -->
<bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<!-- results in a setDriverClassName(String) call -->
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/spring" />
<property name="username" value="root" />
<property name="password" value="root" />
</bean>

<!-- 初始化该切面类 -->
<bean id="logInterceptor" class="com.bjsxt.aop.LogInterceptor"></bean>
<aop:config>
<!-- 全局切面逻辑范围 -->
<aop:pointcut expression="execution(public * com.bjsxt.dao..*.save(..))"
id="daoPointcut" />
<!-- 声明一个切面对象 -->
<aop:aspect id="logAspect" ref="logInterceptor">
<!-- 在方法执行之前要执行哪个方法 -->
<aop:before method="brefore" pointcut-ref="daoPointcut" />
</aop:aspect>
</aop:config>
</beans>