mybatis查询json数据映射List<Object>

mybatis查询json数据映射Java  List<Object> list

 

数据库存入 json数据类型 ：  ["aaaaa","bbbbb","ccccc","dddddd"]   

配置 Handler

import com.alibaba.fastjson.JSON;
import com.baomidou.mybatisplus.extension.handlers.FastjsonTypeHandler;

/**
 * @author wangjun
 */
public class ConfigHandler extends FastjsonTypeHandler {

    private final Class<? extends Object> type;

    public AlertUpConfigHandler(Class<?> type) {
        super(type);
        this.type = type;
    }

    @Override
    protected Object parse(String json) {
        return JSON.parseArray(json, this.type);
    }

    @Override
    protected String toJson(Object obj) {
        return super.toJson(obj);
    }
}

mapper.xml

 <resultMap id="map" type="XXXX">
    <id column="id" property="id"  />
    <result column="type" property="type" javaType="string"
                typeHandler="xxx.ConfigHandler"/>
    <result column="name" property="name"  />
 </resultMap>

java 类接收 

.....

private List<String> type；

.....