找不对自定义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、配置包扫描

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;
}

4、问题原因:实体使用的类型和typeHandler中定义的不一致,类型修改一致问题解决
  实体使用:             

 

   typeHandler定义:

 

posted on 2022-03-18 11:57  滚动的蛋  阅读(282)  评论(0编辑  收藏  举报

导航