Spring JDBC BeanPropertyRowMapper yes no ('Y','N') 到布尔 bean 属性

Spring JDBC中使用BeanPropertyRowMapper将数据库字段映射为布尔属性

java
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import java.util.List;
public class UserDAO {
    private JdbcTemplate jdbcTemplate;
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }
    public List getUsers() {
        String sql = "SELECT id, username, is_active FROM users";
        return jdbcTemplate.query(sql, BeanPropertyRowMapper.newInstance(User.class));
    }
}

java
import org.springframework.core.convert.converter.Converter;
public class StringToBooleanConverter implements Converter {
    @Override
    public Boolean convert(String source) {
        return "Y".equalsIgnoreCase(source);
    }
}

java
import org.springframework.context.annotation.Configuration;
import org.springframework.format.FormatterRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
@Configuration
public class WebConfig implements WebMvcConfigurer {
    @Override
    public void addFormatters(FormatterRegistry registry) {
        registry.addConverter(new StringToBooleanConverter());
    }
}