多条件查询

一叶扁舟3

于 2019-01-25 10:09:27 发布

阅读量349

点赞数

分类专栏： ssm

本文链接：https://blog.csdn.net/qq_42662114/article/details/86636884

版权

ssm 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

<select id="selectByPrimaryKeySelective" parameterType="com.mjs.mojisishop.entity.OrderInfo"
            resultMap="orderInfoMap">
        select
        e1.id,e1.orderNo,e1.payType,e1.orderPrice,e1.orderStatus,e1.contacts,e1.phoneNum,e1.address,e1.expressName,e1.expressCode,
        e1.creatUser,e1.note,e1.creatTime,e1.lastTime,
        e2.id as oid,e2.orderNo as
        oorderNo,e2.discountCode,e2.itemId,e2.goodsName,e2.unitPrice,e2.amount,e2.totalPrice,e2.detailStatus,
        e2.creatUser as ocreatUser,e2.creatTime as ocreatTime,e2.lastTime as olastTime
        from `order` e1,order_detail e2
        where 1=1 and e1.orderNo=e2.orderNo
        <if test="orderno!=null and orderno!=''">
            and e1.orderNo like concat('%',#{orderno},'%')
        </if>
        <if test="orderstatus != null and orderstatus != ''">
            and orderStatus = #{orderstatus,jdbcType=INTEGER}
        </if>
        <if test="title != null and title != ''  ">
            and title like concat('%',#{title},'%')
        </if>
        <if test="creattime != null or  lasttime != null ">
            and e1.creatTime
            between #{creattime,jdbcType=TIMESTAMP} and
            #{lasttime,jdbcType=TIMESTAMP}
        </if>
         <!--查询可用优惠券时传creatTime,来比较validtime,&gt;=大于等于，&lt;=小于等于
        -->
        <if test="creatTime != null ">
            <!--<![CDATA[and validTime >= #{creatTime}]]>-->
            and validTime &gt;= #{creatTime}
        </if>
        <if test="validTime != null ">
            and validTime &lt; #{validTime}
        </if>
    </select>

注意if条件末尾不能有逗号