網頁

2020/12/30

Spring Boot JdbcTemplate 印出SQL及參數 print query sql and params

在Spring Boot使用JdbcTemplate在console印出執行的SQL及條件參數的方法如下。

在專案的application.properties加入logging.level.org.springframework.jdbc.core=TRACE即可。

application.properties

logging.level.org.springframework.jdbc.core=TRACE

例如在EmployeeDao中使用NamedParameterJdbcTemplate執行SQL。

EmployeeDao

package com.abc.demo.dao;

import com.abc.demo.entity.Employee;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Service;

@Service
public class EmployeeDao {

    @Autowired
    private NamedParameterJdbcTemplate namedParameterJdbcTemplate;

    public Employee findById(long id) {
        String sql = "select * from EMPLOYEE where id = :id";
        MapSqlParameterSource params = new MapSqlParameterSource();
        params.addValue("id", id);
        return namedParameterJdbcTemplate.queryForObject(sql, params, new BeanPropertyRowMapper<>(Employee.class));
    }
// by 肉豬
}

執行時會在console印出執行SQL及參數的內容

2020-12-31 14:02:18.612 DEBUG 5448 --- [           main] o.s.j.c.JdbcTemplate                     : Executing prepared SQL query
2020-12-31 14:02:18.613 DEBUG 5448 --- [           main] o.s.j.c.JdbcTemplate                     : Executing prepared SQL statement [select * from EMPLOYEE where id = ?]
2020-12-31 14:02:18.617 TRACE 5448 --- [           main] o.s.j.c.StatementCreatorUtils            : Setting SQL statement parameter value: column index 1, parameter value [1], value class [java.lang.Long], SQL type unknown
2020-12-31 14:02:18.621 DEBUG 5448 --- [           main] o.s.j.c.BeanPropertyRowMapper            : Mapping column 'ID' to property 'id' of type 'java.lang.Long'
2020-12-31 14:02:18.621 DEBUG 5448 --- [           main] o.s.j.c.BeanPropertyRowMapper            : Mapping column 'AGE' to property 'age' of type 'java.lang.Integer'
2020-12-31 14:02:18.621 DEBUG 5448 --- [           main] o.s.j.c.BeanPropertyRowMapper            : Mapping column 'NAME' to property 'name' of type 'java.lang.String'


沒有留言:

張貼留言