@Select("select * from product where product_name like CONCAT('%', #{search},'%')")
List<Product> getProductBySearch(String search);
必须用CONCAT()连接数据和%
@Select("select * from product where product_name like CONCAT('%', #{search},'%')")
List<Product> getProductBySearch(String search);
必须用CONCAT()连接数据和%