使用count和groupby查询Hibernate条件

Question

我需要将以下查询转换为hibernate条件查询。请帮忙

由于投票表上的复合主键，我用@Embeddable分隔了主键，所以后面的createQuery不起作用

session.createQuery("select V.Vote_Option, count(V.Vote_Option) from Votes  V where V.Event_ID ="+eventId+" group by V.Vote_Option").list()

Criteria criteria = session.createCriteria(Votes.class);
            criteria.add(Restrictions.eq("Event_ID", eventId));
    criteria.setProjection(Projections.projectionList()
            .add(Projections.property("Vote_Option"))
            .add(Projections.property("count(Vote_Option)"))
            .add(Projections.groupProperty("Vote_Option")));

    List<String> showVotes= criteria.list();

@Entity
@Table(name="Votes")

public class Votes {

public Votes(){}

@EmbeddedId
private Vote vote;

@Column(name = "Vote_Option")
private int Vote_Option;
//setter getters...

和可嵌入对象

  @Embeddable
  public class Vote implements Serializable{

    public Vote(){}

    @Column(name="Event_ID")
    private int Event_ID;

    @Column(name="Voter_MSISDN")
    private long Voter_MSISDN;

     //setter getters...

请建议一个更好的方法。

Answer 1

顺便说一下，我使用createQury实现了列表，如下所示，使用embeddable entity将
从v.event_id到v.vote.event_id...vote的更改映射为@embeddable

 session.createQuery("select V.Vote_Option, count(V.Vote_Option) from Votes  V where V.vote.Event_ID ="+eventId+" group by V.Vote_Option").list();