执行sql日志打印拦截器实现

最新推荐文章于 2024-09-07 12:02:20 发布

淳丶

最新推荐文章于 2024-09-07 12:02:20 发布

阅读量465

点赞数

分类专栏： javaweb 文章标签： java sql mybatis 数据库

本文链接：https://blog.youkuaiyun.com/qq_44767727/article/details/119105284

版权

添加拦截器

@Slf4j
@Intercepts(value = {
   
        @Signature(type = Executor.class, method = "update", args = {
   MappedStatement.class, Object.class}),
        @Signature(type = Executor.class, method = "query", args = {
   MappedStatement.class, Object.class, RowBounds.class, ResultHandler.class, CacheKey.class, BoundSql.class}),
        @Signature(type = Executor.class, method = "query", args = {
   MappedStatement.class, Object.class, RowBounds.class, ResultHandler.class})})
public class SqlStatementInterceptor implements Interceptor {
   

    @Override
    public Object intercept(Invocation invocation) throws Throwable {
   
        Object returnValue;
        long start = System.currentTimeMillis();
        // 执行 SQL语句
        returnValue = invocation.proceed();
        long end = System.currentTimeMillis(