Multiplying bigdecimal number selected from database

Question

I select a number column in database. For example:

                BigDecimal total_price_bg;
                BigDecimal unit_price_bg;

                if (results.next()) {
                    unit_price_bg = results.getBigDecimal("UNIT_PRICE");
                    total_price_bg = unit_price_bg.multiply(unit_price_bg); // I have trouble here..
                    System.out.println(total_price_bg);
                }    

First row could contain 10.25, second row 7.03 and third row could contain 371.09. How do I multiply big decimal many times with same variable?? Is it actually possible? Thanks in advance.

Answer 1

Do you mean like this?

            BigDecimal total_price_bg = BigDecimal.ONE;

            while (results.next()) {
                BigDecimal unit_price_bg = results.getBigDecimal("UNIT_PRICE");
                total_price_bg = total_price_bg.multiply(unit_price_bg.pow(2)); 
            }    
            System.out.println(total_price_bg);

This continually compounds the value of UNIT_PRICE squared into a variable total_price_bg. I squared the value of unit_price_bg because I noticed you were multiplying it times itself, but maybe you meant:

            BigDecimal total_price_bg = BigDecimal.ONE;

            while (results.next()) {
                BigDecimal unit_price_bg = results.getBigDecimal("UNIT_PRICE");
                total_price_bg = total_price_bg.multiply(unit_price_bg); 
            }    
            System.out.println(total_price_bg);