经典错误

1
2
3
4
5
<update id="updateOrderStatus2COMPLETED" parameterType="cc.jxlll.infrastructure.dao.po.GroupBuyOrderList">
    update group_buy_order_list
    set status = 1, out_trade_time = #{out_trade_time} , update_time = now()
    where out_trade_no = #{outTradeNo} and user_id = #{userId}
</update>
1
2
3
4
5
6
7
8
9
<insert id="insert">
    INSERT INTO group_buy_order
        (team_id, activity_id, source, channel, original_price, deduction_price,
         pay_price, target_count, complete_count, lock_count, status,
         valid_start_time, valid_end_time, create_time, update_time)
    VALUES (#{teamId}, #{activityId}, #{source}, #{channel}, #{originalPrice}, #{deductionPrice},
            #{payPrice}, #{targetCount}, #{completeCount}, #{lockCount}, 0,
            #{valid_start_time},#{valid_end_time},NOW(), NOW())
</insert>