HQL中的按条款分组

安库什·辛格(Ankush Singh)

如何在Hibernate中的HQL中编写给定的sql并获取包含两列的对象数组

select specialization, count(specialization) 
from ocs_tbl_doctor group by specialization;

映射Bean类为

DoctorBean.java

@Entity
@Table(name = "OCS_TBL_DOCTOR")
public class DoctorBean {

@Id
@Column(name = "DOCTORID")
private String doctorID;

@Column(name = "DOCTORNAME")
private String doctorName;

@Column(name = "DATEOFBIRTH")
private Date dateOfBirth;

@Column(name = "DATEOFJOINING")
private Date dateOfJoining;

@Column(name = "GENDER")
private String gender;

@Column(name = "QUALIFICATION")
private String qualification;

@Column(name = "SPECIALIZATION")
private String specialization;

@Column(name = "YEARSOFEXPERIENCE")
private int yearsOfExperience;

@Column(name = "STREET")
private String street;

@Column(name = "LOCATION")
private String location;

@Column(name = "CITY")
private String city;

@Column(name = "STATE")
private String state;

@Column(name = "PINCODE")
private String pincode;

@Column(name = "CONTACTNUMBER")
private String contactNumber;

@Column(name = "EMAILID")
private String emailID;

//getters and setters
}

我在投影第二列时遇到问题,即(count(specialization))

哈利勒M

试试这个:

select d.specialization, count(d.specialization) 
from DoctorBean d  group by d.specialization;

本文收集自互联网,转载请注明来源。

如有侵权,请联系 [email protected] 删除。

编辑于
0

我来说两句

0 条评论
登录 后参与评论

相关文章