数据库decimal类型的怎么和String类型的比大小？

Question

String sql ="SELECT e.max,e.min,e.content,e.logo, sum(c.couponfee/100) FROM couponpublish c,couponpool s,hh_coupon_equivalent e  WHERE s.pubid=c.pubid AND s.status=3";

            List<Map> l = super.findListbySqlReturnMap(sql);

            for(int i=0;i<l.size();i++){

            double sum=(Double)list.get(i).get("sum(c.couponfee/100)");

            double max =(Double)l.get(i).get("max");

            double min = (Double)l.get(i).get("min");

                if(sum>min&&sum<max){

                    e.put("content",'2');

                }

            }

            

            max 和min是decimal类型，sum是string类型，他们3个怎么比大小

Answer 1

都转换成 BigDecimal 来比较大小啊，String sql ="SELECT e.max,e.min,e.content,e.logo, sum(c.couponfee/100) FROM couponpublish c,couponpool s,hh_coupon_equivalent e&nbsp; WHERE s.pubid=c.pubid AND s.status=3";List<Map> l = super.findListbySqlReturnMap(sql);for(int i = 0; i < l.size(); i++){&nbsp; &nbsp; BigDecimal sum= new BigDecimal(list.get(i).get("sum(c.couponfee/100)"));&nbsp; &nbsp; BigDecimal max = new BigDecimal(l.get(i).get("max"));&nbsp; &nbsp; BigDecimal min = new BigDecimal(l.get(i).get("min"));&nbsp; &nbsp; if(sum.compareTo(min) > 0 && sum.compareTo(max) < 0){&nbsp; &nbsp; &nbsp; &nbsp; e.put("content",'2');&nbsp; &nbsp; }}