How does logback log SQL statements?

To print SQL logs using logback, you need to follow these steps:

1. pom.xml refers to the Project Object Model file in a Java project.

<dependency>
    <groupId>ch.qos.logback</groupId>
    <artifactId>logback-classic</artifactId>
    <version>1.2.3</version>
</dependency>

1. The configuration file for logback is logback.xml.
2. logger

<configuration>
    <!-- 其他配置 -->
    
    <logger name="com.example.MySQL" level="DEBUG">
        <appender-ref ref="CONSOLE" />
    </logger>
    
    <!-- 其他配置 -->
</configuration>

In the element, the name attribute specifies the path of the class for printing SQL logs, the level attribute specifies the log level (such as DEBUG, INFO, etc.), and the appender-ref element specifies the output target to be used.

1. logger is Slf4J

String url = "jdbc:mysql://localhost:3306/mydb?logger=Slf4J";

In this way, when you use logback to log SQL statements, the log will be printed to the output destination specified in the logback configuration file.

Please note that the logging level in the above example is set to DEBUG, which means only SQL statements at the DEBUG level and above will be recorded. You can adjust the logging level according to your needs.