员工信息增删改查

内容:

1.修改个人信息程序

2.员工信息增删改查

 

 

 

一、修改个人信息程序

需求:

在一个文件中存入多个人的个人信息，如以下:
username password age position department
alex      abc123  21  Engineer       IT
rain      xyz456  32  Teacher       Teaching

功能:
1.输入用户名及密码，正确登陆系统后显示
(1)修改个人信息
(2)打印个人信息
(3)修改密码
2.上述每个选项写一个方法
3.登陆输错3次退出程序

实现1:

# 员工信息文件 -> info_employee.txt

# 员工信息(列表嵌套) -> [ "alex", "abc123", 21, "Engineer", "IT"]
info = []


# 获取员工信息
def get_info():
    with open("info_employee.txt", 'r', encoding="utf-8") as f:
        # 读取每一行的数据存入列表中
        details = f.readlines()
        # 遍历列表将每一行的数据分开并将一行的数据作为一个列表存入info列表中
        for detail in details:
            detail = detail.strip().split()
            info.append(detail)


# 登陆
def login():
    users_pwds = []
    # 获取用户名及密码:
    for index in range(1, len(info)):
        # 获取用户数据
        detail = info[index]
        # 获取用户名及密码
        user = detail[0]
        pwd = detail[1]
        users_pwds.append(dict({user: pwd}))
    # 输入用户名及密码并验证用户名及密码是否正确
    for i in range(4):
        if i == 3:
            print("你已经输错3次，不能再登陆了!")
            exit()
        # 输入用户名及密码

        username, password = input("input the username and password(eg: user pwd): ").strip().split()
        for item in users_pwds:
            if item.get(username, None) == password:
                print("登陆成功!欢迎%s!" % username)
                now_user = username
                return now_user
        else:
            print("用户名或密码错误!请重新输入")


# 打印选项
def output_chose():
    # 打印选项
    print("你有如下选项: ")
    print("1.修改个人信息")
    print("2.打印个人信息")
    print("3.修改密码")
    print("4.退出系统")
    # 用户输入选项，函数返回选项对应的整数
    while True:
        choice = input("请输入选项(数字): ")
        if choice.isdigit():
            choice = int(choice)
            if 1 <= choice <= 4:
                return choice
            else:
                print("请输入正确的数字选项!")
        else:
            print("请输入正确的数字选项!")
            continue


# 将修改后的信息写入文件中
def write_info():
    with open("info_employee.txt", "w", encoding="utf-8") as f:
        for item in info:
            for value in item:
                f.write(str(value)+"\t")
            f.write("\n")


# 1.修改个人信息
def change_info(update_name):
    index = 0
    for personal in info:
        if personal[0] == update_name:
            for i in range(len(personal)):
                print(i+1, info[0][i], ": ", personal[i])
            choice = int(input("请输入你想要修改的选项: "))
            print("修改前的值: ", info[index][choice-1])
            change = input("请输入修改后的值: ")
            info[index][choice-1] = change
            write_info()
        index += 1


# 2.打印个人信息
def output_info(personal_name):
    for personal in info:
        if personal[0] == personal_name:
            for i in range(len(personal)):
                print(info[0][i], ": ", personal[i])


# 3.修改密码
def change_pwd(change_name):
    index = 0
    # 遍历找到用户信息的位置
    for item in info:
        if item[0] == change_name:
            break
        index += 1
    # 输入两次密码，一样就通过，否则就重新输入
    while True:
        pwd1 = input("请输入新密码: ")
        pwd2 = input("请再一次输入新密码: ")
        if pwd1 == pwd2:
            info[index][1] = pwd1
            print("密码输入正确,修改密码成功!")
            write_info()
            break
        else:
            print("两次输入的密码不一样请重新输入!")


if __name__ == '__main__':
    get_info()
    login_user = login()
    while True:
        number = output_chose()
        if number == 1:
            change_info(login_user)
        if number == 2:
            output_info(login_user)
        if number == 3:
            change_pwd(login_user)
        if number == 4:
            exit()

实现2：

# __author__ = "wyb"
# date: 2018/4/20


def get_info():
    """
    获取员工信息
    :return: 返回列表，列表中每一项是存储员工信息的字典
    """
    info = []
    with open("info_employee.txt", 'r', encoding="utf-8") as f:
        # 读取每一行的数据存入列表中
        details = f.readlines()
        topics = details[0].split()                                                 # 第一排数据作为键
        for index in range(1, len(details)):                                        # 第二排开始的数据作为值
            detail = details[index].strip().split()
            dic = dict(zip(topics, detail))                                         # 把两个列表合并为一个字典
            dic["user_id"] = index                                                  # 向用户数据中添加一项user_id方便替换用户数据
            info.append(dic)
    return info


