1、通过sql查询时去除
select price from test_table
SELECT 0 + CAST(price AS CHAR) AS price FROM test_table
2、通过BigDecimal去除
public static void main(String[] args) {
BigDecimal bigDecimal = new BigDecimal("10.2000");
BigDecimal trailingZeros = bigDecimal.stripTrailingZeros();
System.out.println("去除后结果======="+trailingZeros);
}