用Java与SQL-Server做的学生管理系统

theessenceofthesocialistconceptofruleoflawleadingqualityconnotation,fortheuseofthesocialistlawcomprehensiveconcepttoguidetheirworkandtheimportanceoflearningshouldalsolackthenecessaryunderstanding.Twoisthebusinessfoundationisnotsolid,thetextlevelisnothigh.Theirworkinthearmybefore,althoughtheunderstandingofthematerial,butalsojustonlyknowfur,textlevel,writingabilityisstillinalowlevelinterface.Theknowledgeisnotcomplete,especiallyitisverylittleaboutprofessionalsomedepartmentsknowknowledgewritesomesimplebriefing.Otherworkisnotenough,andleadershipThereisaconsiderablegapbetweentherequirements.Andintheencounterthetediouswork,complexthings,sometimestakethemethodofescape,thatbridgetheboattothebridgestraight,nottheirownforcepleasefindcountermeasures,buttowaitfortheself,thelackofaspiritofhardresearch.Two,theIn1944,theamountssentoutinformation,wasarrestedbytheelves,sufferedtorture,heroicandunyielding,andkilledbytheenemy.ThefiveCommunistswho,front-lineeliteZhuZhu(1909-1996),QingShuiXiangFuCun,Shangrao中北大学数据库原理课程设计说明书2013年6月27日学生姓名:武大为学号：11060342X37学生姓名:李力钊学号：11060342X28学生姓名:周荣祥学号：11060342X20学生姓名:南子锐学号：11060342X44学院:信息商务学院专业:计算机科学与技术题目:学生学籍管理系统指导教师武瑞娟theessenceofthesocialistconceptofruleoflawleadingqualityconnotation,fortheuseofthesocialistlawcomprehensiveconcepttoguidetheirworkandtheimportanceoflearningshouldalsolackthenecessaryunderstanding.Twoisthebusinessfoundationisnotsolid,thetextlevelisnothigh.Theirworkinthearmybefore,althoughtheunderstandingofthematerial,butalsojustonlyknowfur,textlevel,writingabilityisstillinalowlevelinterface.Theknowledgeisnotcomplete,especiallyitisverylittleaboutprofessionalsomedepartmentsknowknowledgewritesomesimplebriefing.Otherworkisnotenough,andleadershipThereisaconsiderablegapbetweentherequirements.Andintheencounterthetediouswork,complexthings,sometimestakethemethodofescape,thatbridgetheboattothebridgestraight,nottheirownforcepleasefindcountermeasures,buttowaitfortheself,thelackofaspiritofhardresearch.Two,theIn1944,theamountssentoutinformation,wasarrestedbytheelves,sufferedtorture,heroicandunyielding,andkilledbytheenemy.ThefiveCommunistswho,front-lineeliteZhuZhu(1909-1996),QingShuiXiangFuCun,Shangrao1设计目的：按照关系型数据库的基本原理，综合运用所学的知识，以小组为单位，设计开发一个小型的学生学籍管理系统。通过对一个实际问题的分析、设计与实现，将原理与应用相结合，使学生学会如何把书本上学到的知识用于解决实际问题，培养学生的动手能力；另一方面，使学生能深入理解和灵活掌握教学内容。2设计内容：设计内容：设计如下主要功能模块1)实现学生基本情况的录入、修改、删除等基本操作。2)对学生基本信息提供灵活的查询方式。3)完成一个班级的学期选课功能。4)实现学生成绩的录入、修改、删除等基本操作。5)能方便的对学生的一个学期成绩进行查询。6)具有成绩统计、排名等功能。7)具有留级、休学等特殊情况的处理功能。8)能输出常用的各种报表。9)具有数据备份和数据恢复功能。设计要求：学生成绩表的设计，要考虑到不同年级的教学计划的变化情况。对于新生班级，应该首先进行基本情况录入、选课、然后才能进行成绩录入。3．功能模块详细设计3.1详细设计思想这个学生管理系统，我们组用Java的JDK1.6开发工具和微软的MicrosoftSQLServer数据库两者相结合做出来的。一数据库的设计：theessenceofthesocialistconceptofruleoflawleadingqualityconnotation,fortheuseofthesocialistlawcomprehensiveconcepttoguidetheirworkandtheimportanceoflearningshouldalsolackthenecessaryunderstanding.Twoisthebusinessfoundationisnotsolid,thetextlevelisnothigh.Theirworkinthearmybefore,althoughtheunderstandingofthematerial,butalsojustonlyknowfur,textlevel,writingabilityisstillinalowlevelinterface.Theknowledgeisnotcomplete,especiallyitisverylittleaboutprofessionalsomedepartmentsknowknowledgewritesomesimplebriefing.Otherworkisnotenough,andleadershipThereisaconsiderablegapbetweentherequirements.Andintheencounterthetediouswork,complexthings,sometimestakethemethodofescape,thatbridgetheboattothebridgestraight,nottheirownforcepleasefindcountermeasures,buttowaitfortheself,thelackofaspiritofhardresearch.Two,theIn1944,theamountssentoutinformation,wasarrestedbytheelves,sufferedtorture,heroicandunyielding,andkilledbytheenemy.ThefiveCommunistswho,front-lineeliteZhuZhu(1909-1996),QingShuiXiangFuCun,Shangrao1创建数据库StudentManager图1.01.1创建表：ClassInfo图1.11.2创建表：DepartmentInfo图1.21.3创建表：StudentInfo图1.3二创建“数据源(ODBC)”具体步骤：“开始”-“控制面板”-“管理工具”-“数据源(ODBC)-在用户DNS里，点“添加”--在数据源驱动列表最下方选择“SQLServer”-点“完成”--出现了一个创建到SQLServer的新数据源-在数据源“名称”右侧，填写数据库的名称;在“服务器”右侧，写(local)-点“下一步”--继续点“下一步”-在更改默认的数据库为“StudentManager”，这里的数据库为我刚刚新建的数据库。-点“下一步”-点“完成”-出现一个“ODBCMicrosoftSQLServer安装”对话框-点击下面的“测试数据源”theessenceofthesocialistconceptofruleoflawleadingqualityconnotation,fortheuseofthesocialistlawcomprehensiveconcepttoguidetheirworkandtheimportanceoflearningshouldalsolackthenecessaryunderstanding.Twoisthebusinessfoundationisnotsolid,thetextlevelisnothigh.Theirworkinthearmybefore,althoughtheunderstandingofthematerial,butalsojustonlyknowfur,textlevel,writingabilityisstillinalowlevelinterface.Theknowledgeisnotcomplete,especiallyitisverylittleaboutprofessionalsomedepartmentsknowknowledgewritesomesimplebriefing.Otherworkisnotenough,andleadershipThereisaconsiderablegapbetweentherequirements.Andintheencounterthetediouswork,complexthings,sometimestakethemethodofescape,thatbridgetheboattothebridgestraight,nottheirownforcepleasefindcountermeasures,buttowaitfortheself,thelackofaspiritofhardresearch.Two,theIn1944,theamountssentoutinformation,wasarrestedbytheelves,sufferedtorture,heroicandunyielding,andkilledbytheenemy.ThefiveCommunistswho,front-lineeliteZhuZhu(1909-1996),QingShuiXiangF