java:
String sqlInFac="SELECT SUM(t1.actual_pay) income FROM t_money_income_manage t1 LEFT JOIN t_factory_rm t2 on t1.contract_no=t2.contract_number WHERE YEAR(t1.pay_date)= YEAR(NOW()) AND t1.model_state='NORMAL' and t2.model_state='NORMAL' AND t1.income_type='1' ";
List<Object> linFac=workshopService.findBySql(sqlInFac);
if(linFac!=null){
Map<Object,Object> map=(Map)linFac.get(0);
if(map.get("income")!=null){
Float f=Float.parseFloat(map.get("income").toString());
Float a=f/10000;
System.out.println("abcd"+a);
mav.addObject("cfczsr",a);
}else{
mav.addObject("cfczsr",0);
}
}
jstl:
<fmt:formatNumber value="${rem.lease/10000}" maxIntegerDigits="14" pattern="#0.##"/><span>元</span>