数据库存储购买

-- 创建购买记录表
CREATE TABLE purchase_records (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    product_id INT NOT NULL,
    quantity INT NOT NULL,
    purchase_date DATETIME NOT NULL,
    total_price DECIMAL(10, 2) NOT NULL
);

-- 插入一条购买记录
INSERT INTO purchase_records (user_id, product_id, quantity, purchase_date, total_price)
VALUES (1, 101, 2, NOW(), 199.98);

// 连接到MongoDB数据库
const MongoClient = require('mongodb').MongoClient;
const url = 'mongodb://localhost:27017';
const dbName = 'ecommerce';

MongoClient.connect(url, function(err, client) {
    if (err) throw err;
    const db = client.db(dbName);
    const collection = db.collection('purchaseRecords');

    // 插入一条购买记录
    const record = {
        userId: 1,
        productId: 101,
        quantity: 2,
        purchaseDate: new Date(),
        totalPrice: 199.98
    };
    collection.insertOne(record, function(err, res) {
        if (err) throw err;
        console.log("购买记录插入成功");
        client.close();
    });
});