数据库插入数据:java.math.BigDecimal cannot be cast to java.lang.Float

解决办法

数据库中decimal的字段,java类型写float

public int insert(int count,float subtotal,int oid,int bid) throws SQLException {
        Connection conn = DBCPUtil.getConnection();
        QueryRunner qr = new QueryRunner();

        String sql="insert into tb_cart(count, subtotal, oid, bid) VALUE (?,?,?,?)";
        Object[]params={count,subtotal,oid,bid};

        int update = qr.update(conn, sql, params);
        conn.commit();
        return update;


    }
}

将返回值为object转为float

Object price = bookInfo.get("price");

Float.parseFloat(price.toString())