free mybatis 不生效_为什么我mybatis plugin sql拦截器无效?

博客展示了MyBatis拦截器代码,该拦截器可对查询和更新操作进行拦截,记录SQL执行耗时、ID和具体SQL语句。通过实现Interceptor接口,重写intercept方法,获取相关信息并计算执行时间。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

mybatis拦截器代码:

@Intercepts({

@Signature(type = Executor.class, method = "query", args = {

MappedStatement.class, Object.class, RowBounds.class,

ResultHandler.class}),

@Signature(type = Executor.class, method = "update", args = {

MappedStatement.class, Object.class})})

public class PerformanceInterceptor implements Interceptor {

private static final Logger logger = LoggerFactory.getLogger(PerformanceInterceptor.class);

private static final DateFormat DATE_FORMAT = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

@Override

public Object intercept(Invocation invocation) throws Throwable {

MappedStatement mappedStatement = (MappedStatement) invocation.getArgs()[0];

Object parameterObject = null;

if (invocation.getArgs().length > 1) {

parameterObject = invocation.getArgs()[1];

}

String statementId = mappedStatement.getId();

BoundSql boundSql = mappedStatement.getBoundSql(parameterObject);

Configuration configuration = mappedStatement.getConfiguration();

String sql = getSql(boundSql, parameterObject, configuration);

long start = System.currentTimeMillis();

Object result = invocation.proceed();

long end = System.currentTimeMillis();

long timing = end - start;

logger.info("sql耗时:" + timing + " ms" + " - id:" + statementId + " - Sql:" + sql);

return result;

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值