Joda-Money使用

Joda-Money提供了一个存储金额的类库

通常的做法就是数据库设计成bigint类型，单位是分，入库扩大 100 倍 ，出库缩小 100 倍

schema.sql 

drop table goods if exists;

create table goods (
  id bigint auto_increment,
  name varchar(255),
  price bigint,
  create_time timestamp,
  update_time timestamp,
  primary key (id)
);

insert into goods (name, price, create_time, update_time) values ('bag', 2000, now(), now());
insert into goods (name, price, create_time, update_time) values ('bottole', 2500, now(), now());

依赖

<dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
     <groupId>com.h2database</groupId>
     <artifactId>h2</artifactId>
     <scope>runtime</scope>
</dependency>
<dependency>
     <groupId>org.projectlombok</groupId>
     <artifactId>lombok</artifactId>
</dependency>
<dependency>
     <groupId>com.alibaba</groupId>
     <artifactId>fastjson</artifactId>
     <version>1.2.47</version>
</dependency>
<dependency>
     <groupId>org.joda</groupId>
     <artifactId>joda-money</artifactId>
     <version>1.0.1</version>
</dependency>
<dependency>
     <groupId>org.jadira.usertype</groupId>
     <artifactId>usertype.core</artifactId>
     <version>6.0.1.GA</version>
</dependency>

注：

　　配置了 joda-money和usertype.core

配置

server.port=8080
spring.application.name=abc
spring.jpa.database=h2
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=none
spring.jpa.open-in-view=false
spring.datasource.url=jdbc:h2:./data/test
spring.datasource.username=sa
spring.datasource.password=123456
spring.datasource.driverClassName=org.h2.Driver
spring.h2.console.path=/h2-console
spring.h2.console.enabled=true

持久化类

package com.example.demo.model;
import lombok.*;
import org.hibernate.annotations.CreationTimestamp;
import org.hibernate.annotations.UpdateTimestamp;
import org.joda.money.Money;
import org.hibernate.annotations.Type;
import javax.persistence.*;
import java.util.Date;

@Entity
@Table(name = "goods")
@Data
@Builder
@ToString(callSuper = true)
@NoArgsConstructor
@AllArgsConstructor
public class Goods {
    @Id
    @GeneratedValue(strategy= GenerationType.AUTO)
    private Long id;
    private String name;
    @Type(type = "org.jadira.usertype.moneyandcurrency.joda.PersistentMoneyMinorAmount",
            parameters = {@org.hibernate.annotations.Parameter(name = "currencyCode", value = "CNY")})
    private Money price;
    @Column(updatable = false)
    @CreationTimestamp
    private Date createTime;
    @UpdateTimestamp
    private Date updateTime;
}

数据访问层接口

package com.example.demo.repository;

import com.example.demo.model.Goods;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface GoodsRepository extends JpaRepository<Goods, Integer> {

}

控制器类

package com.example.demo.controller;

import com.example.demo.core.Result;
import com.example.demo.repository.GoodsRepository;
import com.example.demo.repository.UsersRepository;
import com.example.demo.model.Goods;
import com.example.demo.model.Users;
import lombok.extern.slf4j.Slf4j;
import org.joda.money.CurrencyUnit;
import org.joda.money.Money;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;
@Slf4j
@RestController
public class DemoController {

    @Autowired
    GoodsRepository goodsRepository;

    @RequestMapping("/goods/add")
    public Result goodsAdd(String name,double price) {
        Goods good = Goods.builder().name(name).price(Money.of(CurrencyUnit.of("CNY"), price)).build();
        log.info("Goods {}",good);
        goodsRepository.save(good);
        return Result.success(200, good);
    }

    @RequestMapping("/goods/find")
    public Result goodsFind() {
        List<Goods> goods = goodsRepository.findAll();
        log.info("Goods {}",goods);
        return Result.success(200, goods);
    }

}

启动项目

postman执行 http://127.0.0.1:8080/goods/add?name=aaa&price=11

结果

{
    "code": 200,
    "message": null,
    "data": {
        "id": 34,
        "name": "aaa",
        "price": {
            "negative": false,
            "zero": false,
            "currencyUnit": {
                "code": "CNY",
                "numericCode": 156,
                "decimalPlaces": 2,
                "symbol": "￥",
                "numeric3Code": "156",
                "countryCodes": [
                    "CN"
                ],
                "pseudoCurrency": false
            },
            "amount": 11.00,
            "amountMajor": 11,
            "amountMinor": 1100,
            "minorPart": 0,
            "positiveOrZero": true,
            "negativeOrZero": false,
            "positive": true,
            "scale": 2,
            "amountMajorLong": 11,
            "amountMajorInt": 11,
            "amountMinorLong": 1100,
            "amountMinorInt": 1100
        },
        "createTime": "2020-03-27T03:24:23.432+0000",
        "updateTime": "2020-03-27T03:24:23.432+0000"
    }
}

H2数据的存储内容为