How to use MyBatis fuzzy query statement?.

2 years ago
William Carter
2 minutes

One way to implement fuzzy queries using MyBatis is by using the LIKE keyword. Here is a method to perform fuzzy queries with MyBatis.

<!-- 定义查询语句 -->
<select id="searchUsers" parameterType="String" resultType="User">
  SELECT * FROM user
  WHERE username LIKE CONCAT('%', #{keyword}, '%')
</select>

In the example above, ‘searchUsers’ is the unique identifier of the query statement, ‘username’ is the field name that needs to be matched fuzzily, and ‘#{keyword}’ is the fuzzy search keyword passed through parameters.

The code that calls the query statement is as follows:

public List<User> searchUsers(String keyword) {
  try (SqlSession sqlSession = sqlSessionFactory.openSession()) {
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    return userMapper.searchUsers(keyword);
  }
}

In the above code, the searchUsers method takes a keyword as a parameter and performs a fuzzy search using the searchUsers method of the UserMapper interface.

Please note that in the above examples, the CONCAT function is used to construct the conditions for fuzzy queries. This function is used to concatenate strings in order to add ‘%’ on both sides of the keyword to achieve fuzzy matching. The specific SQL syntax and function usage may vary depending on the type of database, so adjustments may be needed based on the actual situation.

bannerAds