MyBatis拦截器打印不带问号的完整sql语句方法 - 星朝 - 博客园
1
/* Preparing: SELECT * FROM tb_user WHERE id = ? AND user_name = ? <br> 目标是打印：SELECT * FROM tb_user WHERE id = 1000059081 AND user_name = '积极'<br>*/ 这部分代码只是拦截了查询和更新，如果想对其他语句进行拦截，在`@Intercepts`中添加对应方法即可
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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<br>`package dao.Interceptor;`
import org.apache.commons.collections.CollectionUtils;
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.*;
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;
import java.text.DateFormat;
import java.util.Date;
import java.util.List;
import java.util.Locale;
import java.util.Properties;
import java.util.regex.Matcher;
@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 }) })`
@SuppressWarnings`({"unchecked", "rawtypes"`})
public class MybatisInterceptor implements Interceptor {
@Override
public Object intercept(Invocation invocation) throws Throwable {
try`{`
MappedStatement mappedStatement = (MappedStatement) invocation.getArgs()[`0`]; // 获取xml中的一个select/update/insert/delete节点，主要描述的是一条SQL语句
Object parameter = null`;`
// 获取参数，if语句成立，表示sql语句有参数，参数格式是map形式
if (invocation.getArgs().length > 1`) {`
parameter = invocation.getArgs()[`1`];
System.out.println(`"parameter = " + parameter);`
}
String sqlId = mappedStatement.getId(); // 获取到节点的id,即sql语句的id
System.out.println(`"sqlId = " + sqlId);`
BoundSql boundSql = mappedStatement.getBoundSql(parameter); // BoundSql就是封装myBatis最终产生的sql类
Configuration configuration = mappedStatement.getConfiguration(); // 获取节点的配置
String sql = getSql(configuration, boundSql, sqlId); // 获取到最终的sql语句
System.out.println(`"sql = " + sql);`
//log.debug(sql);
}`catch`(Exception e){
// log.error(e.getMessage(), e);
}
return invocation.proceed(); // 执行完上面的任务后，不改变原有的sql执行过程
}
// 封装了一下sql语句，使得结果返回完整xml路径下的sql语句节点id + sql语句
public static String getSql(Configuration configuration, BoundSql boundSql,String sqlId) {
String sql = showSql(configuration, boundSql);
StringBuilder str = new StringBuilder(`100`);
str.append(sqlId);
str.append(`":"`);
str.append(sql);
return str.toString();
}
/*<br> *如果参数是String，则添加单引号， 如果是日期，则转换为时间格式器并加单引号； 对参数是null和不是null的情况作了处理<br> */
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]+",` `" "); // sql语句中多个空格都用一个空格代替`
if (CollectionUtils.isNotEmpty(parameterMappings) && parameterObject != null`) {`
TypeHandlerRegistry typeHandlerRegistry = configuration.getTypeHandlerRegistry(); // 获取类型处理器注册器，类型处理器的功能是进行java类型和数据库类型的转换<br> // 如果根据parameterObject.getClass(）可以找到对应的类型，则替换
if (typeHandlerRegistry.hasTypeHandler(parameterObject.getClass())) {
sql = sql.replaceFirst(`"\?"`, Matcher.quoteReplacement(getParameterValue(parameterObject)));
} else {
MetaObject metaObject = configuration.newMetaObject(parameterObject);`// MetaObject主要是封装了originalObject对象，提供了get和set的方法用于获取和设置originalObject的属性值,主要支持对JavaBean、Collection、Map三种类型对象的操作`
for (ParameterMapping parameterMapping : parameterMappings) {
String propertyName = parameterMapping.getProperty();
if (metaObject.hasGetter(propertyName)) {
Object obj = metaObject.getValue(propertyName);
sql = sql.replaceFirst(`"\?"`, Matcher.quoteReplacement(getParameterValue(obj)));
} else if (boundSql.hasAdditionalParameter(propertyName)) {
Object obj = boundSql.getAdditionalParameter(propertyName); // 该分支是动态sql
sql = sql.replaceFirst(`"\?"`, Matcher.quoteReplacement(getParameterValue(obj)));
}`else{sql=sql.replaceFirst("\?","缺失");}//打印出缺失，提醒该参数缺失并防止错位`
}
}
}
return sql;
}
@Override
public Object plugin(Object target) {
return Plugin.wrap(target, this`);`
}
@Override
public void setProperties(Properties properties) {
}
}
Mybatis配置文件如下：
; "复制代码")
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<！--该路径是拦截器文件的路径 dao.Interceptor是拦截器文件的包名称>
<plugins>
<plugin interceptor="dao.Interceptor.MybatisInterceptor">
</plugin>
</plugins>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC">
<property name="" value=""></property>
</transactionManager>
<dataSource type="UNPOOLED">
<property name="driver" value="oracle.jdbc.driver.OracleDriver"></property>>
<property name="url" value="jdbc:oracle:thin:@xx.xxx.xxx.xxx:端口:oratest"></property>
<property name="username" value="用户名"></property>
<property name="password" value="密码"></property>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="mybatis/UserMapper.xml"/>
_</mappers>
</configuration>_
; "复制代码")
Original url: Access
Created at: 2019-09-02 16:40:12
Category: default
Tags: none
未标明原创文章均为采集，版权归作者所有，转载无需和我联系，请注明原出处，南摩阿彌陀佛，知识，不只知道，要得到
最新评论