请教个问题 <isNotEmpty prepend="and" property="objCondition.shopCodes">
<isEqual property="objCondition.shopCodes" compareValue="1">
left join suppliers_info s on to_char(s.supplier_id) = pm.SHOP_CODE
</isEqual>
</isNotEmpty>
这是我的代码 objCondition 是传进来对象里面的一个map 我执行 全部查询时报错只要去了 isEqual 标签就不报错 这个怎么解决啊
<isEqual property="objCondition.shopCodes" compareValue="1">
left join suppliers_info s on to_char(s.supplier_id) = pm.SHOP_CODE
</isEqual>
</isNotEmpty>
这是我的代码 objCondition 是传进来对象里面的一个map 我执行 全部查询时报错只要去了 isEqual 标签就不报错 这个怎么解决啊
解决方案 »
- oracle如何调用带参数的存储过程
- 急急急急急急急急急!如何实现向数据库提交一张表单,让数据库批量查询
- oracle10g里面,存储过程里面可以传一个 集合对象的参数吗?
- 存储过程包的一个存储过程,PL/SQL中能编译,测试窗口能执行,但调试时提示'通信通道的文件结束',此时没有断网,session中无执行进程,无锁表.
- 急!!!!!如何我在MS sqlserver中建的所有表全部倒到oracle中,希望大家指点,包括默认值,关联
- 在cmd里exp??
- VB与ORACLE的问题
- 请大侠问数据库会话异常是什么原因?急问!!!
- java向Oracle9I数据库中插入数据
- 如何用sql语句将字段内容拆分后统计
- win2008安装oracle11g数据库后,网络连接一直转圈,如图。
- ORA-00445: background process W000 did not start after 120 seconds导致数据库死机
<select id="getProductInfo" parameterClass="pagination" resultMap="promotionProductResult">
<![CDATA[
select * from (
select ROW_NUMBER() OVER(order by sku.PRODUCT_SKU_ID desc) as view_row_number
,sku.PRODUCT_SKU_ID
,sku.PRODUCT_ID
,sku.PRICE
from PRODUCT_SKU sku
inner join PRODUCTMAIN pm on pm.PRODUCT_ID = sku.PRODUCT_ID
]]>
<isNotEmpty prepend="and" property="objCondition.shopCodes">
<isEqual property="objCondition.shopCodes" compareValue="1">
left join suppliers_info s on to_char(s.supplier_id) = pm.SHOP_CODE
</isEqual>
</isNotEmpty>
where pm.STATUS = 3 and sku.STATUS=1
<dynamic>
<isNotEmpty prepend="and" property="objCondition.channel">
pm.CHANNEL = '$objCondition.channel$'
</isNotEmpty>
<isNotEmpty prepend="and" property="objCondition.categoryIds">
pm.CATEGORY_ID in ($objCondition.categoryIds$)
</isNotEmpty>
<isNotEmpty prepend="and" property="objCondition.brandIds">
pm.BRAND_ID in ($objCondition.brandIds$)
</isNotEmpty>
<isNotEmpty prepend="and" property="objCondition.shopCodes">
<isEqual property="objCondition.shopCodes" prepend="and" compareValue="1">
pm.SHOP_CODE = '1' or s.SUPPLIER_TYPE = 1 or s.SUPPLIER_TYPE = 3
</isEqual>
<isNotEqual property="objCondition.shopCodes" prepend="and" compareValue="1">
pm.SHOP_CODE = '$objCondition.shopCodes$'
</isNotEqual>
</isNotEmpty>
</dynamic>
)
where view_row_number between $startindex$ and $endindex$
</select>