def write_info(user_data):
    """
    将修改后的用户信息写入文件中
    :param user_data: 用户信息
    :return:
    """
    data = get_info()                                               # 获取文件中数据
    for index in range(len(data)):                                  # 替换用户数据
        if data[index]["user_id"] == user_data["user_id"]:
            data[index] = user_data

    with open("info_employee.txt", 'w', encoding="utf-8") as f:     # 将数据写入新文件
        f.write("username\tpassword\tage\tposition\tdepartment\n")
        for item in data:
            f.write("%s\t%s\t%s\t%s\t%s\n" % (item["username"], item["password"], item["age"], item["position"], item["department"]))

    return


def login(info):
    """
    登陆接口
    :param info: 个人信息所有数据
    :return: 返回状态及信息
    """
    # 输入用户名及密码并验证用户名及密码是否正确
    for i in range(4):
        if i == 3:
            return {"status": -1, "error": "输错3次，不能再登陆"}
        # 输入用户名及密码
        username = input("username>>>").strip()
        password = input("password>>>").strip()
        for item in info:
            if item["username"] == username and item["password"] == password:                   # 登陆成功
                return {"status": 0, "msg": "欢迎%s登陆" % username, "username": username}
        else:
            print("用户名或密码错误!请重新输入")


def output_info(user_info):
    """
    打印个人信息
    :param user_info: 某个用户的个人信息
    :return:
    """
    print("USER INFO".center(50, "-"))
    for k, v in user_info.items():
        print("%18s: %s" % (k, v))
    print("END".center(50, "-"))
    return


def change_info(user_info):
    """
    修改个人信息
    :param user_info: 某个用户的个人信息
    :return:
    """
    print("选择你要修改的个人信息: ")
    dic = {}
    for index, item in enumerate(user_info.keys()):         # 输出个人信息及选项，并将个人信息和选项捆绑
        if item == "user_id":
            continue
        print("%s: %s" % (index+1, item))
        dic[str(index+1)] = item
    choice = input("输入选项>>>").strip()
    change = input("输入修改后的值>>>").strip()
    user_info[dic[str(choice)]] = change                    # 修改信息
    write_info(user_info)                                   # 修改后的信息写入文件
    return


def change_pwd(user_info):
    """
    修改用户的密码
    :param user_info: 某个用户的个人信息
    :return:
    """
    retry_times = 0                                         # 最多允许尝试3次
    while True:
        retry_times += 1
        pwd = input("输入修改后的密码: ").strip()
        pwd_again = input("再次输入密码: ").strip()
        if pwd == pwd_again:
            user_info["password"] = pwd
            write_info(user_info)                           # 将修改后的数据写入文件
            print("两次输入密码相符，修改成功")
            return
        else:
            print("两次密码输入不符，请重新输入密码")


def controller(all_info, username):
    """
    功能分发器
    :param all_info: 所有用户信息
    :param username:  登陆用户的用户名
    :return:
    """
    user_data = {}                          # 登陆用户的个人信息
    menus = [                               # 功能菜单
        ("修改个人信息", change_info),
        ("输出个人信息", output_info),
        ("修改密码", change_pwd),
        ("退出系统", 0),
    ]
    for item in all_info:                   # 根据用户名找到某个用户的用户信息
        if item["username"] == username:
            user_data = item
    while True:
        for index, item in enumerate(menus):    # 输出功能菜单
            print(index + 1, item[0])
        choice = input("请输入序号选择功能>>>")
        if choice.isdigit():
            choice = int(choice)
            if 1 <= choice < len(menus):
                # 调用相应的功能函数
                menus[choice-1][1](user_data)
            elif choice == len(menus):
                exit("退出系统")
        if not choice:
            continue


def entrance():
    """
    程序主入口
    :return:
    """
    details = get_info()                # 获取所有数据
    res = login(details)                # 调用登陆接口    
    username = ""
    if res["status"] == 0:              # 成功登陆
        username = res["username"]      # 获取登陆的用户的用户名
        print(res["msg"])
    else:                               # 登陆失败
        print(res)
        exit()
    controller(details, username)       # 调用功能分发器


