客户信息管理系统python
时间: 2023-06-29 15:13:38 浏览: 60
好的,下面是一个简单的Python客户信息管理系统示例代码,它使用SQLite数据库来存储客户信息:
```python
import sqlite3
conn = sqlite3.connect('customers.db')
c = conn.cursor()
# 创建表格
c.execute('''CREATE TABLE customers
(id INTEGER PRIMARY KEY, name TEXT, email TEXT)''')
# 插入数据
def insert_customer(id, name, email):
c.execute("INSERT INTO customers VALUES (?, ?, ?)", (id, name, email))
conn.commit()
# 删除数据
def delete_customer(id):
c.execute("DELETE FROM customers WHERE id=?", (id,))
conn.commit()
# 更新数据
def update_customer(id, name, email):
c.execute("UPDATE customers SET name=?, email=? WHERE id=?", (name, email, id))
conn.commit()
# 查询数据
def get_customers():
c.execute("SELECT * FROM customers")
return c.fetchall()
# 菜单界面
while True:
print("1. 插入客户信息")
print("2. 删除客户信息")
print("3. 更新客户信息")
print("4. 查询客户信息")
print("5. 退出")
choice = int(input("请选择要执行的操作:"))
if choice == 1:
id = int(input("请输入客户ID:"))
name = input("请输入客户姓名:")
email = input("请输入客户邮箱:")
insert_customer(id, name, email)
elif choice == 2:
id = int(input("请输入要删除的客户ID:"))
delete_customer(id)
elif choice == 3:
id = int(input("请输入要更新的客户ID:"))
name = input("请输入新的客户姓名:")
email = input("请输入新的客户邮箱:")
update_customer(id, name, email)
elif choice == 4:
customers = get_customers()
for customer in customers:
print(customer)
elif choice == 5:
break
else:
print("无效的选择")
conn.close()
```
注意,这只是一个简单的示例代码,您可以根据自己的需求进行修改和扩展。同时,您需要确保输入的数据是安全的,避免SQL注入攻击。