Error attempting to get column time from result set. Cause: java.sql.SQLFe 错误

淡淡的烟草味﹌ 2023-02-20 07:23 1阅读 0赞

## 错误原因: ##

错误信息: `Error attempting to get column 'time' from result set. Cause: java.sql.SQLFe`  
错误原因: 日期无法正常序列化与反序列化

当前采用技术  
1、数据库字段为 datetime 类型  
2、使用了mybatis-plus 框架，当前是3.3.0  
3、实体类使用了 LocalDateTime，  
![在这里插入图片描述][20200624172203831.png]  
![在这里插入图片描述][20200624172050701.png]

## 处理办法一、添加序列化处理的jar包 ##

<dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-typehandlers-jsr310</artifactId>
                <version>1.0.1</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.datatype</groupId>
                <artifactId>jackson-datatype-jsr310</artifactId>
                <version>2.9.2</version>
            </dependency>

## 处理办法二、配置日期序列化器与反序列化器 ##

可以使返回的数据格式为: `yyyy-MM-dd HH:mm:ss`

#### LocalDateTimeConvertConfig ####

package com.ws.ldy.config;
    import com.fasterxml.jackson.datatype.jsr310.ser.LocalDateTimeSerializer;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.boot.autoconfigure.jackson.Jackson2ObjectMapperBuilderCustomizer;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    import java.time.LocalDateTime;
    import java.time.format.DateTimeFormatter;
    
    /**
     * LocalDateTime 日期适配器
     *
     * @author MoCha
     * @date 2019/11/30
     */
    @Configuration
    public class LocalDateTimeConvertConfig {
        @Value("${spring.jackson.date-format:yyyy-MM-dd HH:mm:ss}")
        private String pattern;
    
        /**
         * 配置LocalDateTime 序列化器与反序列化器
         * <p>
         * 说明：
         * 1. 下面配置的new LocalDateTimeDeserializer()为我们定制的LocalDateTime反序列化器
         */
        @Bean
        public Jackson2ObjectMapperBuilderCustomizer jackson2ObjectMapperBuilderCustomizer() {
            return builder -> {
                builder.serializerByType(LocalDateTime.class, localDateTimeSerializer());
                builder.deserializerByType(LocalDateTime.class, new LocalDateTimeDeserializer());
            };
        }
    
        /**
         * LocalDateTime 序列化器
         */
        @Bean
        public LocalDateTimeSerializer localDateTimeSerializer() {
            return new LocalDateTimeSerializer(DateTimeFormatter.ofPattern(pattern));
        }
    }

#### 2、LocalDateTimeDeserializer ####

package com.ws.ldy.config;
    import cn.hutool.core.date.DateTime;
    import cn.hutool.core.date.DateUtil;
    import com.fasterxml.jackson.core.JsonParser;
    import com.fasterxml.jackson.databind.DeserializationContext;
    import com.fasterxml.jackson.databind.JsonDeserializer;
    
    import java.io.IOException;
    import java.time.Instant;
    import java.time.LocalDateTime;
    import java.time.ZoneId;
    import java.util.Date;
    
    /**
     * LocalDateTime 反序列化器
     * <p>
     * 说明：
     * 1. 借用hutool相关工具类
     *
     * @author MoCha
     * @date 2019/11/30
     */
    public class LocalDateTimeDeserializer extends JsonDeserializer<LocalDateTime> {
        @Override
        public LocalDateTime deserialize(JsonParser parser, DeserializationContext context) throws IOException {
            String dateStr = parser.getText();
            DateTime dateTime;
            try {
                dateTime = DateUtil.parse(dateStr);
            } catch (Exception e) {
                dateTime = DateUtil.parseDateTime(dateStr.replaceAll("T", " "));
            }
            Date date = dateTime.toJdkDate();
            Instant instant = date.toInstant();
            ZoneId zoneId = ZoneId.systemDefault();
            return instant.atZone(zoneId).toLocalDateTime();
        }
    
        @Override
        public Class<?> handledType() {
            // 关键
            return LocalDateTime.class;
        }
    }

[20200624172203831.png]: https://img-blog.csdnimg.cn/20200624172203831.png
[20200624172050701.png]: https://img-blog.csdnimg.cn/20200624172050701.png

Error attempting to get column time from result set. Cause: java.sql.SQLFe 错误

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关使用Druid数据库连接池整合MyBatis Plus时，出现Error attempting to get column 'startTime' from result set. 类似错误

相关 SpringBoot报错Error attempting to get column ‘create_time’ from result set. Cause: java.sql.SQLFeature

相关 MybatisPlus UncategorizedSQLException: Error attempting to get column ‘xxx‘ from result set问题解决

相关 Error attempting to get column ‘xxx‘ from result set. Cause: java.sql.SQLDataException错误的解决方法

相关 Error attempting to get column from result set

相关 LocalDateTime 字段报错： Error attempting to get column ‘reg_time‘ from result set

相关 Error attempting to get column time from result set. Cause: java.sql.SQLFe 错误

相关 SpringCloud入门到精通- Error attempting to get column ‘create_time‘ from result set. Cause: java.sql.SQL

相关 MyBatis-Plus Error attempting to get column ‘x‘ from result set.Cannot convert x ‘x‘ to x value问题解决

相关 Error attempting to get column 'USER_ID' from result set.: Cause: java.sql.SQLException: 无法转换为内部表示