【Java航母】数据库中一个字段存储多个字段的转换

最新推荐文章于 2022-06-16 17:34:34 发布

lucky__cc

最新推荐文章于 2022-06-16 17:34:34 发布

阅读量831

点赞数

本文链接：https://blog.csdn.net/qq1437722579/article/details/112376182

版权

mySQL中设置一个extra字段，为后期新增字段迭代做准备
存储一个JSON体,eg:

{"referencePriceRatio":"1","supplyPriceRatio":"1","supplyFloatPrice":"0"}

我们不用修改SQL,只需在出参和转换类中这样转换即可：
出参：

    @ApiModelProperty("Swagger文档出参备注")
    private String referencePriceRatio ;

    @ApiModelProperty("Swagger文档出参备注")
    private String supplyPriceRatio;

    @ApiModelProperty("Swagger文档出参备注")
    private String supplyFloatPrice;

添加/修改时：

        //额外字段转换
        Map<String,String> extraMap = Maps.newLinkedHashMap();
        if(storeVo.getReferencePriceRatio() != null) {
            extraMap.put("referencePriceRatio", storeVo.getReferencePriceRatio());
        }
        if(storeVo.getSupplyPriceRatio() != null) {
            extraMap.put("supplyPriceRatio", storeVo.getSupplyPriceRatio());
        }
        if(storeVo.getSupplyFloatPrice() != null) {
            extraMap.put("supplyFloatPrice", storeVo.getSupplyFloatPrice());
        }
        store.setExtra(JSON.toJSONString(extraMap));

查询时：

      try {
            Map<String,String> extraMap = JSON.parseObject(store.getExtra(),new TypeReference<Map<String,String> >(){});
            if(extraMap == null){
                return storeVo;
            }
            storeVo.setReferencePriceRatio(extraMap.get("referencePriceRatio"));
            storeVo.setSupplyPriceRatio(extraMap.get("supplyPriceRatio"));
            storeVo.setSupplyFloatPrice(extraMap.get("supplyFloatPrice"));
        }catch (Exception e){
            log.error("convertStoreVo store:{}",store,e);
        }