mysql查询语句 ssh中,有一个employee的类,里面有private Set<Users> usersSet;的属性,请问如何根据这个set集合的长度,取出集合长度最小的Employee呢?谢谢...... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 package com.surveycool.entity;import java.util.Date;import java.util.Set;public class Employee { private int empId; private String empName; private String empRealName; private String empPwd; private String empType; private String empState; private Date addTime; private String phone; private String email; //接待的users集合 private Set<Users> usersSet; //审批员审批的users集合 private Set<Users> usersAudSet; //客户经理审核的paper集合 private Set<Paper> paperAudSet; //部门经理审核的paper集合 private Set<Paper> paperPartSet; public Set<Users> getUsersSet() { return usersSet; } public void setUsersSet(Set<Users> usersSet) { this.usersSet = usersSet; } public Set<Paper> getPaperAudSet() { return paperAudSet; } public void setPaperAudSet(Set<Paper> paperAudSet) { this.paperAudSet = paperAudSet; } public Set<Paper> getPaperPartSet() { return paperPartSet; } public void setPaperPartSet(Set<Paper> paperPartSet) { this.paperPartSet = paperPartSet; } public int getEmpId() { return empId; } public void setEmpId(int empId) { this.empId = empId; } public String getEmpName() { return empName; } public void setEmpName(String empName) { this.empName = empName; } public String getEmpRealName() { return empRealName; } public void setEmpRealName(String empRealName) { this.empRealName = empRealName; } public String getEmpPwd() { return empPwd; } public void setEmpPwd(String empPwd) { this.empPwd = empPwd; } public String getEmpType() { return empType; } public void setEmpType(String empType) { this.empType = empType; } public String getEmpState() { return empState; } public void setEmpState(String empState) { this.empState = empState; } public Date getAddTime() { return addTime; } public void setAddTime(Date addTime) { this.addTime = addTime; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } //得到客户经理的客户数量 public int getUsersCount() { return this.usersSet.size(); } public void setUsersAudSet(Set<Users> usersAudSet) { this.usersAudSet = usersAudSet; } public Set<Users> getUsersAudSet() { return usersAudSet; } }//class //接待的users集合 private Set<Users> usersSet;意思是根据这个集合的长度,从数据库取出长度最小的那条记录,请问hibernate的hql语句是什么??谢谢...... from Employee e where e.usersSet.size =(select min(x.usersSet.size) from Employee)自己搞定了,谢谢!! 关于学习jsp的问题 javax.mail.MessagingException 征求大家意见-买书 spring如何来管理jsf请高手指点 数据库连接池 高手帮忙指指路,谢谢! spring和struts利用DelegatingRequestProcessor结合后如何使用tiles的问题,查遍了资料没有一个能解决的?!大虾帮忙,解决分全送! JAVA做个项目SERVLET 新手请教使用shark(jspclient)时的问题 我的jbuilder 6 有问题,你们有没有啊? 请问在vb中的byte s=&H1在java中怎么实现? 地址不能连接
import java.util.Set;public class Employee {
private int empId;
private String empName;
private String empRealName;
private String empPwd;
private String empType;
private String empState;
private Date addTime;
private String phone;
private String email;
//接待的users集合
private Set<Users> usersSet;
//审批员审批的users集合
private Set<Users> usersAudSet;
//客户经理审核的paper集合
private Set<Paper> paperAudSet;
//部门经理审核的paper集合
private Set<Paper> paperPartSet;
public Set<Users> getUsersSet() {
return usersSet;
}
public void setUsersSet(Set<Users> usersSet) {
this.usersSet = usersSet;
}
public Set<Paper> getPaperAudSet() {
return paperAudSet;
}
public void setPaperAudSet(Set<Paper> paperAudSet) {
this.paperAudSet = paperAudSet;
}
public Set<Paper> getPaperPartSet() {
return paperPartSet;
}
public void setPaperPartSet(Set<Paper> paperPartSet) {
this.paperPartSet = paperPartSet;
}
public int getEmpId() {
return empId;
}
public void setEmpId(int empId) {
this.empId = empId;
}
public String getEmpName() {
return empName;
}
public void setEmpName(String empName) {
this.empName = empName;
}
public String getEmpRealName() {
return empRealName;
}
public void setEmpRealName(String empRealName) {
this.empRealName = empRealName;
}
public String getEmpPwd() {
return empPwd;
}
public void setEmpPwd(String empPwd) {
this.empPwd = empPwd;
}
public String getEmpType() {
return empType;
}
public void setEmpType(String empType) {
this.empType = empType;
}
public String getEmpState() {
return empState;
}
public void setEmpState(String empState) {
this.empState = empState;
}
public Date getAddTime() {
return addTime;
}
public void setAddTime(Date addTime) {
this.addTime = addTime;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
//得到客户经理的客户数量
public int getUsersCount() {
return this.usersSet.size();
}
public void setUsersAudSet(Set<Users> usersAudSet) {
this.usersAudSet = usersAudSet;
}
public Set<Users> getUsersAudSet() {
return usersAudSet;
}
}//class
//接待的users集合
private Set<Users> usersSet;意思是根据这个集合的长度,从数据库取出长度最小的那条记录,请问hibernate的hql语句是什么??谢谢......
自己搞定了,谢谢!!