decimal转为string sql_数据库decimal类型的怎么和String类型的比大小？

都转换成 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 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');

}

}