前言
我这里以,拦截mapper,统计数据库耗时为例。
代码
1.主要依赖
<!-- web依赖--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!-- springboot测试依赖--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>io.springfox</groupId> <artifactId>springfox-swagger2</artifactId> <version>2.9.2</version> </dependency> <!-- 切面编程依赖--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-aop</artifactId> </dependency> <!-- lombok依赖--> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> </dependency> <!-- 数据库依赖--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.5.2</version> </dependency> <dependency> <groupId>com.mysql</groupId> <artifactId>mysql-connector-j</artifactId> </dependency> <!-- 工具类--> <dependency> <groupId>cn.hutool</groupId> <artifactId>hutool-all</artifactId> <version>5.8.18</version> </dependency>
2. 配置类
#数据库配置 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/aop_demo spring.datasource.username=root spring.datasource.password=123456
2.编写实体
@Data @TableName("aop_demo") public class AopDemo { @TableId(type = IdType.AUTO) private Long id; private String name; }
3.编写mapper
1.AopDemoMapper
@Repository @Mapper public interface AopDemoMapper extends BaseMapper<AopDemoMapper> { }
2.mapper.xml
集成了mabatis-plus,还提供xml,主要是提高了灵活度
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.example.demo.mapper.AopDemoMapper"> </mapper>
4.编写service
1.接口
public interface IAopDemoService extends IService<AopDemo> { }
2.实现类
@Service public class AopDemoServiceImpl extends ServiceImpl<AopDemoMapper, AopDemo>implements IAopDemoService { }
5.编写controller
@RestController @RequestMapping("/aopDemo") public class AopDemoController { @Autowired private IAopDemoService aopDemoService; @GetMapping("/{id}") public List<AopDemo> testAop(@PathVariable String id) { return aopDemoService.list(); } }
6.编写AOP
@Aspect @Component public class AopDemoAspect { /** * 定义切点 * 语句:* com.example.demo.mapper.*mapper.*(..) * 翻译: * 1.第一个*:任何修饰符和返回值 * 2.com.example.demo.mapper.*Mapper.*(..): mapper包下的所有以Mapper为结尾的类,比如AopDemoMapper * 3.*(..):类下面的所有方法,所有参数 */ @Pointcut("execution(* com.example.demo.mapper.*Mapper.*(..))") public void mapperPoinCut() {} /** * 引入切点 * @return */ @Around("mapperPoinCut()") public Object mapperLog(ProceedingJoinPoint point) { System.out.println("进来AOP"); //开始时间 DateTime startTime = DateTime.now(); try { //开始执行 Object proceed = point.proceed(); //计算耗时时间 long between = DateUtil.between(startTime, DateTime.now(), DateUnit.SECOND); System.out.println("数据库耗时为:" + between + "s"); //执行结果,必须返回,否则执行方法没有返回结果; return proceed; } catch (Throwable throwable) { throw new RuntimeException("数据库统计耗时失败",throwable); } } }