Hibernate获取列的数据缓存

Question

我写了一个从数据库获取数据的函数，它获取了大部分数据，但仍然缺少一些列，即使我在实体中定义了它。以下是我调试时的结果

data is null

这是我的实体

@Entity
@Table(name="BANK_FEE_AND_LIMIT")
@NamedQuery(name="BankFeeAndLimit.findAll", query="SELECT b FROM 
BankFeeAndLimit b")
public class BankFeeAndLimit implements Serializable {
private static final long serialVersionUID = 1L;

@Id
private long id;

@Column(name="BANK_ID")
private Long bankId;

@Column(name="CASH_IN_FEE")
private Double cashInFee;

@Column(name="CASH_IN_FEE_AT_COUNTER")
private Double cashInFeeAtCounter;

@Column(name="CASH_IN_FEE_FROM_IB")
private Double cashInFeeFromIb;

@Column(name="CASH_IN_FEE_WITHOUT_LINK")
private Double cashInFeeWithoutLink;

@Column(name="CASH_OUT_FEE")
private Double cashOutFee;

@Column(name="CASH_OUT_FEE_WITHOUT_LINK")
private Double cashOutFeeWithoutLink;

@Temporal(TemporalType.TIMESTAMP)
@Column(name="CREATE_DATE")
private Date createDate;

@Column(name="FEE_TYPE")
private Long feeType;

@Temporal(TemporalType.TIMESTAMP)
@Column(name="LAST_UPDATE")
private Date lastUpdate;

@Column(name="MAX_CASH_IN_PER_DAY")
private Long maxCashInPerDay;

@Column(name="MAX_CASH_IN_PER_TRANS")
private Long maxCashInPerTrans;

@Column(name="MAX_CASH_OUT_PER_DAY")
private Long maxCashOutPerDay;

@Column(name="MAX_CASH_OUT_PER_TRANS")
private Long maxCashOutPerTrans;

@Column(name="MAX_NUMBER_CASH_IN")
private Long maxNumberCashIn;

@Column(name="MAX_NUMBER_CASH_OUT")
private Long maxNumberCashOut;

@Column(name="MIN_CASH_IN_FEE_AT_COUNTER")
private Long minCashInFeeAtCounter;

@Column(name="MIN_CASH_IN_FEE_FROM_IB")
private Long minCashInFeeFromIb;

@Column(name="MIN_CASH_IN_FEE_VALUE")
private Long minCashInFeeValue;

@Column(name="MIN_CASH_IN_FEE_WITHOUT_LINK")
private Long minCashInFeeWithoutLink;

@Column(name="MIN_CASH_IN_PER_TRANS")
private Long minCashInPerTrans;

@Column(name="MIN_CASH_OUT_FEE_VALUE")
private Long minCashOutFeeValue;

@Column(name="MIN_CASH_OUT_FEE_WITHOUT_LINK")
private Long minCashOutFeeWithoutLink;

@Column(name="MIN_CASH_OUT_PER_TRANS")
private Long minCashOutPerTrans;

@Column(name="STATUS")
private Long status;

@Column(name="WALLET_LEVEL")
private Long walletLevel;

@Column(name="WALLET_TYPE")
private Long walletType;

@Column(name="NUMBER_IBFT_FREE_BY_MONTH")
private Long numberIbftFreeByMonth;

@Column(name="NUMBER_CASH_OUT_FREE_BY_MONTH")
private Long numberCashOutFreeByMonth;

@Column(name="MAX_NUMBER_TRANSFER_IBFT")
private Long maxNumberTransferIbft;

@Column(name="MIN_IBFT_FEE_VALUE")
private Long minIbftFeeValue;

@Column(name="MIN_CASH_IN_FEE_FOR_PREPAID")
private Long minCashInFeeForPrepaid;

@Column(name="EXTRA_TRANSFER_IBFT_FEE")
private Long extraTransferIbftFee;

@Column(name="TRANSFER_IBFT_FEE")
private Long transferIbftFee;

@Column(name="CASH_IN_FEE_FOR_PREPAID")
private Long cashInFeeForPrepaid;

@Column(name="MIN_TRANSFER_IBFT_PER_TRANS")
private Long minTransferIbftPerTrans;

@Column(name="MAX_TRANSFER_IBFT_PER_TRANS")
private Long maxTransferIbftPerTrans;

@Column(name="MAX_CASH_IN_PREPAID_PER_TRANS")
private Long maxCashInPrepaidPerTrans;

@Column(name="MAX_TRANSFER_IBFT_PER_DAY")
private Long maxTransferIbftPerDay;

@Column(name="MAX_CASH_IN_PREPAID_PER_DAY")
private Long maxCashInPrepaidPerDay;

@Column(name="MAX_NUMBER_CASH_IN_PREPAID")
private Double test;

public Double getTest() {
    return test;
}

public void setTest(Double test) {
    this.test = test;
}

null字段是映射到数据库中的MAX_NUMBER_CASH_IN_PREPAID列的测试字段。这是数据库中的数据

data in database

其他字段仍然可以正常获取，只有这个字段不能获取。

Answer 1

我认为您需要为列生成sitter和getter，然后使用构造函数从java类或控制器( spring、servlet ..)

Answer 2

地图是有尺度问题的。试一试

@Column(name="MAX_NUMBER_CASH_IN_PREPAID", precision=0)
private Double test;

参考：JPA mapping a Java Double to a SQL Number column