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
– svaor, Commented Nov 2, 2011 at 17:18

Community · Accepted Answer · 2017-05-23 12:15:00Z

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, 2017 at 12:15

CommunityBot

11 silver badge

answered Nov 2, 2011 at 17:18

legendofawesomeness

2,9212 gold badges21 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zmf · Accepted Answer · 2011-11-02 17:45:14Z

0

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);
    }

}

answered Nov 2, 2011 at 17:45

zmf

9,3632 gold badges29 silver badges29 bronze badges

Collectives™ on Stack Overflow

Formatting Columns in Hibernate

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related