blocks|key|1062421|text|有可能显示该information.iBatis使用了包括Log4J在内的一些日志记录框架。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1062422|要使用Log4J，请在类路径中创建文件log4j.properties。您必须在文件中添加接下来的几行，例如：|1062423|log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
 +  
log4j.logger.com.ibatis=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG|code-block|syntax|javascript|1062424|有关其他日志记录框架和详细信息，请参阅this+link|1062425|entityMap|0|LINK|mutability|MUTABLE|url|http://ibatisnet.sourceforge.net/DevGuide.html#d0e2600^0|T|5|0|3|5|J|G|0|0|J|9|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@$9|10|A|11|B|C]|$9|12|A|13|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|14|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|15|8|@]|D|@$9|16|A|17|1|18]]|E|$]]|$1|O|3|-4|5|6|7|19|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

It's posible to show this information.iBatis uses some the Logging framework including <code>Log4J</code>. 
To use <code>Log4J</code> create file <code>log4j.properties</code> in the class path.You've to put the next lines in the file for example:

<pre><code>log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
    
log4j.logger.com.ibatis=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
</code></pre>

For other logging framework and detail info see <a href="http://ibatisnet.sourceforge.net/DevGuide.html#d0e2600" rel="nofollow noreferrer">this link</a>

blocks|key|1062486|text|将其添加到您的log4j.xml文件中，您可以在控制台上看到输出。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1062487|<logger+name="java.sql"+additivity="false">
++++<level+value="debug"+/>
++++<appender-ref+ref="console"+/>
</logger>|code-block|syntax|javascript|1062488|您将看到传递的参数、执行的查询和查询的输出。|1062489|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Add this to your log4j.xml file and you can see the output on console. 

<pre><code>&lt;logger name="java.sql" additivity="false"&gt;
 &lt;level value="debug" /&gt;
 &lt;appender-ref ref="console" /&gt;
&lt;/logger&gt;
</code></pre>

You will see the parameters being passed, the query being executed and the output of query.

blocks|key|1277274|text|从SqlSessionFactory获取Configuration对象，然后：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1277275|MappedStatement+ms+=+configuration.getMappedStatement("MyMappedStatementId");
BoundSql+boundSql+=+ms.getBoundSql(parameters);+//+pass+in+parameters+for+the+SQL+statement
System.out.println("SQL"+%2B+boundSql.getSql());|code-block|syntax|javascript|1277276|entityMap^0|1|H|K|D|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

Get the <code>Configuration</code> object from your <code>SqlSessionFactory</code>, then:

<pre><code>MappedStatement ms = configuration.getMappedStatement("MyMappedStatementId");
BoundSql boundSql = ms.getBoundSql(parameters); // pass in parameters for the SQL statement
System.out.println("SQL" + boundSql.getSql());
</code></pre>

blocks|key|1062530|text|++++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.MappedStatement.Builder;
++++import+org.apache.ibatis.mapping.SqlSource;
++++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.session.ResultHandler;
++++import+org.apache.ibatis.session.RowBounds;

++++import+com.gm.common.orm.mybatis.dialect.Dialect;
++++import+com.gm.common.utils.PropertiesHelper;

++++/**
+++++*+为Mybatis提供基于方言(Dialect)的分页查询的插件
+++++*+
+++++*+将拦截Executor.query()方法实现分页方言的插入.
+++++*+
+++++*+配置文件内容:
+++++*+
+++++*+<pre>
+++++*++&lt;plugins>
+++++*++&lt;plugin+interceptor="com.gm.common.orm.mybatis.plugin.OffsetLimitInterceptor">
+++++*++++++&lt;property+name="dialectClass"+value="com.gm.common.orm.mybatis.dialect.MySQLDialect"/>
+++++*++&lt;/plugin>
+++++*+&lt;/plugins>
+++++*+</pre>
+++++*/

