java - 如何按所有字段搜索休眠
问题描述
我想知道,我怎样才能在我的 dao 文件中编写方法来获取匹配某个正则表达式的所有对象?如何实现按所有字段排除字段组搜索?
例如,用户输入一个文本字段并获取符合条件 {there can be some symbols}{userText}{there can be some symbols} 的教师类对象列表。
我如何绕过所有字段排除组
这是我的实体类
@Entity
@Table(name="teacher", schema = "public")//, schema = "public"
@SuppressWarnings("unused")
public class Teacher extends Human implements Serializable {
@Id
@Column(name="teacher_id")
@GeneratedValue(strategy = GenerationType.SEQUENCE)
private Long id;
@ManyToMany(targetEntity = Group.class,fetch=FetchType.EAGER)
@JoinTable(name = "teacher_groups",
joinColumns = { @JoinColumn(name = "teacher_id") },
inverseJoinColumns = { @JoinColumn(name = "group_id") })
private List<Group> groups = new ArrayList();//<>
public List<Group> getGroups() {
return groups;
}
public void setGroups(ArrayList<Group> groups) {
this.groups = groups;
}
public void addGroup(Group group){
if (!(this.groups.contains(group))){
groups.add(group);
}
}
public void removeGroup(Group group){
for (int i = 0; i < groups.size(); i++) {
if (groups.get(i).getId().equals(group.getId()))
groups.remove(i);
}
}
public Teacher(String fam, String name, String otch, Date dateOfBirth, String phoneNumber, ArrayList<Group> groups) {
super(fam, name, otch, dateOfBirth, phoneNumber);
this.groups = groups;
}
public Teacher(String fam, String name, String otch, Date dateOfBirth, String phoneNumber) {
super(fam, name, otch, dateOfBirth, phoneNumber);
}
@Override
public String toString() {
return "Teacher{" + id + " "+
"groups=" + groups +
"} " + super.toString();
}
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public Teacher(){}
@Override
public boolean equals(Object o) {
if (this == o) return true;
if (o == null || getClass() != o.getClass()) return false;
Teacher that = (Teacher) o;
return this.getId().equals(that.getId());
}
}
这是我的道课
@Repository
public class TeacherDaoImlp implements TeacherDao {
@PersistenceContext
private EntityManager em;
@Override
public void add(Teacher teacher){
em.persist(teacher);
}
@Override
public List<Teacher> getTeachersList(){
CriteriaQuery<Teacher> criteriaQuery = em.getCriteriaBuilder().createQuery(Teacher.class);
Root<Teacher> root = criteriaQuery.from(Teacher.class);
return em.createQuery(criteriaQuery).getResultList();
}
@Override
public void update(Teacher teacher) {
em.merge(teacher);
}
@Override
public Teacher findById(Long teacherId) {
Teacher teacher = em.find(Teacher.class,teacherId);
if (teacher==null)
throw new EntityNotFoundException("Teacher with ID = " + teacherId + " not found");
return teacher;
}
@Override
public void delete(Long teacherId) {
Teacher teacher = em.find(Teacher.class, teacherId);
if (teacher != null) em.remove(teacher);
else throw new EntityNotFoundException("Teacher with ID = " + teacherId + " not found");
}
}
解决方案
你应该看看Hibernate Search。它是 lucene 和 hibernate 的混合体。
索引字段映射将如下所示:
@Field(index=Index.YES, analyze=Analyze.YES, store=Store.NO)
private String phoneNumber;
以及用于搜索的 dao 方法:
FullTextEntityManager fullTextEntityManager = Search.getFullTextEntityManager(em);
QueryBuilder qb = fullTextEntityManager.getSearchFactory()
.buildQueryBuilder().forEntity(Teacher.class).get();
org.apache.lucene.search.Query luceneQuery = qb
.keyword()
.onFields("fam", "name", "otch", "dateOfBirth", "phoneNumber")
.matching("user text")
.createQuery();
Query jpaQuery = fullTextEntityManager.createFullTextQuery(luceneQuery, Teacher.class);
List result = jpaQuery.getResultList();
依赖项:
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-search-orm</artifactId>
<version>5.11.3.Final</version>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-search-elasticsearch</artifactId>
<version>5.11.3.Final</version>
</dependency>
推荐阅读
- sql - BCP 实用程序:无法导出到具有空值的文本文件
- spring-boot - 当 eureka 服务器重新启动时,客户端无法重新注册到 eureka 服务器
- php - 在布局文件中定义后,Joomla 模块位置未更新
- c# - 在richtextbox中查找所有换行符
- ios - iOS:Objective C - Sqlite 查询以获取在 where 子句中具有逗号分隔值的记录
- r - 选择以特定字符开头和结尾的字符串中的特定单词,但中间不同
- c - 如何获取 C 程序中的进程数和线程数?
- database-design - 具有数千列的数据库表
- node.js - 猫鼬忽略必需
- android - 无法解析 androidx.databinding