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

快来打我* 2022-06-15 05:13 144阅读 0赞

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" />
    	
    	<bean id="myDataSource" class="org.apache.commons.dbcp.BasicDataSource"
    		destroy-method="close">
    		
    		<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>