Question

我的春季申请是针对MySql数据库的。我有一个销售表:

+-------------------+------------------------------+------+-----+---------+-------+
| Field             | Type                         | Null | Key | Default | Extra |
+-------------------+------------------------------+------+-----+---------+-------+
| Price             | decimal(19,4)                | NO   |     | NULL    |       |
| ItemId            | int(10) unsigned             | NO   |     | NULL    |       |
+-------------------+------------------------------+------+-----+---------+-------+

我的春季班子有:

long price = getSimpleJdbcTemplate().queryForLong("SELECT price FROM sales WHERE itemID = :itemID", params);
logger.info("price: " + price + ");

然而,即使直接在数据库收益上查询0.8500<>/strong>,价格仍为1。我如何避免从数据库中的精度到我代码中长时期的这种精确性损失?

Answer 1

<代码>long不支持小数位位位,因为它是一种分类。您是否尝试了queryForObject(sql, BigDecimal.class, params)?

友情链接