Hibernate @Formula

最新推荐文章于 2024-09-17 11:50:15 发布

zhangmiao12

最新推荐文章于 2024-09-17 11:50:15 发布

阅读量105

点赞数

分类专栏： hibernate 文章标签： java

本文链接：https://blog.csdn.net/zhangmiao12/article/details/83976423

版权

hibernate 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

hibernate 配置文件中写法：

<id name="reimId" type="java.lang.Integer">
            <column name="ReimId" />
            <generator class="native" />
        </id>

<property name="usedAmount" 
        formula="( select isnull(sum(f.amount*f.rate),0) from reimfact f where f.state != -1 and f.reimId = reimId)"/>

类中的属性

public class ReimBudget extends com.nstc.dnaf.model.DNAFModel implements java.io.Serializable {
  

     /**
	 * 
	 */
	private static final long serialVersionUID = 6773815037408697643L;
	private Integer reimId;
     private Amcode amcode;
     private Integer month;
     private Double amount0;
     private Double amountX;
     private Short state;
     private Date createTime;
     private Integer creator;
     private Integer checker;
     private Date checkTime;
     private Double usedAmount;

结合一篇文章：

http://solonote.iteye.com/blog/215093

就会理解透彻。