mybatis-Spring boot 集成Mybatis怎么在控制台打印sql语句
发布网友
发布时间：2022-04-07 23:43
我来回答
共2个回答
懂视网
时间：2022-04-08 04:04
public <T> T execute(PreparedStatementCreator psc, PreparedStatementCallback<T> action)
2 throws DataAccessException {
3
4 Assert.notNull(psc, "PreparedStatementCreator must not be null");
5 Assert.notNull(action, "Callback object must not be null");
6 if (logger.isDebugEnabled()) {
7 String sql = getSql(psc);
8 logger.debug("Executing prepared SQL statement" + (sql != null ? " [" + sql + "]" : ""));
9 }
10
11 Connection con = DataSourceUtils.getConnection(getDataSource());
12 PreparedStatement ps = null;
13 try {
14 Connection conToUse = con;
15 if (this.nativeJdbcExtractor != null &&
16 this.nativeJdbcExtractor.isNativeConnectionNecessaryForNativePreparedStatements()) {
17 conToUse = this.nativeJdbcExtractor.getNativeConnection(con);
18 }
19 ps = psc.createPreparedStatement(conToUse);
20 applyStatementSettings(ps);
21 PreparedStatement psToUse = ps;
22 if (this.nativeJdbcExtractor != null) {
23 psToUse = this.nativeJdbcExtractor.getNativePreparedStatement(ps);
24 }
25 T result = action.doInPreparedStatement(psToUse);
26 handleWarnings(ps);
27 return result;
28 }
29 catch (SQLException ex) {
30 // Release Connection early, to avoid potential connection pool deadlock
31 // in the case when the exception translator hasn‘t been initialized yet.
32 if (psc instanceof ParameterDisposer) {
33 ((ParameterDisposer) psc).cleanupParameters();
34 }
35 String sql = getSql(psc);
36 psc = null;
37 JdbcUtils.closeStatement(ps);
38 ps = null;
39 DataSourceUtils.releaseConnection(con, getDataSource());
40 con = null;
41 throw getExceptionTranslator().translate("PreparedStatementCallback", sql, ex);
42 }
43 finally {
44 if (psc instanceof ParameterDisposer) {
45 ((ParameterDisposer) psc).cleanupParameters();
46 }
47 JdbcUtils.closeStatement(ps);
48 DataSourceUtils.releaseConnection(con, getDataSource());
49 }
50 }
以上我们说的只是个例子，其实这个猜一下也大概知道应该是日志级别的配置问题。通过这个小问题我只想说的是，有时候遇到问题，不一定急着去问朋友、同事，或者google，百度，何况google那么难上去。开源的程序的话自己看下源码，问题说不行就解决了。这样对自己来说好处多多
源码分析之spring-JdbcTemplate日志打印sql语句
标签：
热心网友
时间：2022-04-08 01:12
一、需要mybatis和log4j的jar；
二、然后在log4j.properties文件里面将下面的代码粘贴进去就可以了：
版本一：
[java] view plain copy
<span style="font-size:12px;">log4j.rootLogger=DEBUG, Console
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG</span>
版本二：
[java] view plain copy
<span style="font-size:12px;">log4j.rootLogger = ${log.level},Console,default,allfile
log4j.logger.com.ibatis=debug
log4j.logger.java.sql=debug
log4j.logger.com.sf.egmas.dcn.web.mapper=debug</span>
