数据库课程设计-高校学籍管理系统

上传者: 51060450 | 上传时间: 2022-06-17 21:57:18 | 文件大小: 3.6MB | 文件类型: ZIP
高校学籍管理系统 实现功能: 1.实现学生信息、班级、院系、专业等的管理; 2.实现课程、学生成绩信息管理;实现学生的奖惩信息管理 3.创建规则用于限制性别项只能输入“男”或“女”; 4.创建视图查询各个学生的学号、姓名、班级、专业、院系; 5.创建存储过程查询指定学生的成绩单; 6.创建触发器当增加、删除学生和修改学生班级信息时自动修改相应班级学生人数; 7.建立数据库相关表之间的参照完整性约束。 项目背景: 本数据库课程设计选题为高校学籍管理系统,课程设计的系统架构为C/S架构,数据库采用的是MySQL,选用的编程语言为Java,连接数据库的方式为JDBC。课程设计报告主要包括以下内容:需求分析、概念结构设计、逻辑结构设计、数据库物理设计与实施、数据库操作要求及实现、概念结构设计、逻辑结构设计、物理设计、数据库实施、系统设计相关代码、感想及心得体会。

文件下载

资源详情

[{"title":"( 98 个子文件 3.6MB ) 数据库课程设计-高校学籍管理系统","children":[{"title":"数据库课程设计答辩","children":[{"title":"成绩数据流图.png <span style='color:#111;'> 77.46KB </span>","children":null,"spread":false},{"title":"管理员注册数据流图.png <span style='color:#111;'> 51.69KB </span>","children":null,"spread":false},{"title":"教师与成绩E-R图.png <span style='color:#111;'> 64.79KB </span>","children":null,"spread":false},{"title":"答辩流程.txt <span style='color:#111;'> 236B </span>","children":null,"spread":false},{"title":"教师与课程E-R图.png <span style='color:#111;'> 71.90KB </span>","children":null,"spread":false},{"title":"学生信息数据流图.png <span style='color:#111;'> 68.26KB </span>","children":null,"spread":false},{"title":"高校学籍管理系统结构图.png <span style='color:#111;'> 42.63KB </span>","children":null,"spread":false},{"title":"学生与奖惩E-R图.png <span style='color:#111;'> 98.94KB </span>","children":null,"spread":false},{"title":"学生与成绩E-R图.png <span style='color:#111;'> 90.47KB </span>","children":null,"spread":false},{"title":"课程与班级E-R图.png <span style='color:#111;'> 74.96KB </span>","children":null,"spread":false},{"title":"高校学籍管理系统E-R图.jpg <span style='color:#111;'> 95.28KB </span>","children":null,"spread":false},{"title":"高校学籍管理系统E-R图.png <span style='color:#111;'> 188.77KB </span>","children":null,"spread":false},{"title":"奖惩信息数据流图.png <span style='color:#111;'> 76.81KB </span>","children":null,"spread":false},{"title":"课程与成绩E-R图.png <span style='color:#111;'> 75.56KB </span>","children":null,"spread":false},{"title":"课程信息数据流图.png <span style='color:#111;'> 73.68KB </span>","children":null,"spread":false},{"title":"main.jpg <span style='color:#111;'> 198.75KB </span>","children":null,"spread":false},{"title":"学生与班级E-R图.png <span style='color:#111;'> 89.96KB </span>","children":null,"spread":false},{"title":"MySQL数据库代码.txt <span style='color:#111;'> 2.49KB </span>","children":null,"spread":false}],"spread":false},{"title":"数据库课程设计报告.docx <span style='color:#111;'> 1.80MB </span>","children":null,"spread":false},{"title":"高校学籍管理系统代码","children":[{"title":"bin","children":[{"title":"sims","children":[{"title":"model","children":[{"title":"User.class <span style='color:#111;'> 890B </span>","children":null,"spread":false},{"title":"DMC.class <span style='color:#111;'> 908B </span>","children":null,"spread":false},{"title":"Teacher.class <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"Student.class <span style='color:#111;'> 2.00KB </span>","children":null,"spread":false},{"title":"Course.class <span style='color:#111;'> 1.24KB </span>","children":null,"spread":false},{"title":"RP.class <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false},{"title":"SC.class <span style='color:#111;'> 1.04KB </span>","children":null,"spread":false}],"spread":true},{"title":"view","children":[{"title":"setstu","children":[{"title":"UpdateStuInfo.class <span style='color:#111;'> 9.29KB </span>","children":null,"spread":false},{"title":"DeleteStuInfo.class <span style='color:#111;'> 2.39KB </span>","children":null,"spread":false},{"title":"UpdateStuInfoStudent.class <span style='color:#111;'> 9.35KB </span>","children":null,"spread":false},{"title":"AddStuInfo.class <span style='color:#111;'> 8.14KB </span>","children":null,"spread":false}],"spread":true},{"title":"SIMS_JF_Manager.class <span style='color:#111;'> 7.79KB </span>","children":null,"spread":false},{"title":"setrp","children":[{"title":"UpdateRP.class <span style='color:#111;'> 5.18KB </span>","children":null,"spread":false},{"title":"AddRP.class <span style='color:#111;'> 4.88KB </span>","children":null,"spread":false},{"title":"DeleteRP.class <span style='color:#111;'> 2.35KB </span>","children":null,"spread":false}],"spread":true},{"title":"exit","children":[{"title":"Exit.class <span style='color:#111;'> 778B </span>","children":null,"spread":false}],"spread":true},{"title":"getrp","children":[{"title":"GetRP.class <span style='color:#111;'> 8.22KB </span>","children":null,"spread":false}],"spread":true},{"title":"setsc","children":[{"title":"DeleteSC.class <span style='color:#111;'> 4.35KB </span>","children":null,"spread":false},{"title":"AddSC.class <span style='color:#111;'> 5.56KB </span>","children":null,"spread":false},{"title":"UpdateSC.class <span style='color:#111;'> 5.63KB </span>","children":null,"spread":false}],"spread":true},{"title":"setcou","children":[{"title":"UpdateCouInfo.class <span style='color:#111;'> 5.77KB </span>","children":null,"spread":false},{"title":"AddCouInfo.class <span style='color:#111;'> 5.54KB </span>","children":null,"spread":false},{"title":"DeleteCouInfo.class <span style='color:#111;'> 2.38KB </span>","children":null,"spread":false}],"spread":true},{"title":"getsc","children":[{"title":"GetSC.class <span style='color:#111;'> 13.33KB </span>","children":null,"spread":false}],"spread":true},{"title":"getteacher","children":[{"title":"GetTeacher.class <span style='color:#111;'> 8.52KB </span>","children":null,"spread":false}],"spread":false},{"title":"help","children":[{"title":"Help.class <span style='color:#111;'> 503B </span>","children":null,"spread":false}],"spread":false},{"title":"getstu","children":[{"title":"GetStuInfo.class <span style='color:#111;'> 9.43KB </span>","children":null,"spread":false}],"spread":false},{"title":"SIMS_JF_Student.class <span style='color:#111;'> 4.42KB </span>","children":null,"spread":false},{"title":"setuser","children":[{"title":"UpdateUserPass.class <span style='color:#111;'> 4.96KB </span>","children":null,"spread":false},{"title":"AddUser.class <span style='color:#111;'> 5.81KB </span>","children":null,"spread":false}],"spread":false},{"title":"getdmc","children":[{"title":"GetDMC.class <span style='color:#111;'> 8.47KB </span>","children":null,"spread":false}],"spread":false},{"title":"getcou","children":[{"title":"GetCouInfo.class <span style='color:#111;'> 7.98KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"util","children":[{"title":"jdbc","children":[{"title":"DatabaseConnection.class <span style='color:#111;'> 1.49KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"login","children":[{"title":"SIMS_JF_Login.class <span style='color:#111;'> 6.03KB </span>","children":null,"spread":false},{"title":".#SIMS_JF_Login.java.1.3 <span style='color:#111;'> 5.66KB </span>","children":null,"spread":false},{"title":"SIMS_JF_Login$1.class <span style='color:#111;'> 555B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"wsy","children":[{"title":"main.jpg <span style='color:#111;'> 198.75KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"CVS","children":null,"spread":false},{"title":".settings","children":[{"title":"CVS","children":[{"title":"Root <span style='color:#111;'> 37B </span>","children":null,"spread":false},{"title":"Entries <span style='color:#111;'> 60B </span>","children":null,"spread":false},{"title":"Repository <span style='color:#111;'> 19B </span>","children":null,"spread":false}],"spread":true},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 629B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"sims","children":[{"title":"model","children":[{"title":"User.java <span style='color:#111;'> 467B </span>","children":null,"spread":false},{"title":"Course.java <span style='color:#111;'> 794B </span>","children":null,"spread":false},{"title":"Teacher.java <span style='color:#111;'> 622B </span>","children":null,"spread":false},{"title":"Student.java <span style='color:#111;'> 1.36KB </span>","children":null,"spread":false},{"title":"RP.java <span style='color:#111;'> 677B </span>","children":null,"spread":false},{"title":"DMC.java <span style='color:#111;'> 623B </span>","children":null,"spread":false},{"title":"SC.java <span style='color:#111;'> 619B </span>","children":null,"spread":false}],"spread":true},{"title":"view","children":[{"title":"setstu","children":[{"title":"DeleteStuInfo.java <span style='color:#111;'> 2.33KB </span>","children":null,"spread":false},{"title":"UpdateStuInfo.java <span style='color:#111;'> 9.79KB </span>","children":null,"spread":false},{"title":"AddStuInfo.java <span style='color:#111;'> 8.52KB </span>","children":null,"spread":false},{"title":"UpdateStuInfoStudent.java <span style='color:#111;'> 10.34KB </span>","children":null,"spread":false}],"spread":true},{"title":"setrp","children":[{"title":"AddRP.java <span style='color:#111;'> 4.84KB </span>","children":null,"spread":false},{"title":"UpdateRP.java <span style='color:#111;'> 4.79KB </span>","children":null,"spread":false},{"title":"DeleteRP.java <span style='color:#111;'> 1.65KB </span>","children":null,"spread":false}],"spread":true},{"title":"exit","children":[{"title":"Exit.java <span style='color:#111;'> 457B </span>","children":null,"spread":false}],"spread":true},{"title":"getrp","children":[{"title":"GetRP.java <span style='color:#111;'> 7.41KB </span>","children":null,"spread":false}],"spread":true},{"title":"setsc","children":[{"title":"UpdateSC.java <span style='color:#111;'> 5.26KB </span>","children":null,"spread":false},{"title":"AddSC.java <span style='color:#111;'> 5.70KB </span>","children":null,"spread":false},{"title":"DeleteSC.java <span style='color:#111;'> 4.01KB </span>","children":null,"spread":false}],"spread":true},{"title":"setcou","children":[{"title":"DeleteCouInfo.java <span style='color:#111;'> 1.85KB </span>","children":null,"spread":false},{"title":"AddCouInfo.java <span style='color:#111;'> 5.61KB </span>","children":null,"spread":false},{"title":"UpdateCouInfo.java <span style='color:#111;'> 5.61KB </span>","children":null,"spread":false}],"spread":false},{"title":"getsc","children":[{"title":"GetSC.java <span style='color:#111;'> 14.77KB </span>","children":null,"spread":false}],"spread":false},{"title":"getteacher","children":[{"title":"GetTeacher.java <span style='color:#111;'> 7.63KB </span>","children":null,"spread":false}],"spread":false},{"title":"help","children":[{"title":"Help.java <span style='color:#111;'> 217B </span>","children":null,"spread":false}],"spread":false},{"title":"getstu","children":[{"title":"GetStuInfo.java <span style='color:#111;'> 8.78KB </span>","children":null,"spread":false}],"spread":false},{"title":"setuser","children":[{"title":"UpdateUserPass.java <span style='color:#111;'> 4.67KB </span>","children":null,"spread":false},{"title":"AddUser.java <span style='color:#111;'> 5.78KB </span>","children":null,"spread":false}],"spread":false},{"title":"getdmc","children":[{"title":"GetDMC.java <span style='color:#111;'> 7.74KB </span>","children":null,"spread":false}],"spread":false},{"title":"SIMS_JF_Student.java <span style='color:#111;'> 4.95KB </span>","children":null,"spread":false},{"title":"SIMS_JF_Manager.java <span style='color:#111;'> 10.37KB </span>","children":null,"spread":false},{"title":"getcou","children":[{"title":"GetCouInfo.java <span style='color:#111;'> 6.99KB </span>","children":null,"spread":false}],"spread":false}],"spread":false},{"title":"util","children":[{"title":"jdbc","children":[{"title":"DatabaseConnection.java <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"login","children":[{"title":".#SIMS_JF_Login.java.1.3 <span style='color:#111;'> 5.66KB </span>","children":null,"spread":false},{"title":"SIMS_JF_Login.java <span style='color:#111;'> 5.93KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"wsy","children":[{"title":"main.jpg <span style='color:#111;'> 198.75KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":".project <span style='color:#111;'> 380B </span>","children":null,"spread":false},{"title":".classpath <span style='color:#111;'> 429B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明