Hibernate标准：按实体中的属性列表中的内容进行搜索
我想通过内容搜索实体中的属性
我有一个简单的类来定义用户：
@Entity
public class User {
@Id
@Column(name = "pers_id")
private int persId;
@Column(name = "full_name")
private String fullName;
@OneToMany
@JoinColumn(name = "PERS_ID")
private List<UserLanguages> languages = new ArrayList<UserLanguages>();
}
@Entity
public class UserLanguages {
@Column(name="pers_id")
private int persId;
@Id
@Column(name="lang_iso_code")
private String langISO;
@Column(name="lang_full_name")
private String langFullName;
@Column(name="order_seq")
private int order;
}
@Entity
public class Language {
@Id
@Column(name="ID")
private long id;
@Column(name = "CODE")
private String code;
}
public class UserFilter {
private String name;
private List<Language> languages;
}
@Service("userService")
public class UserServiceImpl implements UserService {
@Override
public List<User> findByFilter(UserFilter userFilter) {
final Criteria criteria = userDao.createCriteria();
if (userFilter.getName() != null) {
for (final String token : userFilter.getName().toLowerCase().trim().split(" ")) {
criteria.add(Restrictions.like("fullName", "%" + token + "%"));
}
}
if (null != userFilter.getLanguages() && userFilter.getLanguages().size() > 0) {
final List<String> contents = new ArrayList<String>(userFilter.getLanguages().size());
for (final Language lang : userFilter.getLanguages()) {
contents.add(lang.getCode());
}
criteria.add(Restrictions.in("languages", contents));
}
return userDao.findByCriteria(criteria);
}
没有找到相关结果
已邀请:
1 个回复
翱抹村
实体应命名为：它代表一种语言，而不是几种语言。 然后，列是实体的外键。因此，它应该作为ManyToOne关系映射到User实体而不是基本列。 最后，回答你的问题（我假设你想找到至少有一个用户语言的用户，其代码在列表中）：你应该使用一个连接：// inner join between User and UserLanguages criteria.createAlias("languages", "userLanguage"); // restriction on the langISO property of UserLanguage criteria.add(Restrictions.in("userLanguage.langIso", contents));