if __name__ == '__main__':
    entrance()

 

 

 

二、员工信息增删改查

需求：

 

实现:

这个题说白了就算麻烦，用笨办法也可以做出来，以下代码是我个人的实现，不同的人有不同的理解，实现也许有不同

整体思路: 在文件中存储员工信息，一个函数读取所有员工信息，并只在程序启动时读取，输入命令后根据不同命令调用不同函数来处理，如果命令是修改或增加或删除，在执行命令后将修改后的员工信息写入文件中

 

文件结构:

1,Alex Li,22,13651054608,IT,2013-04-01
2,wyb,20,15698704367,CTO,2016-8-9
3,tim,26,18945312218,HR,2015-9-3
4,Eric,30,18796342152,IT,2012-4-6
5,rachel,32,15367833458,Market,2013-9-3
6,jack,22,18398035682,HR,2016-7-6

 

测试命令:

find:
    find * from staff_table
    find name,age from staff_table
    find name,age from staff_table where age > 22
    find * from staff_table where dept = "IT"
    find * from staff_table where enroll_date like "2013"

add:
    add staff_table Alex Li,25,13651054608,IT,2016-7-8
    add staff_table Alex Li,25,13444679873,IT,2016-7-8
    add staff_table woz,20,13594372910,IT,2016-9-1

del:
    del from staff_table where id=3
    del from staff_table where id=13

update:
    update staff_table set dept = "market" where dept = "IT"
    update staff_table set age = 25 where name = "Alex Li"

 

输入命令并进行相关处理:

# 根据命令选择相应函数
def chose_command(commands):
    command = commands[0]
    if command == "find":
        find(commands)
    if command == "add":
        add(commands)
    if command == "del":
        delete(commands)
    if command == "update":
        update(commands)


# 输入命令并进行相关处理
def input_command():
    while True:
        command = input("请输入与增删改查相关命令(q或exit退出程序): ")
        # 退出程序
        if command == "exit" or command == "q":
            exit()
        # 将字母统一转换成小写
        order = ""
        for i in range(len(command)):
            if command[i].isalpha():
                order += command[i].lower()
            else:
                order += command[i]
        command = order
        # 分割字符串
        command = command.split()
        orders = ["find", "del", "add", "update"]
        # 确保命令的首个单词正确
        if command[0] not in orders:
            print("请输入正确的命令!")
            continue
        # 选择命令
        chose_command(command)

 

查找及修改:

# 输出查找及修改结果
def output_result(res, flag):
    print("一共%s了%d条数据" % (flag, len(res)))
    if len(res) != 0:
        print("%s如下:" % flag)
    for s in res:
        print(s)


def find_condition(rows, choice):
    # 存储符合条件的行
    res = []
    c1, c2, c3 = choice[0], choice[1], choice[2]
    # 处理c3
    if c3.isdigit():
        c3 = int(c3)
    else:
        c3 = c3.strip("\"")
        # print(c3)
    if c2 == "=":
        for row in rows:
            item = str(row[c1])
            # 数字
            if item.isdigit():
                if int(item) == c3:
                    res.append(row)
            # 字符串
            elif item.lower() == c3:
                res.append(row)
    if c2 == ">":
        for row in rows:
            if row[c1] > c3:
                res.append(row)
    if c2 == ">=":
        for row in rows:
            if row[c1] >= c3:
                res.append(row)
    if c2 == "<":
        for row in rows:
            if row[c1] < c3:
                res.append(row)
    if c2 == "<=":
        for row in rows:
            if row[c1] <= c3:
                res.append(row)
    if c2 == "like":
        for row in rows:
            if c3 in row[c1]:
                res.append(row)
    output_result(res, "查找")


def find(commands):
    # find * from staff_table
    # find name,age from staff_table
    if len(commands) == 4:
        # 列
        column = commands[1]
        # 表
        table = commands[3]
        models = tables[table]
        if column == '*':
            output_result(models, "查找")           # 输出结果
        else:
            res = []                        # 存储选择的列
            columns = column.split(',')     # 选择的列
            # 提取选择的列
            for model in models:
                res_dict = {}
                for item in columns:
                    res_dict[item] = model[item]
                res.append(res_dict)
            output_result(res, "查找")              # 输出结果
    # find name,age from staff_table where age > 22
    # find * from staff_table where dept = "IT"
    # find * from staff_table where enroll_date like "2013"
    elif len(commands) == 8:
        column, table = commands[1], commands[3]        # 列名和表名
        choice = commands[-3::1]                        # 筛选条件
        # print(column, table, chose1, chose2, chose3)
        # 表
        models = tables[table]
        if column == '*':
            find_condition(models, choice)      # 根据条件查找
        else:
            res = []                            # 存储选择的列
            columns = column.split(',')         # 选择的列
            # 提取选择的列
            for model in models:
                res_dict = {}
                for item in columns:
                    res_dict[item] = model[item]
                res.append(res_dict)
            find_condition(res, choice)     # 根据条件查找

