Mybatis模糊查询、按商品上架时间查询

最新推荐文章于 2024-08-10 16:15:08 发布

算法萌新2024

最新推荐文章于 2024-08-10 16:15:08 发布

阅读量1.1k

点赞数

本文链接：https://blog.csdn.net/weixin_42273990/article/details/80627674

版权

<select id="selectByName" resultType="entity.Good">
		select * from goods where name like '%'||#{name}||'%'
	</select>
	<select id="selectByPrice" resultType="entity.Good">
		select * from goods where price between #{begin} and #{end}
	</select>
	<select id="selectByStatus" resultType="entity.Good">
		select * from goods where status=#{status}
	</select>
	<select id="selectThisMonth" resultType="entity.Good">
		select * from goods where to_char(create_date,'MM')=to_char(sysdate,'MM')
	</select>