给我一个居家养老客户管理系统代码
时间: 2024-05-16 11:17:12 浏览: 17
以下是一个简单的居家养老客户管理系统代码,使用 Python 和 SQLite 数据库:
```python
import sqlite3
# 连接数据库
conn = sqlite3.connect('customer.db')
# 创建客户表
conn.execute('''CREATE TABLE IF NOT EXISTS CUSTOMER
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
PHONE TEXT NOT NULL,
EMAIL TEXT);''')
# 添加客户
def add_customer(id, name, age, phone, email):
conn.execute("INSERT INTO CUSTOMER (ID,NAME,AGE,PHONE,EMAIL) \
VALUES (?, ?, ?, ?, ?)", (id, name, age, phone, email))
conn.commit()
print("添加客户成功!")
# 删除客户
def delete_customer(id):
conn.execute("DELETE from CUSTOMER where ID = ?", (id,))
conn.commit()
print("删除客户成功!")
# 更新客户信息
def update_customer(id, name, age, phone, email):
conn.execute("UPDATE CUSTOMER set NAME = ?, AGE = ?, PHONE = ?, EMAIL = ? where ID = ?", (name, age, phone, email, id))
conn.commit()
print("更新客户信息成功!")
# 查询客户信息
def query_customer(id):
cursor = conn.execute("SELECT ID, NAME, AGE, PHONE, EMAIL from CUSTOMER where ID = ?", (id,))
for row in cursor:
print("ID = ", row[0])
print("NAME = ", row[1])
print("AGE = ", row[2])
print("PHONE = ", row[3])
print("EMAIL = ", row[4])
# 显示所有客户信息
def show_all_customers():
cursor = conn.execute("SELECT ID, NAME, AGE, PHONE, EMAIL from CUSTOMER")
for row in cursor:
print("ID = ", row[0])
print("NAME = ", row[1])
print("AGE = ", row[2])
print("PHONE = ", row[3])
print("EMAIL = ", row[4])
# 关闭数据库连接
def close_db():
conn.close()
# 主函数
def main():
while True:
print("1. 添加客户")
print("2. 删除客户")
print("3. 更新客户信息")
print("4. 查询客户信息")
print("5. 显示所有客户信息")
print("6. 退出程序")
choice = input("请选择(1-6):")
if choice == '1':
id = int(input("请输入客户ID:"))
name = input("请输入客户姓名:")
age = int(input("请输入客户年龄:"))
phone = input("请输入客户电话:")
email = input("请输入客户邮箱:")
add_customer(id, name, age, phone, email)
elif choice == '2':
id = int(input("请输入客户ID:"))
delete_customer(id)
elif choice == '3':
id = int(input("请输入客户ID:"))
name = input("请输入客户姓名:")
age = int(input("请输入客户年龄:"))
phone = input("请输入客户电话:")
email = input("请输入客户邮箱:")
update_customer(id, name, age, phone, email)
elif choice == '4':
id = int(input("请输入客户ID:"))
query_customer(id)
elif choice == '5':
show_all_customers()
elif choice == '6':
close_db()
break
else:
print("输入错误,请重新输入!")
if __name__ == '__main__':
main()
```
该代码创建了一个名为 `CUSTOMER` 的客户表,其中包含客户ID、姓名、年龄、电话和邮箱等信息。客户信息的增删改查都在主函数中实现,并且使用 `sqlite3` 模块连接和操作 SQLite 数据库。
相关推荐
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)