id, OrderID, cku_id, pid, pcount, sp_price, total_price, sp_integral, add_time, xmid, pz_id, PayConfirm, operate, operate_time, memberid select from SP_carts where id = #{id,jdbcType=INTEGER} delete from SP_carts where id = #{id,jdbcType=INTEGER} insert into SP_carts (id, OrderID, cku_id, pid, pcount, sp_price, total_price, sp_integral, add_time, xmid, pz_id, PayConfirm, operate, operate_time, memberid ) values (#{id,jdbcType=INTEGER}, #{orderid,jdbcType=VARCHAR}, #{ckuId,jdbcType=VARCHAR}, #{pid,jdbcType=INTEGER}, #{pcount,jdbcType=INTEGER}, #{spPrice,jdbcType=DECIMAL}, #{totalPrice,jdbcType=DECIMAL}, #{spIntegral,jdbcType=INTEGER}, #{addTime,jdbcType=TIMESTAMP}, #{xmid,jdbcType=VARCHAR}, #{pzId,jdbcType=VARCHAR}, #{payconfirm,jdbcType=CHAR}, #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{memberid,jdbcType=VARCHAR} ) insert into SP_carts id, OrderID, cku_id, pid, pcount, sp_price, total_price, sp_integral, add_time, xmid, pz_id, PayConfirm, operate, operate_time, memberid, #{id,jdbcType=INTEGER}, #{orderid,jdbcType=VARCHAR}, #{ckuId,jdbcType=VARCHAR}, #{pid,jdbcType=INTEGER}, #{pcount,jdbcType=INTEGER}, #{spPrice,jdbcType=DECIMAL}, #{totalPrice,jdbcType=DECIMAL}, #{spIntegral,jdbcType=INTEGER}, #{addTime,jdbcType=TIMESTAMP}, #{xmid,jdbcType=VARCHAR}, #{pzId,jdbcType=VARCHAR}, #{payconfirm,jdbcType=CHAR}, #{operate,jdbcType=CHAR}, #{operateTime,jdbcType=TIMESTAMP}, #{memberid,jdbcType=VARCHAR}, update SP_carts OrderID = #{orderid,jdbcType=VARCHAR}, cku_id = #{ckuId,jdbcType=VARCHAR}, pid = #{pid,jdbcType=INTEGER}, pcount = #{pcount,jdbcType=INTEGER}, sp_price = #{spPrice,jdbcType=DECIMAL}, total_price = #{totalPrice,jdbcType=DECIMAL}, sp_integral = #{spIntegral,jdbcType=INTEGER}, add_time = #{addTime,jdbcType=TIMESTAMP}, xmid = #{xmid,jdbcType=VARCHAR}, pz_id = #{pzId,jdbcType=VARCHAR}, PayConfirm = #{payconfirm,jdbcType=CHAR}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, memberid = #{memberid,jdbcType=VARCHAR}, where id = #{id,jdbcType=INTEGER} update SP_carts set OrderID = #{orderid,jdbcType=VARCHAR}, cku_id = #{ckuId,jdbcType=VARCHAR}, pid = #{pid,jdbcType=INTEGER}, pcount = #{pcount,jdbcType=INTEGER}, sp_price = #{spPrice,jdbcType=DECIMAL}, total_price = #{totalPrice,jdbcType=DECIMAL}, sp_integral = #{spIntegral,jdbcType=INTEGER}, add_time = #{addTime,jdbcType=TIMESTAMP}, xmid = #{xmid,jdbcType=VARCHAR}, pz_id = #{pzId,jdbcType=VARCHAR}, PayConfirm = #{payconfirm,jdbcType=CHAR}, operate = #{operate,jdbcType=CHAR}, operate_time = #{operateTime,jdbcType=TIMESTAMP}, memberid = #{memberid,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER} select id, OrderID, cku_id, pid, pcount, sp_price, total_price, sp_integral, add_time, xmid, pz_id, PayConfirm, operate, operate_time, memberid from SP_carts where OrderID=#{orderid,jdbcType=VARCHAR} update SP_carts set PayConfirm = '1' where OrderID = #{orderID} delete from SP_carts where OrderID = #{orderId}