++++@Intercepts({@Signature(type=Executor.class,method="query",args={MappedStatement.class,Object.class,RowBounds.class,ResultHandler.class})})
++++public+class+OffsetLimitInterceptor+implements++Interceptor+{
++++++++static+int+MAPPED_STATEMENT_INDEX+=+0;
++++++++static+int+PARAMETER_INDEX+=+1;
++++++++static+int+ROWBOUNDS_INDEX+=+2;
++++++++static+int+RESULT_HANDLER_INDEX+=+3;

++++++++Dialect+dialect;

++++++++public+Object+intercept(Invocation+invocation)+throws+Throwable+{
++++++++++++processIntercept(invocation.getArgs());
++++++++++++return+invocation.proceed();
++++++++}

++++++++void+processIntercept(final+Object[]+queryArgs)+{
++++++++++++//+queryArgs+=+query(MappedStatement+ms,+Object+parameter,+RowBounds
++++++++++++//+rowBounds,+ResultHandler+resultHandler)
++++++++++++MappedStatement+ms+=+(MappedStatement)+queryArgs[MAPPED_STATEMENT_INDEX];
++++++++++++Object+parameter+=+queryArgs[PARAMETER_INDEX];
++++++++++++final+RowBounds+rowBounds+=+(RowBounds)+queryArgs[ROWBOUNDS_INDEX];
++++++++++++int+offset+=+rowBounds.getOffset();
++++++++++++int+limit+=+rowBounds.getLimit();

++++++++++++if+(dialect.supportsLimit()
++++++++++++++++++++&&+(offset+!=+RowBounds.NO_ROW_OFFSET+%7C%7C+limit+!=+RowBounds.NO_ROW_LIMIT))+{
++++++++++++++++BoundSql+boundSql+=+ms.getBoundSql(parameter);
++++++++++++++++String+sql+=+boundSql.getSql().trim();
++++++++++++++++if+(dialect.supportsLimitOffset())+{
++++++++++++++++++++sql+=+dialect.getLimitString(sql,+offset,+limit);
++++++++++++++++++++offset+=+RowBounds.NO_ROW_OFFSET;
++++++++++++++++}+else+{
++++++++++++++++++++sql+=+dialect.getLimitString(sql,+0,+limit);
++++++++++++++++}
++++++++++++++++limit+=+RowBounds.NO_ROW_LIMIT;

++++++++++++++++queryArgs[ROWBOUNDS_INDEX]+=+new+RowBounds(offset,+limit);
++++++++++++++++BoundSql+newBoundSql+=+new+BoundSql(ms.getConfiguration(),
++++++++++++++++++++++++sql,+boundSql.getParameterMappings(),+boundSql
++++++++++++++++++++++++++++++++.getParameterObject());
++++++++++++++++MappedStatement+newMs+=+copyFromMappedStatement(ms,
++++++++++++++++++++++++new+BoundSqlSqlSource(newBoundSql));
++++++++++++++++queryArgs[MAPPED_STATEMENT_INDEX]+=+newMs;
++++++++++++}
++++++++}

++++++++//+see:+MapperBuilderAssistant
++++++++private+MappedStatement+copyFromMappedStatement(MappedStatement+ms,
++++++++++++++++SqlSource+newSqlSource)+{
++++++++++++Builder+builder+=+new+MappedStatement.Builder(ms
++++++++++++++++++++.getConfiguration(),+ms.getId(),+newSqlSource,+ms
++++++++++++++++++++.getSqlCommandType());

++++++++++++builder.resource(ms.getResource());
++++++++++++builder.fetchSize(ms.getFetchSize());
++++++++++++builder.statementType(ms.getStatementType());
++++++++++++builder.keyGenerator(ms.getKeyGenerator());
++++++++++++builder.keyProperty(ms.getKeyProperty());

++++++++++++//+setStatementTimeout()
++++++++++++builder.timeout(ms.getTimeout());

++++++++++++//+setStatementResultMap()
++++++++++++builder.parameterMap(ms.getParameterMap());

++++++++++++//+setStatementResultMap()
++++++++++++builder.resultMaps(ms.getResultMaps());
++++++++++++builder.resultSetType(ms.getResultSetType());

++++++++++++//+setStatementCache()
++++++++++++builder.cache(ms.getCache());
++++++++++++builder.flushCacheRequired(ms.isFlushCacheRequired());
++++++++++++builder.useCache(ms.isUseCache());

++++++++++++return+builder.build();
++++++++}

++++++++public+Object+plugin(Object+target)+{
++++++++++++return+Plugin.wrap(target,+this+);
++++++++}

++++++++public+void+setProperties(Properties+properties)+{
++++++++++++String+dialectClass+=+new+PropertiesHelper(properties)
++++++++++++++++++++.getRequiredString("dialectClass");
++++++++++++try+{
++++++++++++++++dialect+=+(Dialect)+Class.forName(dialectClass)
++++++++++++++++++++++++.newInstance();
++++++++++++}+catch+(Exception+e)+{
++++++++++++++++throw+new+RuntimeException(
++++++++++++++++++++++++"cannot+create+dialect+instance+by+dialectClass:"
++++++++++++++++++++++++++++++++%2B+dialectClass,+e);
++++++++++++}
++++++++++++System.out.println(OffsetLimitInterceptor.class.getSimpleName()
++++++++++++++++++++%2B+".dialect="+%2B+dialectClass);
++++++++}

++++++++public+static+class+BoundSqlSqlSource+implements++SqlSource+{
++++++++++++BoundSql+boundSql;

++++++++++++public+BoundSqlSqlSource(BoundSql+boundSql)+{
++++++++++++++++this+.boundSql+=+boundSql;
++++++++++++}

++++++++++++public+BoundSql+getBoundSql(Object+parameterObject)+{
++++++++++++++++return+boundSql;
++++++++++++}
++++++++}

++++}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1062531|我的推荐人：https://www.java2s.com/Open-Source/Java-Document-2/UnTagged/gmc/com/gm/common/orm/mybatis/plugin/OffsetLimitInterceptor.java.htm|unstyled|offset|length|1062532|entityMap|0|LINK|mutability|MUTABLE|url|https://www.java2s.com/Open-Source/Java-Document-2/UnTagged/gmc/com/gm/common/orm/mybatis/plugin/OffsetLimitInterceptor.java.htm^0|0|6|3K|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|R|8|@]|9|@$G|S|H|T|1|U]]|A|$]]|$1|I|3|-4|5|F|7|V|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

