java sql like,如何在java中实现类似'LIKE'运算符的SQL？

最新推荐文章于 2024-08-24 04:38:18 发布

我是跟野兽差不了多少

最新推荐文章于 2024-08-24 04:38:18 发布

阅读量498

点赞数

文章标签： java sql like

"该博客讨论了如何在Java中创建一个比较器，其行为类似于SQL的LIKE操作符。作者提供了几个示例，如`myComparator.like("digital","%ital%")`和`myComparator.like("digital","%gi?a%")`，并解释了期望的匹配结果。文章还提到了使用正则表达式作为可能的实现方式，并给出了相应的Java代码片段。"

摘要由CSDN通过智能技术生成

I need a comparator in java which has the same semantics as the sql 'like' operator.

For example:

myComparator.like("digital","%ital%");

myComparator.like("digital","%gi?a%");

myComparator.like("digital","digi%");

should evaluate to true, and

myComparator.like("digital","%cam%");

myComparator.like("digital","tal%");

should evaluate to false. Any ideas how to implement such a comparator or does anyone know an implementation with the same semantics? Can this be done using a regular expression?

解决方案

.* will match any characters in regular expressions

I think the java syntax would be

"digital".matches(".*ital.*");

And for the single character match just use a single dot.

"digital".matches(".*gi.a.*");

And to match an actual dot, escape it as slash dot