且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在宁静的Web服务中使用Hibernate进行SQL查询

更新时间:2023-08-31 17:18:10

我找到了答案:

("select d.key from Deliverable as d, Task as t
                where t.deliverable.id = d.id and
                t.id = (select max(t1.id) from Task t1 where t1.deliverable.id = d.id)
                and d.project.id= :id
                and t.user.username = :name
                order by t.id desc")
        .setMaxResults(3)
        .setLong("id", projectId)
        .setString("name", username)
        .list();