<pre><code> 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.MappedStatement.Builder;
 import org.apache.ibatis.mapping.SqlSource;
 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.session.ResultHandler;
 import org.apache.ibatis.session.RowBounds;

 import com.gm.common.orm.mybatis.dialect.Dialect;
 import com.gm.common.utils.PropertiesHelper;

 /**
 * 为Mybatis提供基于方言(Dialect)的分页查询的插件
 * 
 * 将拦截Executor.query()方法实现分页方言的插入.
 * 
 * 配置文件内容:
 * 
 * &lt;pre&gt;
 * &amp;lt;plugins&gt;
 * &amp;lt;plugin interceptor="com.gm.common.orm.mybatis.plugin.OffsetLimitInterceptor"&gt;
 * &amp;lt;property name="dialectClass" value="com.gm.common.orm.mybatis.dialect.MySQLDialect"/&gt;
 * &amp;lt;/plugin&gt;
 * &amp;lt;/plugins&gt;
 * &lt;/pre&gt;
 */

 @Intercepts({@Signature(type=Executor.class,method="query",args={MappedStatement.class,Object.class,RowBounds.class,ResultHandler.class})})
 public class OffsetLimitInterceptor implements Interceptor {
 static int MAPPED_STATEMENT_INDEX = 0;
 static int PARAMETER_INDEX = 1;
 static int ROWBOUNDS_INDEX = 2;
 static int RESULT_HANDLER_INDEX = 3;

 Dialect dialect;

 public Object intercept(Invocation invocation) throws Throwable {
 processIntercept(invocation.getArgs());
 return invocation.proceed();
 }

 void processIntercept(final Object[] queryArgs) {
 // queryArgs = query(MappedStatement ms, Object parameter, RowBounds
 // rowBounds, ResultHandler resultHandler)
 MappedStatement ms = (MappedStatement) queryArgs[MAPPED_STATEMENT_INDEX];
 Object parameter = queryArgs[PARAMETER_INDEX];
 final RowBounds rowBounds = (RowBounds) queryArgs[ROWBOUNDS_INDEX];
 int offset = rowBounds.getOffset();
 int limit = rowBounds.getLimit();

 if (dialect.supportsLimit()
 &amp;&amp; (offset != RowBounds.NO_ROW_OFFSET || limit != RowBounds.NO_ROW_LIMIT)) {
 BoundSql boundSql = ms.getBoundSql(parameter);
 String sql = boundSql.getSql().trim();
 if (dialect.supportsLimitOffset()) {
 sql = dialect.getLimitString(sql, offset, limit);
 offset = RowBounds.NO_ROW_OFFSET;
 } else {
 sql = dialect.getLimitString(sql, 0, limit);
 }
 limit = RowBounds.NO_ROW_LIMIT;

 queryArgs[ROWBOUNDS_INDEX] = new RowBounds(offset, limit);
 BoundSql newBoundSql = new BoundSql(ms.getConfiguration(),
 sql, boundSql.getParameterMappings(), boundSql
 .getParameterObject());
 MappedStatement newMs = copyFromMappedStatement(ms,
 new BoundSqlSqlSource(newBoundSql));
 queryArgs[MAPPED_STATEMENT_INDEX] = newMs;
 }
 }

 // see: MapperBuilderAssistant
 private MappedStatement copyFromMappedStatement(MappedStatement ms,
 SqlSource newSqlSource) {
 Builder builder = new MappedStatement.Builder(ms
 .getConfiguration(), ms.getId(), newSqlSource, ms
 .getSqlCommandType());

 builder.resource(ms.getResource());
 builder.fetchSize(ms.getFetchSize());
 builder.statementType(ms.getStatementType());
 builder.keyGenerator(ms.getKeyGenerator());
 builder.keyProperty(ms.getKeyProperty());

 // setStatementTimeout()
 builder.timeout(ms.getTimeout());

 // setStatementResultMap()
 builder.parameterMap(ms.getParameterMap());

 // setStatementResultMap()
 builder.resultMaps(ms.getResultMaps());
 builder.resultSetType(ms.getResultSetType());

 // setStatementCache()
 builder.cache(ms.getCache());
 builder.flushCacheRequired(ms.isFlushCacheRequired());
 builder.useCache(ms.isUseCache());

 return builder.build();
 }

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

 public void setProperties(Properties properties) {
 String dialectClass = new PropertiesHelper(properties)
 .getRequiredString("dialectClass");
 try {
 dialect = (Dialect) Class.forName(dialectClass)
 .newInstance();
 } catch (Exception e) {
 throw new RuntimeException(
 "cannot create dialect instance by dialectClass:"
 + dialectClass, e);
 }
 System.out.println(OffsetLimitInterceptor.class.getSimpleName()
 + ".dialect=" + dialectClass);
 }

 public static class BoundSqlSqlSource implements SqlSource {
 BoundSql boundSql;

 public BoundSqlSqlSource(BoundSql boundSql) {
 this .boundSql = boundSql;
 }

 public BoundSql getBoundSql(Object parameterObject) {
 return boundSql;
 }
 }

 }
