如何在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))
试试这个:
select d.specialization, count(d.specialization)
from DoctorBean d group by d.specialization;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句