Java中int转Double再转换成百分数并应用在求同比昨日增长率

缺乏、安全感 2023-10-18 18:21 7阅读 0赞

## 场景 ##

求数据库中某记录的同比昨日增长率。

使用MyBatisPlus的selectCount方法返回的是int类型。

最后需要再转换成百分数表示。

## 实现 ##

//查询昨日物流数
            SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
            Date createTimeDate = simpleDateFormat.parse(createTime);
            createTimeDate = yesterday(createTimeDate);
            String formateDate = simpleDateFormat.format(createTimeDate);
            QueryWrapper<BusLogisticsOrder> BusLogisticsOrderQueryWrapper1 =new QueryWrapper<BusLogisticsOrder>();
            BusLogisticsOrderQueryWrapper1.eq("deleted_flag","0");
            BusLogisticsOrderQueryWrapper1.apply("CONVERT(varchar(100), gmt_creat, 23)= '"+formateDate+"'");
            Integer sumCountYesterDay = busLogisticsOrderMapper.selectCount(BusLogisticsOrderQueryWrapper1);
            String sumPercent="";
            if(sumCountYesterDay==0){
                if(sumCount==0){
                    sumPercent="+0%";
                }else{
                    sumPercent="+100%";
                }
            }else{
                Double sumPercentNum=0.0;
                sumPercentNum= Double.valueOf(Double.valueOf((sumCount-sumCountYesterDay))/Double.valueOf(sumCountYesterDay));
                DecimalFormat df = new DecimalFormat("0.00%");
                if(sumCount-sumCountYesterDay<0){
                    sumPercent = df.format(sumPercentNum);
                }else{
                    sumPercent = "+"+df.format(sumPercentNum);
                }

打断点查看效果

![Image 1][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

[Image 1]: 
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190509135443448.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70