IDEA模糊查询-优快云博客

本文链接：https://blog.youkuaiyun.com/XiaoZJun/article/details/109239052

本文介绍了在IntelliJ IDEA中进行Java项目模糊查询的方法，涉及BookMapper类、BookMapper.xml配置、BookService及BookServiceImpl的服务实现，并通过测试类验证了查询结果。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

idea模糊查询

方法

BookMapper类

 /*模糊查询
     * #{}
     * ${}
     * concat
     * */
    List<Book> selectBooksLike1(@Param("bname")String book_name);
    List<Book> selectBooksLike2(@Param("bname")String book_name);
    List<Book> selectBooksLike3(@Param("bname")String book_name);

BookMapper.xml类

  <!--模糊查询-->
  <select id="selectBooksLike1" resultType="com.zhoujun.model.Book" parameterType="java.lang.String">
     select * from t_book_hb where book_name like #{bname}
  </select>

  <select id="selectBooksLike2" resultType="com.zhoujun.model.Book" parameterType="java.lang.String">
       select * from t_book_hb where book_name like '${bname}'
  </select>

  <select id="selectBooksLike3" resultType="com.zhoujun.model.Book" parameterType="java.lang.String">
      select * from t_book_hb where book_name like concat(concat('%',#{bname}),'%')
  </select>

BookService类

/*模糊查询
* #{}
* ${}
* concat
* */
    List<Book> selectBooksLike1(String book_name);
    List<Book> selectBooksLike2(String book_name);
    List<Book> selectBooksLike3(String book_name);

BookServicelmpl类


    @Override
    public List<Book> selectBooksLike1(String book_name) {
        return bookMapper.selectBooksLike1(book_name);
    }

    @Override
    public List<Book> selectBooksLike2(String book_name) {
        return bookMapper.selectBooksLike2(book_name);
    }

    @Override
    public List<Book> selectBooksLike3(String book_name) {
        return bookMapper.selectBooksLike3(book_name);
    }

测试类

    @Test
     public  void selectBooksLike(){
        String book_name ="西游";
//        List<Book> books =this.bookService.selectBooksLike1(StringUtils.toLikeStr(book_name));
//      List<Book> books =this.bookService.selectBooksLike3(book_name);
        List<Book> books =this.bookService.selectBooksLike2(StringUtils.toLikeStr(book_name));
    for (Book b: books){
        System.out.println(b);
    }

    }

结果

在这里插入图片描述