</code></pre>

My reference : <a href="https://www.java2s.com/Open-Source/Java-Document-2/UnTagged/gmc/com/gm/common/orm/mybatis/plugin/OffsetLimitInterceptor.java.htm" rel="nofollow">https://www.java2s.com/Open-Source/Java-Document-2/UnTagged/gmc/com/gm/common/orm/mybatis/plugin/OffsetLimitInterceptor.java.htm</a>

blocks|key|1062340|text|大多数SQL引擎允许您“记录”所有执行的查询(通常还包括查询所用的时间、返回的结果数量等信息)。你有权访问你的引擎日志吗?你能配置它来记录你所需要的一切吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1062341|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Most SQL engines allow you to "log" all the queries executed (typically together with information about the time the query took, the number of results it returned, and the like). Do you have access to your engine's logs, and can you configure it so it will log all you need?

blocks|key|1062363|text|为此，您可以使用p6spy或jdbcdslog。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1062364|entityMap|0|LINK|mutability|MUTABLE|url|http://www.p6spy.com/|1|http://code.google.com/p/jdbcdslog/^0|8|5|0|E|9|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

You can use <a href="http://www.p6spy.com/" rel="nofollow noreferrer">p6spy</a> or <a href="http://code.google.com/p/jdbcdslog/" rel="nofollow noreferrer">jdbcdslog</a> for that.

Is there any way where I can get the executed query of iBatis? I want to reuse the query for an UNION query.

For example:

<pre><code>&lt;sqlMap namespace="userSQLMap"&gt;
 &lt;select id="getUser" resultClass="UserPackage.User"&gt;
 SELECT username,
 password 
 FROM table 
 WHERE id=#value#
 &lt;/select&gt;
&lt;/sqlMap&gt;
</code></pre>

And when I execute the query through

<pre><code>int id = 1
List&lt;User&gt; userList = queryDAO.executeForObjectList("userSQLMap.getUser",id)
</code></pre>

I want to get <code>SELECT username, password FROM table WHERE id=1</code>

Is there any way I could get the query? 

Thanks.

iBatis get executed sql

有没有办法可以得到iBatis的执行查询？我希望将该查询重用于UNION查询。例如：<sqlMap namespace="userSQLMap"> <select id="getUser" resultClass="UserPackage.User"> SELECT username, password FROM table

问iBatis获取已执行的sql
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问iBatis获取已执行的sqlEN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问iBatis获取已执行的sql
EN