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();