如何在Play框架中实现embeddedId的find()或findById()方法

Question

我最近一直在使用play框架创建项目，非常感谢这个论坛上的朋友们的帮助。现在我在玩的时候又有问题了。我有一些具有唯一id(不是增量/默认id)的模型类，因此我在模型类中扩展GenericModel而不是model。我感到困惑如何使用GenericMOdel的find()或findById()方法为EmbeddedId字段。这是我的代码片段:

型号1:

@Entity
@Table(name="DATKAPJMLPST")
public class Datkapjmlpst extends GenericModel {
//private static final long serialVersionUID = 1L;
@EmbeddedId
public DatkapjmlpstPK id;
@Column(name="BIAYAKAP")
public BigDecimal biayakap;
@Column(name="BPJ")
public BigDecimal bpj;
@Temporal( TemporalType.DATE)
@Column(name="DtProses")
public Date dtProses;
public String flag;
@Column(name="JmlPstKom")
public BigDecimal jmlPstKom;
@Column(name="JmlPstSos")
public BigDecimal jmlPstSos;
@Column(name="JmlPstTotal")
public BigDecimal jmlPstTotal;
@Column(name="KdDati2")
public String kdDati2;
//@Column(name="KdKC")
@ManyToOne
@JoinColumn(name="KDKC")
public Refkc refKC;
@Column(name="NOREG")
public String noreg;
public Datkapjmlpst() {
}

}

模型2:

@Embeddable
public class DatkapjmlpstPK extends GenericModel {
//default serial version id, required for serializable classes.
//private static final long serialVersionUID = 1L;
@Temporal(TemporalType.DATE)
@Column(name="Bln")
public Date bln;
//@Column(name="KdPPK")
@ManyToOne
@JoinColumn(name="KdPPK")
public Refppk refPPK;
@Column(name="KdBU")
public String kdBU;
public DatkapjmlpstPK() {
}

}

控制器的方法:

public static void show(Date bln, String kdppk, String kdbu) {
    JPAQuery datkapjmlpst = Datkapjmlpst.find("SELECT d FROM Datkapjmlpst d " +
            "WHERE d.id.bln=? AND d.id.refPPK.kdppk=? AND d.id.kdBU=?", bln,    kdppk, kdbu);
    render(datkapjmlpst, bln, kdppk, kdbu);
}   

视图:

#{form @edit(datkapjmlpst.id.bln, datkapjmlpst.id.refPPK.kdppk, datkapjmlpst.id.kdBU)}
<p>
    <strong>Tanggal:</strong> ${datkapjmlpst.bln?.format('dd-MM-yyyy')}
</p>
<p>
    <strong>Kantor Cabang:</strong> ${datkapjmlpst.refKC.nmkc}
</p>
<p>
    <strong>BPJ:</strong> ${datkapjmlpst.bpj}
</p>
<p>
    <strong>Jml Peserta Sosial:</strong> ${datkapjmlpst.jmlPstSos}
</p>
<p>
    <strong>Status:</strong> ${datkapjmlpst.flag}
</p>
<p class="buttons">
    <input type="submit" value="Edit Kapitasi"> <a href="@{index()}">Back to search</a>      
</p>
#{/form}

这些代码有如下错误输出:

Internal Server Error (500) for request GET /kapitasi/show?     kdbu=00000000&kdppk=00080001&bln=2011-04-01
Template execution error (In /app/views/Kapitasi/show.html around line 5)

在template/app/views/Kapitasi/show.html中发生执行错误。异常是MissingPropertyException: No such property: id for class: play.db.jpa.GenericModel$JPAQuery.

play.exceptions.TemplateExecutionException: No such property: id for class: play.db.jpa.GenericModel$JPAQuery
at play.templates.BaseTemplate.throwException(BaseTemplate.java:84)
at play.templates.GroovyTemplate.internalRender(GroovyTemplate.java:252)
at play.templates.Template.render(Template.java:26)
at play.templates.GroovyTemplate.render(GroovyTemplate.java:184)
at play.mvc.results.RenderTemplate.<init>(RenderTemplate.java:24)
at play.mvc.Controller.renderTemplate(Controller.java:659)
at play.mvc.Controller.renderTemplate(Controller.java:639)
at play.mvc.Controller.render(Controller.java:694)
at controllers.Kapitasi.show(Kapitasi.java:62)
at play.mvc.ActionInvoker.invokeWithContinuation(ActionInvoker.java:543)
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:499)
at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:475)
at play.mvc.ActionInvoker.invokeControllerMethod(ActionInvoker.java:470)
at play.mvc.ActionInvoker.invoke(ActionInvoker.java:158)
at Invocation.HTTP Request(Play!)
Caused by: groovy.lang.MissingPropertyException: No such property: id for class:  play.db.jpa.GenericModel$JPAQuery
at /app/views/Kapitasi/show.html.(line:5)
at play.templates.GroovyTemplate.internalRender(GroovyTemplate.java:229)
... 13 more

Answer 1

例外是抱怨您的DatkapjmlpstPK类缺少@Id。你的DatkapjmlpstPK类是一个EmbeddedId类，所以它不需要扩展GenericModel