Mybaties @Select float 丢失精度

Spring boot 整合 mybaties时，会出现一个奇怪的现象，假如
数据库里面有float型数据，比如 5.245，使用 @Select注解查询出来显示的是 5.0, 精度哪去了？

  @Select("SELECT heat, cost  FROM dm_warehouse_cost WHERE date=#{date} AND id=#{id}")
  WarehouseCostBean getHeatAndCost(@Param("date") String date, @Param("id") int id);

public class WarehouseCostBean {

  private int heat;
  private float totalCost;

  public WarehouseCostBean(int heat, float totalCost) {
    this.heat = heat;
    this.totalCost = totalCost;
  }

...
}

经过一番折腾，发现在float型的数据处，加上 ROUND 函数即可，还可以自己控制小数点后位数。但建议 float 不要存储高精度的数据，比如股券类，而应使用 numeric 或者 decimal

  @Select("SELECT heat, ROUND(cost,3)  FROM dm_warehouse_cost WHERE date=#{date} AND id=#{id}")
  WarehouseCostBean getHeatAndCost(@Param("date") String date, @Param("id") int id);

参考文献
https://stackoverflow.com/questions/13620850/select-a-float-with-given-precision
https://iqbon.iteye.com/blog/1769707