用python实现网上购物管理系统代码

实现一个完整的网上购物管理系统需要考虑很多方面，包括用户管理、商品管理、订单管理等等。这里提供一些简单的代码示例，供你参考。

1. 用户注册：

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

def register(username, password):
    sql = "INSERT INTO users (username, password) VALUES (%s, %s)"
    val = (username, password)
    cursor.execute(sql, val)
    db.commit()
    print("User registered successfully")

username = input("Enter username: ")
password = input("Enter password: ")
register(username, password)

2. 商品展示：

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

def show_products():
    sql = "SELECT * FROM products"
    cursor.execute(sql)
    result = cursor.fetchall()
    for row in result:
        print(row)

show_products()

3. 购物车管理：

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

def add_to_cart(user_id, product_id):
    sql = "INSERT INTO cart (user_id, product_id) VALUES (%s, %s)"
    val = (user_id, product_id)
    cursor.execute(sql, val)
    db.commit()
    print("Product added to cart successfully")

def show_cart(user_id):
    sql = "SELECT * FROM cart WHERE user_id = %s"
    val = (user_id,)
    cursor.execute(sql, val)
    result = cursor.fetchall()
    for row in result:
        print(row)

user_id = input("Enter user ID: ")
product_id = input("Enter product ID: ")
add_to_cart(user_id, product_id)
show_cart(user_id)

4. 订单管理：

import mysql.connector

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

def create_order(user_id, product_id):
    sql = "INSERT INTO orders (user_id, product_id) VALUES (%s, %s)"
    val = (user_id, product_id)
    cursor.execute(sql, val)
    db.commit()
    print("Order created successfully")

def show_orders(user_id):
    sql = "SELECT * FROM orders WHERE user_id = %s"
    val = (user_id,)
    cursor.execute(sql, val)
    result = cursor.fetchall()
    for row in result:
        print(row)

user_id = input("Enter user ID: ")
product_id = input("Enter product ID: ")
create_order(user_id, product_id)
show_orders(user_id)

以上是一些简单的示例代码，可以帮助你了解如何使用 Python 连接数据库并实现基本的功能。当然，一个完整的网上购物管理系统需要考虑更多的细节和功能，具体实现需要根据实际情况进行细化和完善。