def update(commands):
    # update staff_table set dept = "market" where dept = "IT"
    # update staff_table set age = 25 where name = "Alex Li"
    res = []            # 存储修改过的行
    # 表
    table = commands[1]
    models = tables[table]
    condition = commands[7::]               # 选择行的条件
    change = (commands[3], commands[5])     # 要修改的键以及其对应值
    # 处理条件
    if condition[0] == "id":
        print("不能修改id!")
        return
    if len(condition) == 3:
        if condition[2].isdigit():
            condition[2] = int(condition[2])
        else:
            condition[2] = condition[2].strip("\"")
    if len(condition) == 4:
        condition[2] = condition[2] + " " + condition[3]
        condition[2] = condition[2].strip("\"")
    # print(condition)
    # 根据条件选择表中的行
    for index in range(len(models)):
        dic = models[index][condition[0]]
        if str(dic).lower() == condition[2]:
            res.append(models[index])
    # 修改相应的值
    for index in range(len(res)):
        value = change[1]           # 要修改的值
        if value.isdigit():
            value = int(value)
        else:
            value = value.strip("\"")
        res[index][change[0]] = value
    # 输出修改结果
    output_result(res, "修改")
    # 将修改结果存入文件中(根据id值将修改后的行赋给表中的行)
    for i in range(len(models)):
        for item in res:
            mid = models[i]["id"]
            if mid == item["id"]:
                models[i] = item
    write_info(models)

 

删除及增加:

def add(commands):
    # add staff_table Alex Li,25,13444679873,IT,2016-7-8
    # add staff_table woz,20,13594372910,IT,2016-9-1
    # 表
    table = commands[1]
    models = tables[table]
    # 待添加的员工信息
    add_details = commands[2:]
    details = []
    # 处理数据
    if len(add_details) == 1:
        details = add_details[0].split(',')
    if len(add_details) == 2:
        details = add_details[1].split(',')
        details[0] = add_details[0] + " " + details[0]
    # print(models)
    # print(details[3])
    # 判断员工信息是否可以添加进表
    if details[2] not in tels:
        print("新增一条员工信息")
    else:
        print("电话号重复,无法新增员工信息!")
        return
    # 获取id值
    aid = models[-1]["id"] + 1
    # 将可添加的员工信息加入新字典中
    new_dict = {}
    new_dict.update(id=aid, name=details[0], age=int(details[1]), tel=details[2], dept=details[3], enroll_date=details[4])
    # 将新字典加入表中
    models.append(new_dict)
    # 写入数据
    write_info(models)

def delete(commands):
    # del from staff_table where id=3
    # del from staff_table where id=13
    # 表
    table = commands[2]
    models = tables[table]
    # 选择条件
    condition = commands[-1]
    # print(table, condition)     # 表名和条件
    if "=" in condition:
        conditions = condition.split('=')
        # print(conditions)
        for index in range(len(models)):
            if models[index]["id"] == int(conditions[1]):
                print("删除一条员工信息,删除信息如下:")
                print(models[index])
                del models[index]
                break
        else:
            print("请输入正确的del命令!")
            return
        write_info(models)
    else:
        print("请输入正确的del命令!")
        return

 

文件读取及写入:

# 表结构: tables -> staff_table -> employee_detail
# 全局变量:
tables = {}
tels = []       # 字符串存储员工的电话号


# 获取员工信息
def get_info():
    with open("employee_info.txt", 'r', encoding="utf-8") as f:
        # staff_table存储多行员工信息，每一行的员工信息存在字典中
        staff_table = []
        # 读取每一行的数据存入列表中
        details = f.readlines()
        # 遍历列表将每一行的数据分开并将一行的数据作为一个字典存入info列表中
        for detail in details:
            employee_detail = {}
            detail = detail.strip()
            items = detail.split(',')
            # 去掉开头和结尾的空白
            for i in range(len(items)):
                items[i] = items[i].strip()
            # 将一条员工信息存入字典
            employee_detail.update(id=int(items[0]), name=items[1], age=int(items[2]), tel=items[3], dept=items[4], enroll_date=items[5])
            tels.append(items[3])
            staff_table.append(employee_detail)
        tables.update(staff_table=staff_table)
        # print(tables)
        # print(tables["staff_table"])


