基于PHP+MYSOL教务排课系统的设计与实现

php mysql课程设计一、教学目标本课程的教学目标是使学生掌握PHP和MySQL的基本知识和技能，能够使用PHP进行Web开发，并熟练使用MySQL进行数据库设计和查询。

具体来说，知识目标包括了解PHP的基本语法、函数、表单处理和会话管理等；技能目标包括能够编写简单的PHP程序，使用MySQL进行数据库设计和查询，以及解决常见的PHP和MySQL问题；情感态度价值观目标包括培养学生对编程和数据库技术的兴趣，提高学生解决问题的能力和创新意识。

二、教学内容根据课程目标，本课程的教学内容主要包括PHP和MySQL两个部分。

PHP部分包括基本语法、函数、表单处理、会话管理等；MySQL部分包括数据库设计、SQL查询、索引、备份等。

具体的教学大纲如下：1.PHP基本语法和函数2.PHP表单处理和会话管理3.MySQL基本操作和SQL查询4.数据库设计和索引5.PHP和MySQL的结合应用三、教学方法为了达到课程目标，本课程将采用多种教学方法，包括讲授法、讨论法、案例分析法和实验法等。

通过这些方法，激发学生的学习兴趣和主动性，提高学生的编程能力和解决问题的能力。

具体的教学方法如下：1.讲授法：用于讲解PHP和MySQL的基本概念和语法。

2.讨论法：用于讨论和解决学生在编程过程中遇到的问题。

3.案例分析法：通过分析实际案例，使学生掌握PHP和MySQL的应用技巧。

4.实验法：通过实验，让学生亲手编写PHP程序和操作MySQL数据库，提高学生的实际操作能力。

四、教学资源为了支持教学内容和教学方法的实施，本课程将选择和准备以下教学资源：1.教材：《PHP和MySQL入门经典》2.参考书：《PHP和MySQL编程实践》3.多媒体资料：教学PPT、视频教程等4.实验设备：计算机、网络设备、MySQL数据库服务器等通过以上教学资源，丰富学生的学习体验，提高学生的学习效果。

五、教学评估本课程的评估方式包括平时表现、作业和考试等。

python+mysql实现教务管理系统本⽂实例为⼤家分享了python实现教务管理系统，供⼤家参考，具体内容如下mysql+python构成教务管理系统，提供系统管理员，教职⼯，学⽣三级。

有注册，添加，修改，发布信息等功能。

