Question

如何在Java程序的sql中去掉小数点后多余的0

读取数据的语句如下：
public String[] monthCheckOut(String num) { String values[]={"--","--","--","--","--"}; String sqls[]={"select count(*) from tb_order_form where num like '"+num+"%'","select sum(money) from tb_order_form where num like '"+num+"%'","select avg(money) from tb_order_form where num like '"+num+"%'", "select max(money) from tb_order_form where num like '" + num + "%'", "select min(money) from tb_order_form where num like '" + num + "%'"}; for(int i=0;i<sqls.length;i++){ Object value = super.selectOnlyValue(sqls[i]); if(value!=null){ String v = value.toString(); if(!v.equals("0")) values[i] = v;// TODO Auto-generated method stub } } return values; }
其中count,sum,max,min读取出来的数都是不带小数点的，只有avg带四个小数点，我想只留两个，网上说用select cast(round(1.00/3,2) as decimal(18,2))，但是应该插到哪呢？

Answer 1

在你的代码中找：select avg(money)
替换为：select cast(round(avg(money),2) as decimal(18,2))