python基于mysql的学生_Python基于mysql实现学生管理系统

import pymysql

import re

def idinput(string):

ID = input(string)

pattern = re.compile("^\d{1,3}$")

while not re.match(pattern, ID):

ID = input("请输入1-3位整数:")

return ID

def appendStudentInfo():

ID =idinput("请输入学生学号：")

db=pymysql.connect(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

cursor.execute(sql)

while cursor.rowcount > 0 :

ID = idinput("该学号已存在，请重新输入:")

sql = "select * from StuSys where ID = '%d'" % int(ID)

cursor.execute(sql)

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("请输入英语成绩：")