配置logback使mybatis打印sql

To log SQL statements for particular mybatis mapper set DEBUG (TRACE to see query parameters and results) level for logger with fully qualified mapper name

<logger name="com.mycompany.myapp.mapper.MyMapper" level="DEBUG"/>

You can log all SQL statements from all mappers if they are in the same package like this

<logger name="com.mycompany.myapp.mapper" level="DEBUG"/>




<logger name="org.mybatis">
    <level value="TRACE"/>
</logger>

<logger name="java.sql">
    <level value="WARN"/>
</logger> 

I used the above code snippet in my logback.xml and got the sql query in logger. If require to print sql in specific logger, use tag.

<logger name="liquibase" level="INFO" />
<logger name="ru.company.asplink.dao" level="DEBUG" />
<logger name="org.mybatis">
   <level value="TRACE"/>
</logger>