bean对象的结构:
User表:
@Entity
@Table(name="t_users")
public class User {
private String userId;
private String userCaption;
private String photo;
private String phone;
private String password;
private String createTime;
private Integer userStatus;
private String lastLoginTime;
private String parentId;
private String tags;
private String idCard;
private String description;
private Set<Role> roleId;
private String userToken;
Role表:
@Entity
@Table(name="t_role")
public class Role {
private int roleId;
private String roleName;
private String rights;
private String desctiption;
private String tags;
private Set<User> user;
数据库:
查询方法: 博主需要查出user中的角色总共有多少人 6为合伙人的角色
List<Role> partnerRole = baseDao.findByHql("from Role where id = 6");
Role p = partnerRole.get(0);
Set<User> partners = p.getUser();
Integer partnerCount = partners.size();