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個怎么比大小
1 回答
子衿沉夜
TA貢獻(xiàn)1828條經(jīng)驗 獲得超3個贊
都轉(zhuǎn)換成 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 WHERE s.pubid=c.pubid AND s.status=3";
List<Map> l = super.findListbySqlReturnMap(sql);
for(int i = 0; i < l.size(); i++){
BigDecimal sum= new BigDecimal(list.get(i).get("sum(c.couponfee/100)"));
BigDecimal max = new BigDecimal(l.get(i).get("max"));
BigDecimal min = new BigDecimal(l.get(i).get("min"));
if(sum.compareTo(min) > 0 && sum.compareTo(max) < 0){
e.put("content",'2');
}
}
添加回答
舉報
0/150
提交
取消