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