Establish an order payment table for the grocery shopping system in MySQL

To establish the order payment table of the grocery shopping system in MySQL, specific code examples are required

With the development of the Internet, shopping has become more and more convenient. In the shopping process, order payment is an important part of the shopping process. The grocery shopping system not only needs to have an order generation function, but also must have a complete payment process, because only successful payment can be regarded as completing a transaction. This article will describe how to create an order payment table for the grocery shopping system in MySQL and provide specific code examples.

1. Order payment table design

The order payment table in the food shopping system stores order information. The order information includes order ID, total order amount, payment method, payment time and order status, etc. .

1. Order payment table field design

In order to better meet business needs, the order payment table should contain the following fields:

Table name: payment

Field name | Data type | Description
————|————-|——————
payment_id | int | Order payment ID, auto-increment
order_id | int | Order ID
payment_method | varchar(32) | Payment method: Alipay, WeChat, bank card, etc.
payment_amount| decimal(10,2)| Order payment amount, keep two decimal places
payment_time | datetime | Payment time
payment_status | int | Payment status: 0-unpaid, 1-paid

2. Order payment table structure example

CREATE TABLE payment (
payment_id int(11) NOT NULL AUTO_INCREMENT,
order_id int(11) NOT NULL,
payment_method varchar(32) NOT NULL,
payment_amount decimal(10,2) NOT NULL,
payment_time datetime NOT NULL,
payment_status tinyint(4) NOT NULL DEFAULT ' 0',
PRIMARY KEY (payment_id),
KEY fk_order_id (order_id),
CONSTRAINT fk_order_id FOREIGN KEY (order_id) REFERENCES order (order_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2. Code Example

When an order is generated, the field information of the order payment table needs to be updated. The following is an example of Java code to insert data into the order payment table.

/**

• Order payment service class
  *
  */

@Service
public class PaymentService {

@Autowired
private PaymentMapper paymentMapper;

/**
 * 插入订单支付信息
 *
 * @param paymentDTO 订单支付信息
 * @return boolean
 */
public boolean insertPayment(PaymentDTO paymentDTO) {
    Payment payment = new Payment();
    payment.setOrderId(paymentDTO.getOrderId());
    payment.setPaymentMethod(paymentDTO.getPaymentMethod());
    payment.setPaymentAmount(paymentDTO.getPaymentAmount());
    payment.setPaymentTime(paymentDTO.getPaymentTime());
    payment.setPaymentStatus(paymentDTO.getPaymentStatus());
    int result = paymentMapper.insertSelective(payment);
    return result > 0;
}

}

/**

• Order payment Mapper
  *
  */

@Mapper
public interface PaymentMapper {

/**
 * 插入订单支付信息
 *
 * @param payment 订单支付信息
 * @return int
 */
int insertSelective(Payment payment);

}

/**

• Order payment entity class
  *
  */

public class Payment {

/**
 * 订单支付ID
 */
private Long paymentId;

/**
 * 订单ID
 */
private Long orderId;

/**
 * 支付方式
 */
private String paymentMethod;

/**
 * 支付金额
 */
private BigDecimal paymentAmount;

/**
 * 支付时间
 */
private Date paymentTime;

/**
 * 支付状态
 */
private Integer paymentStatus;

// 省略getter、setter方法

}

3. Summary

When developing a grocery shopping system, the order payment table is a very important table. It records payment information for each transaction, including payment method, payment time and payment status. Through the above sample code, you can better understand how to create the order payment table of the grocery shopping system, so as to better implement the related functions of the grocery shopping system.

The above is the detailed content of Establish an order payment table for the grocery shopping system in MySQL. For more information, please follow other related articles on the PHP Chinese website!