将列表存入MySQL_字符串属性转变List属性存入数据库

项目中有系统IP字段，现将string转List存入数据库，每个功能块持久层实现方法不一样(分为jpa和mp)

jpa：

@Convert(converter = JpaConverterListJson.class)private ListhostIp;public class JpaConverterListJson implements AttributeConverter{

@OverridepublicString convertToDatabaseColumn(Object o) {returnJSON.toJSONString(o);

}

@OverridepublicObject convertToEntityAttribute(String s) {//兼容历史数据

if (!JSONUtil.isJson(s)) {return newJSONArray(Arrays.asList(s));

}returnJSON.parseArray(s);

}

ps:貌似@Lob也可以直接保存，没试过

mp:

@TableField(typeHandler = ArrayTypeHandler.class)private ListhostIp;

@MappedTypes(List.class)

@MappedJdbcTypes(JdbcType.VARCHAR)

public class ArrayTypeHandler extends BaseTypeHandler {

@Override

public void setNonNullParameter(PreparedStatement preparedStatement, int i,