java - 如何在Spring中注册java.sql.Timestamp的全局格式化程序？

Question

我通过 @RestController Servlet 公开以下 Map:

List<Map<String, Object>> results = jdbcTemplate.queryForList(..);

然后，该映射包含一个 java.sql.Timestamp 对象。

问题:如何设置 Spring 与 jaxb/jackson 为 Timestamp 生成的输出格式？我想全局设置它。我不想查看 map 来手动检测和重新格式化值。

以下方法无效:

@Configuration
public class DateConfig extends WebMvcConfigurerAdapter {
    @Override
    public void addFormatters(FormatterRegistry registry) {
        super.addFormatters(registry);
        registry.addFormatterForFieldType(java.sql.Timestamp.class, new Formatter<Timestamp>() {
            @Override
            public String print(Timestamp object, Locale locale) {
                return "my custom format";
            }
        });
    }
}

格式化程序已注册，但在序列化为 json 期间从未调用!

当前结果始终类似于:2017-07-10T11:06:02.000+0000。但我想在任何地方都获得 2017-07-10 11:06:02。

Answer 1

By default, date and time fields that are not annotated with @DateTimeFormat are converted from strings using the DateFormat.SHORT style. If you prefer, you can change this by defining your own global format.

示例如下:

@Configuration
public class AppConfig {

    @Bean
    public FormattingConversionService conversionService() {

        // Use the DefaultFormattingConversionService but do not register defaults
        DefaultFormattingConversionService conversionService = new DefaultFormattingConversionService(false);

        // Ensure @NumberFormat is still supported
        conversionService.addFormatterForFieldAnnotation(new NumberFormatAnnotationFormatterFactory());

        // Register date conversion with a specific global format
        DateFormatterRegistrar registrar = new DateFormatterRegistrar();
        registrar.setFormatter(new YourTimeStampFormatter());
        registrar.registerFormatters(conversionService);

        return conversionService;
    }
}

参见here