mysql decimal(10,2) extract java

Question

I have my database with an decimal(10,2) value.

I need to extract it from the database and add a quantity with java, but I don't get it.

From the database query, the value is 5.50

System.out.println(rsMax.getLong(1));
Long cost = rsMax.getLong(1) + 2;

This prints 5 and cost = 7, it should print 5.50 and cost = 7.50

how should I do it?

a `long` is an integer. You need a floating point type. – Bart Friederichs May 13 '13 at 09:43 — Bart Friederichs, May 13 '13 at 09:43
which mysql version r u using? – KhAn SaAb May 13 '13 at 09:51 — KhAn SaAb, May 13 '13 at 09:51

score 1 · Answer 1 · answered May 13 '13 at 09:49

1

Long is an integer. You need the BigDecimal type.

answered May 13 '13 at 09:49

user207421

Though a bit cumbersome to use (`.add`, `.multiply`), that is definitely the way to go. – Joop Eggen May 13 '13 at 10:02

1 Answers1