@Convert(converter = JpaConverterListJson.class)

    private List<String> hostIp;

public class JpaConverterListJson implements AttributeConverter<Object, String> {

    @Override

    public String convertToDatabaseColumn(Object o) {

        return JSON.toJSONString(o);

    }

    @Override

    public Object convertToEntityAttribute(String s) {

        //兼容历史数据

        if (!JSONUtil.isJson(s)) {

            return new JSONArray(Arrays.asList(s));

        }

        return JSON.parseArray(s);

    }

@TableField(typeHandler = ArrayTypeHandler.class)

private List<String> hostIp;

@MappedTypes(List.class)
@MappedJdbcTypes(JdbcType.VARCHAR)
public class ArrayTypeHandler extends BaseTypeHandler<List> {

    @Override
    public void setNonNullParameter(PreparedStatement preparedStatement, int i, List list, JdbcType jdbcType) throws SQLException {
        preparedStatement.setString(i, JSON.toJSONString(list));
    }

    @Override
    public List getNullableResult(ResultSet resultSet, String s) throws SQLException {
        //兼容历史数据
        if (!JSONUtil.isJson(resultSet.getString(s))) {
            return new JSONArray(Arrays.asList(resultSet.getString(s)));
        }
        return JSON.parseArray(resultSet.getString(s));

    }

    @Override
    public List getNullableResult(ResultSet resultSet, int i) throws SQLException {
        JSONArray jsonArray = JSONArray.parseArray(resultSet.getString(i));
        return jsonArray;
    }

    @Override
    public List getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
        JSONArray jsonArray = JSONArray.parseArray(callableStatement.getString(i));
        return jsonArray;
    }

//单这样查询获取不到，mp查询跟增改使用的ResultMap是不同的 //注解的typeHandler只生效于insert和update,要生效select必须@TableName(autoResultMap=true)
//但在自定义查询中添加了autoResultMap也没有用，还要在配置里加上map，查询结果指向它

<resultMap id="BaseResultMap" type="com.jk.cmdb.setting.entity.CmdbPc">
    <result column="host_ip" property="hostIp"
            typeHandler="com.jk.moinc.framework.ArrayTypeHandler"/>
</resultMap>