mapper.xml中常用sql

1.模糊匹配，时间范围，集合用IN查找登的写法

SELECT * from tableName
 1 = 1
    
        and waybillPrintStatus = #{vo.waybillPrintStatus}
    
    
        = #{vo.startTime} ]]>
    
    
        
    
    
        and province IN
        
            #{item}
        
    

order by time DESC

2.批量更新，如果为null的值给0，IFNULL函数

    UPDATE t_custom_xiaohs_orders
    SET
    WaybillPrintStatus= #{waybillPrintStatus},
    WaybillPrintCount = IFNULL(WaybillPrintCount, 0) + 1,
    WaybillPrintTime = NOW()
    WHERE Id in
    
        #{id}
    


3.批量插入

    insert into t_cs_stock_goods_img
    (good_code, good_img_id, good_address, good_sort, status, create_time, create_user, modify_time, modify_user)
    values
    
        (
        #{item.goodCode},#{item.goodImgId},#{item.goodAddress},#{item.goodSort},#{item.status},#{item.createTime},
        #{item.createUser},#{item.modifyTime},#{item.modifyUser}
        )