Java 去除小数点后多余的0

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);
    }