mybatis interceptor 를 이용해서 쿼리 로그를 출력/디비에다 저장하기

1

2

3

<plugins>

    <plugin interceptor="com.tistory.stove99.UpdateInterceptor"/>

</plugins>

출처: http://stove99.tistory.com/34 [스토브 훌로구]

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

package com.tistory.stove99;   import java.sql.Statement; import java.util.Properties;   import org.apache.ibatis.executor.statement.StatementHandler; 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;   @Intercepts({@Signature(type=StatementHandler.class, method="update", args={Statement.class})}) public class UpdateInterceptor implements Interceptor{           @Override     public Object intercept(Invocation invocation) throws Throwable {         StatementHandler handler = (StatementHandler)invocation.getTarget();                   // 쿼리         String sql = handler.getBoundSql().getSql();                   // 쿼리실행시 맵핑되는 파라메터들         String param = handler.getParameterHandler().getParameterObject()!=null ?                              handler.getParameterHandler().getParameterObject().toString() : "";                   // DB에다 로그 insert         /////////////////         ////////////////                   return invocation.proceed();     }       @Override     public Object plugin(Object target) {         return Plugin.wrap(target, this);     }       @Override     public void setProperties(Properties properties) {     } }

출처: http://stove99.tistory.com/34 [스토브 훌로구]