mybatis 3.4.0不支持LocalDateTime类型的解决方法（No typehandler found for property time）

本文链接：https://blog.youkuaiyun.com/weixin_43833540/article/details/138496600

文章介绍了如何在MyBatis中处理LocalDateTime类型的参数和结果，通过自定义LocalDateTimeTypeHandler并配置到mybatis-config.xml文件中，解决了`Notypehandlerfoundforpropertytime`的报错。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题描述

报错：No typehandler found for property time
（注：time是LocalDateTime类型的字段）

LocalDateTimeTypeHandler

public class LocalDateTimeTypeHandler implements TypeHandler<LocalDateTime> {

    private DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");

    @Override
    public void setParameter(PreparedStatement ps, int i, LocalDateTime parameter, JdbcType jdbcType) throws SQLException {
        if (parameter != null) {
            ps.setString(i, formatter.format(parameter));
        } else {
            ps.setTimestamp(i, null);
        }
    }

    @Override
    public LocalDateTime getResult(ResultSet rs, String columnName) throws SQLException {
        String dateStr = rs.getString(columnName);
        return dateStr == null ? null : LocalDateTime.parse(dateStr, formatter);
    }

    @Override
    public LocalDateTime getResult(ResultSet rs, int columnIndex) throws SQLException {
        String dateStr = rs.getString(columnIndex);
        return dateStr == null ? null : LocalDateTime.parse(dateStr, formatter);
    }

    @Override
    public LocalDateTime getResult(CallableStatement cs, int columnIndex) throws SQLException {
        String dateStr = cs.getString(columnIndex);
        return dateStr == null ? null : LocalDateTime.parse(dateStr, formatter);
    }
}

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>

    </settings>
    <typeHandlers>
        <typeHandler handler="com.vanwardsmart.mybatis.LocalDateTimeTypeHandler" javaType="java.time.LocalDateTime"/>
    </typeHandlers>
</configuration>