找不对自定义typeHandler:java.lang.IllegalStateException: No typehandler found for mapping ...

1、自定义typeHandler

package com.apollo.cloud.common.core.mybatis.typehandler;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import cn.hutool.json.JSONObject;
import cn.hutool.json.JSONUtil;
import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.MappedJdbcTypes;
import org.apache.ibatis.type.MappedTypes;
 
@MappedTypes({JSONObject.class})
@MappedJdbcTypes({JdbcType.VARCHAR})
public class JsonTypeHandler extends BaseTypeHandler<JSONObject> {
 
    @Override
    public void setNonNullParameter(PreparedStatement ps, int i, JSONObject parameter,JdbcType jdbcType) throws SQLException {
        ps.setString(i, JSONUtil.toJsonStr(parameter));
    }
 
    @Override
    public JSONObject getNullableResult(ResultSet rs, String columnName)throws SQLException {
        return JSONUtil.parseObj(rs.getString(columnName)).toBean(JSONObject.class);
    }
 
    @Override
    public JSONObject getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
        return JSONUtil.parseObj(rs.getString(columnIndex)).toBean(JSONObject.class);
    }
 
    @Override
    public JSONObject getNullableResult(CallableStatement cs, int columnIndex)throws SQLException {
        return JSONUtil.parseObj(cs.getString(columnIndex)).toBean(JSONObject.class);
    }
}

2、配置包扫描

1 2	`mybatis-plus:` `type-handlers-package: com.apollo.cloud.common.core.mybatis.typehandler`

3、实体使用

import cn.hutool.json.JSONObject;
 
@Data
@TableName(value = "order")
@EqualsAndHashCode(callSuper = true)
@ApiModel
public class OrderInfo {
    @TableField(typeHandler = JsonTypeHandler.class, jdbcType= JdbcType.VARCHAR)
    private JSONObject payResponse;
}