@Select 加判断，mybatis，加错误元素内容必须由格式正确的字符数据或标记组成解决

楚楚动人的明

已于 2022-04-26 18:33:52 修改

阅读量689

点赞数 1

分类专栏： SpringBoot 文章标签： mybatis select

于 2022-04-25 18:48:41 首次发布

本文链接：https://blog.csdn.net/weixin_38110122/article/details/124411673

版权

SpringBoot 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

@Select("<script>  "+
	"SELECT d.name as name,SUM(s.number) as `value`, t.tenant_name \n" +
		"FROM blade_sales_data s LEFT JOIN blade_dishes d on s.dish_name=d.id \n" +
		"LEFT JOIN blade_tenant t on s.tenant_id = t.tenant_id \n" +
		"where s.is_deleted=0  " +
		" <if test=\"tenantId != null and tenantId != '' \" >" +
		" and s.tenant_id = #{tenantId}" +
		" </if>" +
		" <if test=\"goodsId != null and goodsId != '' \" >" +
		" and s.goods_Id = #{goodsId}" +
		" </if>" +
		" <if test=\"storeId != null and storeId != '' \" >" +
		" and s.store_Id = #{storeId}" +
		" </if>" +
		"GROUP BY s.dish_name\n" +
		"order by SUM(s.number) desc"+
		" </script>")
	List<Echarts> list(Long tenantId,Long goodsId,Long storeId);

2.错误元素内容必须由格式正确的字符数据或标记组成解决

使用<![CDATA[ SQL语句 ]]> 将含有<、>、<=、>=的sql语句包含进去