Mybits模糊查询实现

最新推荐文章于 2023-02-16 15:17:33 发布

转载最新推荐文章于 2023-02-16 15:17:33 发布 · 368 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/imsorry/blog/3021242

文章标签：

#python #数据库

2019独角兽企业重金招聘Python工程师标准>>>

最近在工作中使用到了模糊查询结果,结果使用

@Select("SELECT g.*,t.type_name as typeName FROM goods_info as g,goods_type as t "
		+ "WHERE g.goods_name LIKE %#{goodsName}% AND g.type_id = t.type_id "
		+ "ORDER BY g.date_create DESC LIMIT #{start},#{size}")
@ResultMap(value = "goodsInfo")
List<GoodsInfo> queryGoodsListByName(@Param("goodsName") String goodsName,@Param("start") Integer start, @Param("size")Integer size);

结果直接报错,过百度,最终问题解决:

@Select("SELECT g.*,t.type_name as typeName FROM goods_info as g,goods_type as t "
		+ "WHERE g.goods_name LIKE CONCAT('%',#{goodsName},'%') AND g.type_id = t.type_id "
		+ "ORDER BY g.date_create DESC LIMIT #{start},#{size}")
@ResultMap(value = "goodsInfo")
List<GoodsInfo> queryGoodsListByName(@Param("goodsName") String goodsName,@Param("start") Integer start, @Param("size")Integer size);