postgres 全文搜索和 spring-data hibernate

Postgres 全文搜索与 Spring Data Hibernate

sql
-- 创建全文搜索索引
CREATE INDEX idx_posts_content ON posts USING gin(to_tsvector('english', content));
-- 执行全文搜索查询
SELECT * FROM posts WHERE to_tsvector('english', content) @@ to_tsquery('english', 'search term');

xml
    org.springframework.boot
    spring-boot-starter-data-jpa
    org.postgresql
    postgresql

java
@Entity
public class Post {
    @Id
    private Long id;
    @Column(columnDefinition = "TEXT")
    @FullTextField
    private String content;
    // 省略其他字段和方法
}

java
public interface PostRepository extends JpaRepository {
    List findByContentMatches(String searchTerm);
}

java
@Entity
public class Post {
    @Id
    private Long id;
    @Column(columnDefinition = "TEXT")
    @FullTextField
    private String content;
    // 省略其他字段和方法
}
public interface PostRepository extends JpaRepository {
    List findByContentMatches(String searchTerm);
}
@Service
public class PostService {
    @Autowired
    private PostRepository postRepository;
    public List searchPosts(String searchTerm) {
        return postRepository.findByContentMatches(searchTerm);
    }
}
@RestController
public class PostController {
    @Autowired
    private PostService postService;
    @GetMapping("/posts/search")
    public List searchPosts(@RequestParam("q") String searchTerm) {
        return postService.searchPosts(searchTerm);
    }
}