如何在spring JDBC中启用sql查询控制台日志记录

<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-log4j12</artifactId>
</dependency>

# 设置日志输出级别为DEBUG
log4j.rootLogger=DEBUG, stdout

# 配置日志输出格式
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %-5p %c{1}:%L - %m%n

# 设置数据源
spring.datasource.url=jdbc:mysql://localhost:3306/mydb
spring.datasource.username=username
spring.datasource.password=password

# 设置日志输出级别
logging.level.org.springframework.jdbc.core=DEBUG

@Autowired
private JdbcTemplate jdbcTemplate;

public List<User> getUsers() {
  String sql = "SELECT * FROM users";
  List<User> users = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(User.class));
  return users;
}