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

来源：互联网发布：电脑桌面软件怎么变小编辑：程序博客网时间：2024/05/14 11:17

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;}@Overridepublic 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>

阅读全文

0 0