Login.py#-*- coding:utf-8 -*-#####系统登录import osimport MySQLdbimport timeclass Login:def __init__(self,conn):self.account = ''self.password = ''self.level = 2self.conn = conndef LoginSurface(self,info):os.system('cls')width = 50title = 'LOGIN'body1 = '[A]Admin'body2 = '[T]Teacher'body3 = '[S]Student'body4 = '[Q]Quit'print '=' * widthprint ' ' * ((width-len(title))/2), titleprint ' ' * ((width-len(body1))/2),body1print ' ' * ((width-len(body1))/2),body2print ' ' * ((width-len(body1))/2),body3print ' ' * ((width-len(body1))/2),body4print ' ' * ((width-len(info))/2), infoprint '-' * widthdef MainFunc(self):err = ''while True:self.LoginSurface(err)level = raw_input('Access:')level = level.upper()if level == 'A':self.level = 0elif level == 'T': self.level = 1elif level == 'S': self.level = 2elif level =='Q': return Falseelse :err = 'Error Action!'continueself.account = raw_input('Account:')self.password = raw_input('Password:')if self.CheckAccount():err = 'Login Success!'self.LoginSurface(err)print 'Please wait...'time.sleep(3)return True;else :err = 'Login Failed!'def GetLoginAccount(self):return [self.account,self.password,self.level]def CheckAccount(self):cur = self.conn.cursor()sqlcmd = "select Account,Password,AccountLevel from LoginAccount where Account = '%s'" % self.accountif cur.execute(sqlcmd) == 0: return Falsetemp = cur.fetchone()cur.close()if temp[1] == self.password and temp[2] == self.level:return Trueelse: return Falsedef Quit(self):passif __name__ == '__main__':conn = MySQLdb.connect(user='root',passwd = '123456',db = 'test');a = Login(conn)a.MainFunc()a.Quit()conn.close()main.py#-*- coding:utf-8 -*-####系统⼊⼝import osimport MySQLdbimport Studentimport Teacherimport Loginimport SystemManagerif __name__ == '__main__':conn = MySQLdb.connect(user='root',passwd = '123456',db = 'test')log = Login.Login(conn)if log.MainFunc():account = log.GetLoginAccount()if account[2] == 0:usr = SystemManager.SystemManager(conn,account[0],account[1])usr.MainFunc()elif account[2] == 1:usr = Teacher.Teacher(conn,account[0],account[1])usr.MainFunc()elif account[2] == 2:usr = Student.Student(conn,account[0],account[1])usr.MainFunc()else :conn.close()raise exception()conn.close()Student.py#-*- coding:utf-8 -*-####学⽣账号import MySQLdbimport osclass Student:def __init__(self,conn,account,passwd):###构造,conn连接数据库cur = conn.cursor()sqlcmd = "select Name,Gender,Birth,Academy,Major,Grade,TeacherNo from StudentInfo where StudentNo = '%s'" % account cur.execute(sqlcmd)res = cur.fetchone()sqlcmd = "select Name from TeacherInfo where TeacherNo = '%s'" % res[6]cur.execute(sqlcmd)TeacherName = cur.fetchone()cur.close()self.width = 150self.conn = connself.account = accountself.Password= passwd = res[0]self.Gender = res[1]self.Birth = res[2]self.Accademy= res[3]self.Major = res[4]self.Grade = res[5]self.Teacher = TeacherName[0]def MainFunc(self):###主要执⾏函数info = ''while True:self.MainSurface(info)choice = raw_input('What to do?')choice = choice.upper()if choice != 'P' and choice != 'M' and choice != 'Q':info = 'Error Action!'continueif choice == 'P':info = self.PersonalInfo()elif choice == 'M':info = self.OperatMessage()else : breakdef PersonalInfo(self):###个⼈信息info = ''while True:self.PersonalInfoSurface(info)choice = raw_input('What to do?')choice = choice.upper()if choice != 'C' and choice != 'Q':info = 'Error Action!'continueif choice == 'C':info = self.ChangePersonalInfo()else : breakreturn infodef ChangePersonalInfo(self):###修改个⼈信息NewGender = self.GenderNewBirth = self.BirthNewPw = self.Passwordwhile True:choice = raw_input('Change Gender?(y/n)')choice = choice.lower()if choice == 'y':NewGender = raw_input('New Gender:')breakelif choice == 'n': breakelse : passwhile True:choice = raw_input('change Born Date?(y/n)')choice = choice.lower()if choice == 'y':NewBirth = raw_input('New Born Date:')breakelif choice == 'n': breakelse : passwhile True:choice = raw_input('change Password?(y/n)')choice = choice.lower()if choice == 'y':NewPw = raw_input('New Password:')breakelif choice == 'n': breakelse : passinfo = 'Change Success!'cur = self.conn.cursor()if NewGender != self.Gender or NewBirth != self.Birth:sqlcmd = "update StudentInfo set Gender = '%s',Birth = '%s' where StudentNo = '%s'" % (NewGender,NewBirth,self.account) if cur.execute(sqlcmd) == 0:self.conn.rollback()cur.close()return 'Change Fail!'if NewPw != self.Password:sqlcmd = "update LoginAccount set Password = '%s' where Account='%s'" % (NewPw,self.account)if cur.execute(sqlcmd) == 0:self.conn.rollback()cur.close()return 'Change Fail!'else :mit()self.Gender = NewGenderself.Birth = NewBirthself.Password = NewPwcur.close()return 'Change Success!'def OperatMessage(self):info = ''while True:self.MessageSurface(info)self.MessageList()choice = raw_input('What to do?')choice = choice.upper()if choice == 'M':msg = input('Message Id:')info = self.MessageInfo(msg)elif choice == 'Q': break;else : info = 'Error Action!'return infodef MessageList(self):###查看消息列表cur = self.conn.cursor()print ''sqlcmd = "select Id,SenderName,SendTime,Title from AllMessage where statu = 'pass' and MsgLevel = 1" if cur.execute(sqlcmd) == 0: returnprint '-' * self.widthwhile True:temp = cur.fetchone()if not temp: break;print '%3d%-20s%-50s%s' % (temp[0],temp[1],temp[3],temp[2])print '-' * self.widthcur.close()def MessageInfo(self,MsgNo):###查看详细消息, No消息编号cur = self.conn.cursor()sqlcmd = "select SenderName,SendTime,Title,Content from AllMessage where Id = %d" % MsgNoif cur.execute(sqlcmd) == 0:cur.close()return 'Read Fail!'article = cur.fetchone()cur.close()os.system('cls')print '=' * self.widthprint ' ' * ((self.width - len(article[2]))/2) , article[2]head = article[0] + ' ' + str(article[1])print ' ' * ((self.width - len(head))/2) , headprint '-' * self.widthprint article[3]print '=' * self.widthraw_input('Press any key to return!')return ''def Quit(self):###退出passdef MainSurface(self,info):###主界⾯os.system('cls')print '=' * self.widthtitle = 'Welcome %s!' % body1 = '[P]Personal Information'body2 = '[M]Message'body3 = '[Q]Quit'print ' ' * ((self.width - len(title))/2),titleprint ' ' * ((self.width - len(body1))/2),body1print ' ' * ((self.width - len(body1))/2),body2print ' ' * ((self.width - len(body1))/2),body3print ' ' * ((self.width - len(info))/2),infoprint '=' * self.widthdef MessageSurface(self,info):###消息界⾯os.system('cls')print '=' * self.widthtitle = 'MESSAGES'body1 = '[M]Message Detail'body2 = '[Q]Quit'print ' ' * ((self.width - len(title))/2),titleprint ' ' * ((self.width - len(body1))/2),body1print ' ' * ((self.width - len(body1))/2),body2print ' ' * ((self.width - len(info))/2),infoprint '=' * self.widthdef PersonalInfoSurface(self,info):###个⼈信息界⾯os.system('cls')print '=' * self.widthtitle = 'PERSONAL INFORMATION'body1 = '[C]Change Information'body2 = '[Q]Quit'print ' ' * ((self.width - len(title))/2),titleprint ' ' * ((self.width - len(body1))/2),body1print ' ' * ((self.width - len(body1))/2),body2print ' ' * ((self.width - len(info))/2),infoprint '-' * self.widthbody3 = ' Name: %s' % body4 = 'Student Number: %s' % self.accountbody5 = ' Gender: %s' % self.Genderbody6 = ' Birth: %s' % self.Birthbody7 = ' Accademy: %s' % self.Accademybody8 = ' Major: %s' % self.Majorbody9 = ' Grade: %s' % self.Gradebody10= ' Teacher: %s' % self.Teacherprint ' ' * ((self.width - len(body6))/2),body3print ' ' * ((self.width - len(body6))/2),body4print ' ' * ((self.width - len(body6))/2),body5print ' ' * ((self.width - len(body6))/2),body6print ' ' * ((self.width - len(body6))/2),body7print ' ' * ((self.width - len(body6))/2),body8print ' ' * ((self.width - len(body6))/2),body9print ' ' * ((self.width - len(body6))/2),body10print '=' * self.widthif __name__ == '__main__':conn = MySQLdb.connect(user='root',passwd = '123456',db = 'test')stu = Student(conn,'0000001','123456')stu.MainFunc()conn.close()完整代码请点击下载：以上就是本⽂的全部内容，希望对⼤家的学习有所帮助，也希望⼤家多多⽀持。