写一个基于python和MySQL的物流管理系统

好的，我可以为您提供一个简单的物流管理系统的示例代码。

首先，您需要安装MySQL数据库和Python MySQL库。然后，创建一个名为“logistics”的数据库，并创建三个表：customer（客户信息）、order（订单信息）和shipment（发货信息）。

接下来是Python代码：

import mysql.connector

# 连接数据库
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="logistics"
)

# 客户信息
def create_customer(name, address, phone):
    mycursor = mydb.cursor()
    sql = "INSERT INTO customer (name, address, phone) VALUES (%s, %s, %s)"
    val = (name, address, phone)
    mycursor.execute(sql, val)
    mydb.commit()
    print(mycursor.rowcount, "记录插入成功。")

def get_customer(customer_id):
    mycursor = mydb.cursor()
    sql = "SELECT * FROM customer WHERE id = %s"
    val = (customer_id,)
    mycursor.execute(sql, val)
    return mycursor.fetchone()

def update_customer(customer_id, name=None, address=None, phone=None):
    mycursor = mydb.cursor()
    sql = "UPDATE customer SET "
    if name:
        sql += "name = %s, "
    if address:
        sql += "address = %s, "
    if phone:
        sql += "phone = %s, "
    sql = sql[:-2] + " WHERE id = %s"
    val = (name, address, phone, customer_id)
    mycursor.execute(sql, val)
    mydb.commit()
    print(mycursor.rowcount, "记录更新成功。")

# 订单信息
def create_order(customer_id, item, quantity):
    mycursor = mydb.cursor()
    sql = "INSERT INTO order (customer_id, item, quantity) VALUES (%s, %s, %s)"
    val = (customer_id, item, quantity)
    mycursor.execute(sql, val)
    mydb.commit()
    print(mycursor.rowcount, "记录插入成功。")

def get_order(order_id):
    mycursor = mydb.cursor()
    sql = "SELECT * FROM order WHERE id = %s"
    val = (order_id,)
    mycursor.execute(sql, val)
    return mycursor.fetchone()

def update_order(order_id, customer_id=None, item=None, quantity=None):
    mycursor = mydb.cursor()
    sql = "UPDATE order SET "
    if customer_id:
        sql += "customer_id = %s, "
    if item:
        sql += "item = %s, "
    if quantity:
        sql += "quantity = %s, "
    sql = sql[:-2] + " WHERE id = %s"
    val = (customer_id, item, quantity, order_id)
    mycursor.execute(sql, val)
    mydb.commit()
    print(mycursor.rowcount, "记录更新成功。")

# 发货信息
def create_shipment(order_id, date, status):
    mycursor = mydb.cursor()
    sql = "INSERT INTO shipment (order_id, date, status) VALUES (%s, %s, %s)"
    val = (order_id, date, status)
    mycursor.execute(sql, val)
    mydb.commit()
    print(mycursor.rowcount, "记录插入成功。")

def get_shipment(shipment_id):
    mycursor = mydb.cursor()
    sql = "SELECT * FROM shipment WHERE id = %s"
    val = (shipment_id,)
    mycursor.execute(sql, val)
    return mycursor.fetchone()

def update_shipment(shipment_id, order_id=None, date=None, status=None):
    mycursor = mydb.cursor()
    sql = "UPDATE shipment SET "
    if order_id:
        sql += "order_id = %s, "
    if date:
        sql += "date = %s, "
    if status:
        sql += "status = %s, "
    sql = sql[:-2] + " WHERE id = %s"
    val = (order_id, date, status, shipment_id)
    mycursor.execute(sql, val)
    mydb.commit()
    print(mycursor.rowcount, "记录更新成功。")

这是一个简单的物流管理系统的示例代码，您可以根据自己的需求进行修改和扩展。