Formatting Columns in Hibernate

Question

I have a Money field in Sql server Table and mapping to double in hibernate. how to format as 999,999?(three to three separate)

for example: 45000.0 ---> 45,000

Database and hibernate keep data, not format it. The view part of your application should answer for formatting data selected with hibernate from database. — svaor, Nov 02 '11 at 17:18

score 4 · Accepted Answer · edited May 23 '17 at 12:15

4

I would suggest not to do this at the SQL or hibernate layer. You should handle this in you UI layer. You can use Java's DecimalFormat or see here for an example.

edited May 23 '17 at 12:15

Community

1
1

answered Nov 02 '11 at 17:18

legendofawesomeness

2,901
2
19
32

score 0 · Answer 2 · answered Nov 02 '11 at 17:45

public class MyClass {
    BigDecimal money;
    public static final NumberFormat NUMBER_FORMAT = new DecimalFormat(",###");

    @Column
    public BigDecimal getMoney() {
        return money;
    }

    @Transient
    public String displayMoney(){
       return NUMBER_FORMAT.format(money);
    }

}

Formatting Columns in Hibernate

2 Answers2