mybatis穿对象和参数 的处理

因很多时候,需要mybatis传入的对象中没有该参数,所以需要都传入xml


mybatis的java文件:

List<Map> findOrderDetailList(@Param("orderDetails")OrderDetails orderDetails,@Param("orderActualstorageTimeEnd") String orderActualstorageTimeEnd,@Param("orderCheckinTimeEnd")String orderCheckinTimeEnd);

mybatis的xml文件:


<select id="findOrderDetailList"  resultType="java.util.Map">
SELECT OD.ORDER_SYSCODE,OD.ORDER_CODE,
FROM ORDER_DETAILS OD,ORDER_DETAILS_ATTACHMENT ODA WHERE 1 = 1  AND OD.ORDER_CODE = ODA.ORDER_CODE(+) AND OD.ORDER_COMPANY = #{orderDetails.orderCompany,jdbcType=VARCHAR}
<if test="orderDetails.orderCode != null and orderDetails.orderCode!= ''">
    AND  OD.ORDER_CODE=#{orderDetails.orderCode,jdbcType=VARCHAR}
</if>

<if test="orderDetails.orderHawbcode != null and orderDetails.orderHawbcode!= ''">
  AND OD.ORDER_HAWBCODE=#{orderDetails.orderHawbcode,jdbcType=VARCHAR}
</if>
<if test="orderDetails.orderMawbcode != null and orderDetails.orderMawbcode!= ''">
  AND  OD.ORDER_MAWBCODE=#{orderDetails.orderMawbcode,jdbcType=VARCHAR}
</if>
<if test="orderDetails.orderConsignor!=null and orderDetails.orderConsignor!=''">
  AND OD.ORDER_CONSIGNOR like '%${orderDetails.orderConsignor}%'
</if>
<if test="orderDetails.orderReceiver!=null and orderDetails.orderReceiver!=''">
 <!-- AND OD.ORDER_RECEIVER=#{orderReceiver,jdbcType=VARCHAR}-->
  AND OD.ORDER_RECEIVER like '%${orderDetails.orderReceiver}%'
</if>
<if test="orderDetails.orderSyscode!=null and orderDetails.orderSyscode!=''">
  AND OD.ORDER_SYSCODE=#{orderDetails.orderSyscode,jdbcType=VARCHAR}
</if>

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值