python做数据库管理系统_Python基于mysql实现学⽣管理系
统
Python基于mysql实现学⽣管理系统
来源：中⽂源码⽹ 浏览： 次 ⽇期：2019年11⽉5⽇
【下载⽂档: Python基于mysql实现学⽣管理系统.txt 】
(友情提⽰：右键点上⾏txt⽂档名->⽬标另存为)
Python基于mysql实现学⽣管理系统本篇⽂章主要介绍了Python基于mysql实现学⽣管理系统，分享给⼤家，具体如下：
import pymysql
import re
def idinput(string):
ID = input(string)
pattern = repile("^\d{1,3}$")
while not re.match(pattern, ID):
ID = input("请输⼊1-3位整数:")
return ID
def appendStudentInfo():
ID =idinput("请输⼊学⽣学号：")
t(host="127.0.0.1",user="root",passwd="hisense",db="test",port=3306,charset="utf8")
cursor=db.cursor()
sql = "select * from StuSys where ID = '%s'" % ID
wcount > 0 :
ID = idinput("该学号已存在，请重新输⼊:")
sql = "select * from StuSys where ID = '%d'" % int(ID)
mysql帮助文档
name=input("请输⼊学⽣姓名：")
chinese=input("请输⼊语⽂成绩：")
while not chinese.isdigit() or int(chinese)>100 or int(chinese)<0:
chinese = input("输⼊错误，请重新输⼊：")
math =input("请输⼊数学成绩：")
while not math.isdigit() or int(math) > 100 or int(math) < 0:
math = input("输⼊错误，请重新输⼊：")
english=input("请输⼊英语成绩：")
while not english.isdigit() or int(english) > 100 or int(english) < 0:
english = input("输⼊错误，请重新输⼊：")
total=int(chinese)+int(math)+int(english)
sql="""INSERT INTO StuSys(ID,
NAME,CHINESE,ENGLISH,MATH,TOTAL)
VALUES (%s,%s,%s,%s,%s,%s)"""
dbmit()
db.close()
def delstudent():
delstudentid = idinput("请输⼊要删除的学⽣学号：")
if querystudent(delstudentid):
select = input("是否删除：是(Y)/否（N）")
if select == "Y" or select == "y":
db = t(host="127.0.0.1", user="root", passwd="hisense", db="test", port=3306, charset="utf8") cursor = db.cursor()
sql = "delete from stusys where ID =%s" %delstudentid
dbmit()
db.close()
print("删除成功")
elif select == "N" or select == "n":
print("取消删除")
else:
print("输⼊错误")
def querystudent(querystudentid):
t(host="127.0.0.1",user="root",passwd="hisense",db="test",port=3306,charset="utf8") cursor=db.cursor()
sql="select * from stusys where ID=%s"%querystudentid
wcount ==0 :
print("不存在该学⽣信息")
return False
else:
print("该学⽣信息如下：")
results =cursor.fetchall()
print("ID=%d,NAME=%s,CHINESE=%d,ENGLISH=%d,MATH=%d,TOTAL=%d" % \
(results[0][0], results[0][1], results[0][2], results[0][3], results[0][4],results[0][5]))
return True
def modifystudentifo():
modifyid = idinput("请输⼊要的学⽣学号：")
if querystudent(modifyid):
name = input("请重新输⼊学⽣姓名：")
chinese = input("请重新输⼊语⽂成绩：")
while not chinese.isdigit() or int(chinese) > 100 or int(chinese) < 0:
chinese = input("输⼊错误，请重新输⼊：")
math = input("请重新输⼊数学成绩：")
while not math.isdigit() or int(math) > 100 or int(math) < 0:
math = input("输⼊错误，请重新输⼊：")
english = input("请重新输⼊英语成绩：")
while not english.isdigit() or int(english) > 100 or int(english) < 0:
english = input("输⼊错误，请重新输⼊：")
total = int(chinese) + int(math) + int(english)
db = t(host="127.0.0.1", user="root", passwd="hisense", db="test", port=3306, charset="utf8") cursor = db.cursor()
sql1="update stusys set name ='%s' where id = %s"%(name,modifyid)
sql2="update stusys set math = %s where id = %s"%(math,modifyid)
sql3 = "update stusys set english = %s where id =%s"%(english,modifyid)
sql4 = "update stusys set total = %s where id = %s"%(total,modifyid)
sql5 = "update stusys set chinese = %s where id = %s"%(chinese,modifyid)
dbmit()
db.close()
def allinfo():
t(host="127.0.0.1",user="root",passwd="hisense",db="test",port=3306,charset="utf8") cursor=db.cursor()
sql="select * from stusys"
results= cursor.fetchall()
for row in results:
ID = row[0]
NAME = row[1]
CHINESE = row[2]
ENGLISH = row[3]
MATH = row[4]
TOTAL = row[5]
# 打印结果
print("ID=%d,NAME=%s,CHINESE=%d,ENGLISH=%d,MATH=%d,TOTAL=%d" % \
(ID, NAME, CHINESE, ENGLISH, MATH,TOTAL))
def studentMenu():
print("="*30)
print("学⽣管理系统")
print("1、添加学⽣信息")
print("2、删除学⽣信息")
print("3、查询学⽣信息")
print("4、修改学⽣信息")
print("5、全部学⽣信息")
print("6、退出")
print("="*30)
if __name__ == '__main__':
while True:
studentMenu()
menuindex = input("请输⼊选项序号：")
while not menuindex.isdigit():
menuindex = input("输⼊错误，请重新输⼊：")
if int(menuindex) ==1:
appendStudentInfo()
elif int(menuindex) ==2:
delstudent()
elif int(menuindex) ==3:
querystudentid = idinput("请输⼊要查询的学⽣学号：")
querystudent(querystudentid)
elif int(menuindex) ==4:
modifystudentifo()
elif int(menuindex) == 5:
allinfo()
elif int(menuindex) == 6:
break
else:
print("输⼊序号⽆效")以上就是本⽂的全部内容，希望对⼤家的学习有所帮助，也希望⼤家多多⽀持中⽂源码⽹。亲，试试扫码分享本页! *^_^*

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。