springboot 中使用全文索引 fulltext

最新推荐文章于 2025-03-17 12:21:05 发布

m0_38034865

最新推荐文章于 2025-03-17 12:21:05 发布

阅读量718

点赞数

文章标签： java

本文链接：https://blog.youkuaiyun.com/m0_38034865/article/details/111589867

版权

1、先注册该查询函数:

import org.hibernate.dialect.MySQL5Dialect;
import org.hibernate.dialect.function.SQLFunctionTemplate;
import org.hibernate.type.StandardBasicTypes;


public class CustomerMysqlDialect extends MySQL5Dialect {

    public CustomerMysqlDialect() {
        super();
        // 注册mysql全文搜索
        registerFunction("match_against",
                new SQLFunctionTemplate(StandardBasicTypes.DOUBLE, "MATCH(?1) AGAINST(?2 IN BOOLEAN MODE)"));
    }
}

2、配置该CustomerMysqlDialect

spring.jpa.properties.hibernate.dialect=com.example.CustomerMysqlDialect

3、使用该方法：

private List<Predicate> getPredicatesByCriteria(Root<OrderInfo> root, OrderInfoQueryCriteria criteria, CriteriaBuilder criteriaBuilder) {
    List<Predicate> predicateList = CollUtil.newArrayList();

    if(StrUtil.isNotBlank(criteria.getMailNo())){
        Expression<Double> matchAgainst = criteriaBuilder.function("match_against", Double.class,
                root.get("mailNo"), criteriaBuilder.literal(criteria.getMailNo()));

        Predicate mailNoCondition = criteriaBuilder.greaterThan(matchAgainst, 0.0);

        predicateList.add(mailNoCondition);
    }
    return predicateList;
}