spring aop记录日志存储在数据库

第一步 创建日志表log

第二步 定义切面类LogAspect

package com.cml.aspect;

import org.aspectj.lang.JoinPoint;
import org.aspectj.lang.ProceedingJoinPoint;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;

/**
 * @author 曹明亮
 * @version 1.0
 */
public class LogAspect {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    //方法前通知
    public void before(JoinPoint joinpoint) {
        System.out.println("方法前通知");
    }
    //方法返回通知
    public void afterReturning(JoinPoint joinpoint) {
        System.out.println("方法返回通知");
    }
    //方法环绕通知
    public Object around(ProceedingJoinPoint joinPoint) throws Throwable {
        //获取方法名
        String methodName = joinPoint.getSignature().getName();
        System.out.printf("[%s] 方法正在执行...\n", methodName);
        //记录方法执行时间
        String begin = String.valueOf(System.currentTimeMillis());
        Object object = joinPoint.proceed();
        //记录方法执行完的时间
        String end = String.valueOf(System.currentTimeMillis());
        System.out.printf("[%s] 方法执行完毕...\n", methodName);
        //获取方法参数列表
        StringBuilder param = new StringBuilder();
        for(Object obj: joinPoint.getArgs()) {
            param.append(obj).append(",");
        }
        String sql = "insert into log(method_name, begin, end, param) values(?, ?, ?, ?)";
        jdbcTemplate.update(sql, methodName, begin, end, param);
        return object;
    }
    //方法抛出异常通知
    public void afterThrowing(JoinPoint joinpoint, Throwable e) {
        System.out.println("方法抛出异常通知:"+e.getMessage());
    }
    //最终通知
    public void after(JoinPoint joinpoint) {
        System.out.println("最终通知");
    }
}

第三步 配置JDBCTemplate和aop:aspect

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       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:component-scan base-package="com.cml"/>
    <!--配置数据源-->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mydb?serverTimezone=Asia/Shanghai"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
    </bean>
    <!--配置JDBC模板-->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--配置切面类-->
    <bean id="logAspect" class="com.cml.aspect.LogAspect"/>
    <!--配置aop-->
    <aop:config>
        <aop:pointcut id="pointcut" expression="execution(* com.cml.service.impl.*.*(..))"/>
        <aop:aspect ref="logAspect">
            <aop:before method="before" pointcut-ref="pointcut"/>
            <aop:after method="after" pointcut-ref="pointcut"/>
            <aop:after-returning method="afterReturning" pointcut-ref="pointcut"/>
            <aop:around method="around" pointcut-ref="pointcut"/>
            <aop:after-throwing method="afterThrowing" pointcut-ref="pointcut" throwing="e"/>
        </aop:aspect>
    </aop:config>
</beans>

第四步 测试运行