欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

java利用mybatis拦截器统计sql执行时间示例

程序员文章站 2024-02-27 12:10:33
可以根据执行时间打印sql语句,打印的sql语句是带参数的,可以拷贝到查询分析器什么的直接运行复制代码 代码如下:package mybatis; import java...

可以根据执行时间打印sql语句,打印的sql语句是带参数的,可以拷贝到查询分析器什么的直接运行

复制代码 代码如下:

package mybatis;

import java.text.dateformat;
import java.util.date;
import java.util.list;
import java.util.locale;
import java.util.properties;

import org.apache.ibatis.executor.executor;
import org.apache.ibatis.mapping.boundsql;
import org.apache.ibatis.mapping.mappedstatement;
import org.apache.ibatis.mapping.parametermapping;
import org.apache.ibatis.plugin.interceptor;
import org.apache.ibatis.plugin.intercepts;
import org.apache.ibatis.plugin.invocation;
import org.apache.ibatis.plugin.plugin;
import org.apache.ibatis.plugin.signature;
import org.apache.ibatis.reflection.metaobject;
import org.apache.ibatis.session.configuration;
import org.apache.ibatis.session.resulthandler;
import org.apache.ibatis.session.rowbounds;
import org.apache.ibatis.type.typehandlerregistry;

@intercepts({
  @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 }) })
public class mybatisinterceptor implements interceptor {

 private properties properties;

 public object intercept(invocation invocation) throws throwable {
  mappedstatement mappedstatement = (mappedstatement) invocation.getargs()[0];
  object parameter = null;
  if (invocation.getargs().length > 1) {
   parameter = invocation.getargs()[1];
  }
  string sqlid = mappedstatement.getid();
  boundsql boundsql = mappedstatement.getboundsql(parameter);
  configuration configuration = mappedstatement.getconfiguration();
  object returnvalue = null;
  long start = system.currenttimemillis();
  returnvalue = invocation.proceed();
  long end = system.currenttimemillis();
  long time = (end - start);
  if (time > 1) {
   string sql = getsql(configuration, boundsql, sqlid, time);
   system.err.println(sql);
  }
  return returnvalue;
 }

 public static string getsql(configuration configuration, boundsql boundsql, string sqlid, long time) {
  string sql = showsql(configuration, boundsql);
  stringbuilder str = new stringbuilder(100);
  str.append(sqlid);
  str.append(":");
  str.append(sql);
  str.append(":");
  str.append(time);
  str.append("ms");
  return str.tostring();
 }

 private static string getparametervalue(object obj) {
  string value = null;
  if (obj instanceof string) {
   value = "'" + obj.tostring() + "'";
  } else if (obj instanceof date) {
   dateformat formatter = dateformat.getdatetimeinstance(dateformat.default, dateformat.default, locale.china);
   value = "'" + formatter.format(new date()) + "'";
  } else {
   if (obj != null) {
    value = obj.tostring();
   } else {
    value = "";
   }

  }
  return value;
 }

 public static string showsql(configuration configuration, boundsql boundsql) {
  object parameterobject = boundsql.getparameterobject();
  list<parametermapping> parametermappings = boundsql.getparametermappings();
  string sql = boundsql.getsql().replaceall("[\\s]+", " ");
  if (parametermappings.size() > 0 && parameterobject != null) {
   typehandlerregistry typehandlerregistry = configuration.gettypehandlerregistry();
   if (typehandlerregistry.hastypehandler(parameterobject.getclass())) {
    sql = sql.replacefirst("\\?", getparametervalue(parameterobject));

   } else {
    metaobject metaobject = configuration.newmetaobject(parameterobject);
    for (parametermapping parametermapping : parametermappings) {
     string propertyname = parametermapping.getproperty();
     if (metaobject.hasgetter(propertyname)) {
      object obj = metaobject.getvalue(propertyname);
      sql = sql.replacefirst("\\?", getparametervalue(obj));
     } else if (boundsql.hasadditionalparameter(propertyname)) {
      object obj = boundsql.getadditionalparameter(propertyname);
      sql = sql.replacefirst("\\?", getparametervalue(obj));
     }
    }
   }
  }
  return sql;
 }

 public object plugin(object target) {
  return plugin.wrap(target, this);
 }

 public void setproperties(properties properties0) {
  this.properties = properties0;
 }
}