# 将员工信息写入文件中
def write_info(models):
    with open("employee_info.txt", "w", encoding="utf-8") as f:
        for model in models:
            f.write(str(model["id"]) + "," + model["name"] + "," + str(model["age"]) + ",")
            f.write(model["tel"] + "," + model["dept"] + "," + model["enroll_date"] + "\n")

 

全部代码:

# __author__ = "wyb"
# date: 2018/4/22

# 表结构: tables -> staff_table -> employee_detail
tables = {}
tels = []       # 字符串存储员工的电话号


# 获取员工信息
def get_info():
    with open("employee_info.txt", 'r', encoding="utf-8") as f:
        # staff_table存储多行员工信息，每一行的员工信息存在字典中
        staff_table = []
        # 读取每一行的数据存入列表中
        details = f.readlines()
        # 遍历列表将每一行的数据分开并将一行的数据作为一个字典存入info列表中
        for detail in details:
            employee_detail = {}
            detail = detail.strip()
            items = detail.split(',')
            # 去掉开头和结尾的空白
            for i in range(len(items)):
                items[i] = items[i].strip()
            # 将一条员工信息存入字典
            employee_detail.update(id=int(items[0]), name=items[1], age=int(items[2]), tel=items[3], dept=items[4], enroll_date=items[5])
            tels.append(items[3])
            staff_table.append(employee_detail)
        tables.update(staff_table=staff_table)
        # print(tables)
        # print(tables["staff_table"])


# 将员工信息写入文件中
def write_info(models):
    with open("employee_info.txt", "w", encoding="utf-8") as f:
        for model in models:
            f.write(str(model["id"]) + "," + model["name"] + "," + str(model["age"]) + ",")
            f.write(model["tel"] + "," + model["dept"] + "," + model["enroll_date"] + "\n")


# 输出查询及修改结果
def output_result(res, flag):
    print("一共%s了%d条数据" % (flag, len(res)))
    if len(res) != 0:
        print("%s如下:" % flag)
    for s in res:
        print(s)


def find_condition(rows, choice):
    # 存储符合条件的行
    res = []
    c1, c2, c3 = choice[0], choice[1], choice[2]
    # 处理c3
    if c3.isdigit():
        c3 = int(c3)
    else:
        c3 = c3.strip("\"")
        # print(c3)
    if c2 == "=":
        for row in rows:
            item = str(row[c1])
            # 数字
            if item.isdigit():
                if int(item) == c3:
                    res.append(row)
            # 字符串
            elif item.lower() == c3:
                res.append(row)
    if c2 == ">":
        for row in rows:
            if row[c1] > c3:
                res.append(row)
    if c2 == ">=":
        for row in rows:
            if row[c1] >= c3:
                res.append(row)
    if c2 == "<":
        for row in rows:
            if row[c1] < c3:
                res.append(row)
    if c2 == "<=":
        for row in rows:
            if row[c1] <= c3:
                res.append(row)
    if c2 == "like":
        for row in rows:
            if c3 in row[c1]:
                res.append(row)
    output_result(res, "查找")


def find(commands):
    # find * from staff_table
    # find name,age from staff_table
    if len(commands) == 4:
        # 列
        column = commands[1]
        # 表
        table = commands[3]
        models = tables[table]
        if column == '*':
            output_result(models, "查找")           # 输出结果
        else:
            res = []                        # 存储选择的列
            columns = column.split(',')     # 选择的列
            # 提取选择的列
            for model in models:
                res_dict = {}
                for item in columns:
                    res_dict[item] = model[item]
                res.append(res_dict)
            output_result(res, "查找")              # 输出结果
    # find name,age from staff_table where age > 22
    # find * from staff_table where dept = "IT"
    # find * from staff_table where enroll_date like "2013"
    elif len(commands) == 8:
        column, table = commands[1], commands[3]        # 列名和表名
        choice = commands[-3::1]                        # 筛选条件
        # print(column, table, chose1, chose2, chose3)
        # 表
        models = tables[table]
        if column == '*':
            find_condition(models, choice)      # 根据条件查找
        else:
            res = []                            # 存储选择的列
            columns = column.split(',')         # 选择的列
            # 提取选择的列
            for model in models:
                res_dict = {}
                for item in columns:
                    res_dict[item] = model[item]
                res.append(res_dict)
            find_condition(res, choice)     # 根据条件查找


