关于二级网站建设,2008vps做网站,wordpress 页眉修改,薇晓朵 wordpress 下载数据库表 Python代码部分
import pymysqlclass StMgmt(object):def tips(self):提示用户选择的操作print(学生管理系统 1.01.查看所有信息2.查看学生信息3.修改学生信息4.增加学生信息5.退出学生系统提示用户选择的操作print(学生管理系统 1.01.查看所有信息2.查看学生信息3.修改学生信息4.增加学生信息5.退出学生系统)def connect_base(self):连接数据库并返回连接和游标base pymysql.connect(hostlocalhost, port3306, dbmiaosi, userroot, password123456)cursor base.cursor()return base, cursordef view_all(self):查询所有学生信息base, cursor self.connect_base()try:cursor.execute(SELECT * FROM pupildata)back_data cursor.fetchall()for line in back_data:print(line)finally:base.close()def search_data(self):查询学生信息base, cursor self.connect_base()try:user_name input(请输入需要查找的学生姓名: )cursor.execute(SELECT * FROM pupildata WHERE name LIKE %s, (user_name,))back_data cursor.fetchall()if back_data:for data in back_data:print(data)else:print(没有该学生)finally:base.close()def add_data(self):增加学生信息base, cursor self.connect_base()try:user_id int(input(请输入学号: ))user_name input(请输入姓名: )user_sex input(请输入性别: )user_age int(input(请输入年龄: ))user_birthday input(请输入生日(xxxx-xx-xx): )user_phone int(input(请输入手机号: ))user_address input(请输入地址: )cursor.execute(INSERT INTO pupildata VALUES (%s, %s, %s, %s, %s, %s, %s),(user_id, user_name, user_sex, user_age, user_birthday, user_phone, user_address))base.commit()self.search_data(user_name)print(学生数据添加成功)finally:base.close()def edit_data(self):修改学生信息base, cursor self.connect_base()try:tips input(请输入要修改的学生姓名: )# 获取用户输入的新数据user_id int(input(请输入学号: ))user_name input(请输入姓名: )user_sex input(请输入性别: )user_age int(input(请输入年龄: ))user_birthday input(请输入生日(xxxx-xx-xx): )user_phone int(input(请输入手机号: ))user_address input(请输入地址: )# 修改数据cursor.execute(UPDATE pupildata SET id%s, name%s, sex%s, age%s, birthday%s, phone%s, address%s WHERE name %s,(user_id, user_name, user_sex, user_age, user_birthday, user_phone, user_address))base.commit()print(学生数据修改成功)finally:base.close()if __name__ __main__:miaows StMgmt()miaows.tips()while True:try:num int(input(请输入你的选项: ))if num 1:miaows.view_all()elif num 2:miaows.search_data()elif num 3:miaows.edit_data()elif num 4:miaows.add_data()elif num 5:print(成功退出系统)breakelse:print(无效的选项请重新输入。)except ValueError:print(输入错误请输入一个整数。)except Exception as e:print(f发生错误{e})
