mybatis穿对象和参数 的处理

来源:互联网 发布:淘宝推广流程 编辑:程序博客网 时间:2024/04/28 20:32

因很多时候,需要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>

原创粉丝点击