SpringBoot JPA在控制台打印带参sql语句

修改 0. pom.xml添加依赖

3. org.bgee.log4jdbc-log4j2

4. log4jdbc-log4j2-jdbc4.1

5. 1.16

6. `

1. application.properties

1. #spring.datasource.url=jdbc:mysql://114.55.145.131:3306/sky?characterEncoding=UTF-8

2. spring.datasource.url: jdbc:log4jdbc:mysql://114.55.145.131:3306/sky?characterEncoding=UTF-8

3. #spring.datasource.driver-class-name=com.mysql.jdbc.Driver

4. spring.datasource.driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy

2. 新建一个log4jdbc.log4j2.properties

1. # If you use SLF4J. First, you need to tell log4jdbc-log4j2 that you want to use the SLF4J logger

2. log4jdbc.spylogdelegator.name=net.sf.log4jdbc.log.slf4j.Slf4jSpyLogDelegator

不需要下面这个logback.xml文件

3. 新建一个logback.xml

8.  

11. 1-%d{yyyy-MM-dd HH:mm:ss} [%thread] %-5level %logger - %msg%n

12. GBK

15.  
16.  

19. ${LOG_PATH}/${APPDIR}/log_error.log

21. ${LOG_PATH}/${APPDIR}/error/log-error-%d{yyyy-MM-dd}.%i.log

23. 500MB

26. true

28. %d{yyyy-MM-dd HH:mm:ss.SSS} %-5level %logger Line:%-3L - %msg%n

29. utf-8

32. error

33. ACCEPT

34. DENY

37.  

40. ${LOG_PATH}/${APPDIR}/log_warn.log

42. ${LOG_PATH}/${APPDIR}/warn/log-warn-%d{yyyy-MM-dd}.%i.log

44. 2MB

47. true

49. %d{yyyy-MM-dd HH:mm:ss.SSS} %-5level %logger Line:%-3L - %msg%n

50. utf-8

52. warn

53. ACCEPT

54. DENY

57.  
58.  

61. ${LOG_PATH}/${APPDIR}/log_info.log

63. ${LOG_PATH}/${APPDIR}/info/log-info-%d{yyyy-MM-dd}.%i.log

65. 2MB

68. true

70. %d{yyyy-MM-dd HH:mm:ss.SSS} %-5level %logger Line:%-3L - %msg%n

71. utf-8

74. info

75. ACCEPT

76. DENY

79.  

82. %d{yyyy-MM-dd HH:mm:ss.SSS} %-5level %logger Line:%-3L - %msg%n

85.  
93.  
101.  

效果