def add(commands):
    # add staff_table Alex Li,25,13444679873,IT,2016-7-8
    # add staff_table woz,20,13594372910,IT,2016-9-1
    # 表
    table = commands[1]
    models = tables[table]
    # 待添加的员工信息
    add_details = commands[2:]
    details = []
    # 处理数据
    if len(add_details) == 1:
        details = add_details[0].split(',')
    if len(add_details) == 2:
        details = add_details[1].split(',')
        details[0] = add_details[0] + " " + details[0]
    # print(models)
    # print(details[3])
    # 判断员工信息是否可以添加进表
    if details[2] not in tels:
        print("新增一条员工信息")
    else:
        print("电话号重复,无法新增员工信息!")
        return
    # 获取id值
    aid = models[-1]["id"] + 1
    # 将可添加的员工信息加入新字典中
    new_dict = {}
    new_dict.update(id=aid, name=details[0], age=int(details[1]), tel=details[2], dept=details[3], enroll_date=details[4])
    # 将新字典加入表中
    models.append(new_dict)
    # 写入数据
    write_info(models)


def delete(commands):
    # del from staff_table where id=3
    # del from staff_table where id=13
    # 表
    table = commands[2]
    models = tables[table]
    # 选择条件
    condition = commands[-1]
    # print(table, condition)     # 表名和条件
    if "=" in condition:
        conditions = condition.split('=')
        # print(conditions)
        for index in range(len(models)):
            if models[index]["id"] == int(conditions[1]):
                print("删除一条员工信息,删除信息如下:")
                print(models[index])
                del models[index]
                break
        else:
            print("请输入正确的del命令!")
            return
        write_info(models)
    else:
        print("请输入正确的del命令!")
        return


def update(commands):
    # update staff_table set dept = "market" where dept = "IT"
    # update staff_table set age = 25 where name = "Alex Li"
    res = []            # 存储修改过的行
    # 表
    table = commands[1]
    models = tables[table]
    condition = commands[7::]               # 选择行的条件
    change = (commands[3], commands[5])     # 要修改的键以及其对应值
    # 处理条件
    if condition[0] == "id":
        print("不能修改id!")
        return
    if len(condition) == 3:
        if condition[2].isdigit():
            condition[2] = int(condition[2])
        else:
            condition[2] = condition[2].strip("\"")
    if len(condition) == 4:
        condition[2] = condition[2] + " " + condition[3]
        condition[2] = condition[2].strip("\"")
    # print(condition)
    # 根据条件选择表中的行
    for index in range(len(models)):
        dic = models[index][condition[0]]
        if str(dic).lower() == condition[2]:
            res.append(models[index])
    # 修改相应的值
    for index in range(len(res)):
        value = change[1]           # 要修改的值
        if value.isdigit():
            value = int(value)
        else:
            value = value.strip("\"")
        res[index][change[0]] = value
    # 输出修改结果
    output_result(res, "修改")
    # 将修改结果存入文件中(根据id值将修改后的行赋给表中的行)
    for i in range(len(models)):
        for item in res:
            mid = models[i]["id"]
            if mid == item["id"]:
                models[i] = item
    write_info(models)


# 根据命令选择相应函数
def chose_command(commands):
    command = commands[0]
    if command == "find":
        find(commands)
    if command == "add":
        add(commands)
    if command == "del":
        delete(commands)
    if command == "update":
        update(commands)


# 输入命令并进行相关处理
def input_command():
    while True:
        command = input("请输入与增删改查相关命令(q或exit退出程序): ")
        # 退出程序
        if command == "exit" or command == "q":
            exit()
        # 将字母统一转换成小写
        order = ""
        for i in range(len(command)):
            if command[i].isalpha():
                order += command[i].lower()
            else:
                order += command[i]
        command = order
        # 分割字符串
        command = command.split()
        orders = ["find", "del", "add", "update"]
        # 确保命令的首个单词正确
        if command[0] not in orders:
            print("请输入正确的命令!")
            continue
        # 选择命令
        chose_command(command)


if __name__ == '__main__':
    get_info()
    input_command()