mybatis与数据库,奇怪现象,求大神解答!!
小弟使用Mybatis从数据库中取值。问题是:数据库中明明有值,取出来装配时,却是空的,何解???
具体Mabatis的SQL写法是:
<select id="queryRelaTransitionBoDel" parameterType="Long" resultType="Long">
select bo1.ORDER_ITEM_ID BO_ID
from ORDER_ITEM bo1,
oo_rela oor,
order_item oo2
where oo2.ORDER_ITEM_ID = #{orderItemIdRepealed,jdbcType=DECIMAL}
and oo2.state ='ADD'
and bo1.order_item_obj_inst_id = oo2.order_item_obj_inst_id
and bo1.state = 'DEL'
and bo1.status_cd not in ('301200','400001','401700','101104')
and oo2.status_cd not in ('301200','400001','401700','101104')
and bo1.ORDER_ITEM_ID = oor.ORDER_ITEM_ID
and bo1.order_item_obj_inst_id = oor.PROD_OFFER_INST_ID
and oor.state = 'DEL'
and oor.rela_type_cd = 100004
and not exists
(select 1
from atom_action a1
where a1.atom_action_id = oor.atom_action_id
and a1.status_cd ='101104')
and rownum < 2
</select>
上面的语句,在PL/SQL中将入参配好,执行是有值的,可是返回JAVA程序后,却是空的,不懂为什么啊?