EMSystem:上海大学数据库课程项目

上传者: 42159267 | 上传时间: 2023-02-25 14:53:47 | 文件大小: 865KB | 文件类型: ZIP
EMSystem(教务管理系统) 上海大学数据库课程项目 报告水完了,不更了... 登录页面 背景图链接: 学生端选课限制(时间段or学分上限)触发器 学生端课程查询student_QueryCourse 学生查询课程时可以选择学期,因此可以查到非当前学期/当前学期未开设的课程。 分情况考虑针对C表存在但O表中不存在的课程即当前学期未开设的课程,返回结果为C表所有字段。  对于C表和O表均存在的课程即当前学期开设的课程,返回结果仿照教务处选课系统,增加工号,教师名称,上课时间三个字段。 故首先查询C表,使用filter方法将表单的字段与C表中已有的字段(xq,kh,km)进行匹配。此时gh,jsmc,sksj三个字段仍为空,需要利用到O表和T表进行多表查询。注意:需要确保O表与C表的主键id对应一致,即C表包含所有id,O表只有其中一部分。 学生端选课student_AddCourse~~

文件下载

资源详情

[{"title":"( 108 个子文件 865KB ) EMSystem:上海大学数据库课程项目","children":[{"title":"db.sqlite3 <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 3.76KB </span>","children":null,"spread":false},{"title":"settings.py <span style='color:#111;'> 3.34KB </span>","children":null,"spread":false},{"title":"urls.py <span style='color:#111;'> 3.60KB </span>","children":null,"spread":false},{"title":"urls.cpython-37.pyc <span style='color:#111;'> 1004B </span>","children":null,"spread":false},{"title":"wsgi.cpython-37.pyc <span style='color:#111;'> 527B </span>","children":null,"spread":false},{"title":"__init__.cpython-37.pyc <span style='color:#111;'> 132B </span>","children":null,"spread":false},{"title":"settings.cpython-37.pyc <span style='color:#111;'> 2.26KB </span>","children":null,"spread":false},{"title":"__init__.py <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"wsgi.py <span style='color:#111;'> 383B </span>","children":null,"spread":false},{"title":"manage.py <span style='color:#111;'> 535B </span>","children":null,"spread":false},{"title":"testdict.py <span style='color:#111;'> 54B </span>","children":null,"spread":false},{"title":"procedure_temp <span style='color:#111;'> 963B </span>","children":null,"spread":false},{"title":"procedure.txt <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"login.css <span style='color:#111;'> 2.16KB </span>","children":null,"spread":false},{"title":"sweetalert.css <span style='color:#111;'> 22.34KB </span>","children":null,"spread":false},{"title":"StyleTables.css <span style='color:#111;'> 2.18KB </span>","children":null,"spread":false},{"title":"bootstrap.min.css <span style='color:#111;'> 118.36KB </span>","children":null,"spread":false},{"title":"bootstrap.css.map <span style='color:#111;'> 380.16KB </span>","children":null,"spread":false},{"title":"bootstrap-theme.min.css.map <span style='color:#111;'> 25.05KB </span>","children":null,"spread":false},{"title":"bootstrap.min.css.map <span style='color:#111;'> 529.49KB </span>","children":null,"spread":false},{"title":"bootstrap-theme.css.map <span style='color:#111;'> 46.59KB </span>","children":null,"spread":false},{"title":"bootstrap-theme.css <span style='color:#111;'> 25.52KB </span>","children":null,"spread":false},{"title":"bootstrap.css <span style='color:#111;'> 142.59KB </span>","children":null,"spread":false},{"title":"bootstrap-theme.min.css <span style='color:#111;'> 22.86KB </span>","children":null,"spread":false},{"title":"glyphicons-halflings-regular.svg <span style='color:#111;'> 106.19KB </span>","children":null,"spread":false},{"title":"glyphicons-halflings-regular.woff <span style='color:#111;'> 22.88KB </span>","children":null,"spread":false},{"title":"glyphicons-halflings-regular.ttf <span style='color:#111;'> 44.34KB </span>","children":null,"spread":false},{"title":"glyphicons-halflings-regular.woff2 <span style='color:#111;'> 17.61KB </span>","children":null,"spread":false},{"title":"glyphicons-halflings-regular.eot <span style='color:#111;'> 19.66KB </span>","children":null,"spread":false},{"title":"npm.js <span style='color:#111;'> 484B </span>","children":null,"spread":false},{"title":"bootstrap.js <span style='color:#111;'> 68.07KB </span>","children":null,"spread":false},{"title":"bootstrap.min.js <span style='color:#111;'> 36.18KB </span>","children":null,"spread":false},{"title":"chat.png <span style='color:#111;'> 6.89KB </span>","children":null,"spread":false},{"title":"xk.png <span style='color:#111;'> 68.76KB </span>","children":null,"spread":false},{"title":"kb.png <span style='color:#111;'> 67.31KB </span>","children":null,"spread":false},{"title":"downarrow.png <span style='color:#111;'> 4.06KB </span>","children":null,"spread":false},{"title":"more.png <span style='color:#111;'> 2.40KB </span>","children":null,"spread":false},{"title":"tk.png <span style='color:#111;'> 48.57KB </span>","children":null,"spread":false},{"title":"calendar.png <span style='color:#111;'> 4.12KB </span>","children":null,"spread":false},{"title":"mainmenu.png <span style='color:#111;'> 3.44KB </span>","children":null,"spread":false},{"title":"circle.png <span style='color:#111;'> 5.63KB </span>","children":null,"spread":false},{"title":"calGrade.png <span style='color:#111;'> 70.74KB </span>","children":null,"spread":false},{"title":"cjcx.png <span style='color:#111;'> 54.92KB </span>","children":null,"spread":false},{"title":"menu.png <span style='color:#111;'> 1.78KB </span>","children":null,"spread":false},{"title":"user.png <span style='color:#111;'> 4.14KB </span>","children":null,"spread":false},{"title":"kccx.png <span style='color:#111;'> 60.37KB </span>","children":null,"spread":false},{"title":"computer.png <span style='color:#111;'> 2.57KB </span>","children":null,"spread":false},{"title":"logout.png <span style='color:#111;'> 4.90KB </span>","children":null,"spread":false},{"title":"jquery-3.4.1.js <span style='color:#111;'> 86.08KB </span>","children":null,"spread":false},{"title":"csrf.js <span style='color:#111;'> 1.65KB </span>","children":null,"spread":false},{"title":"sweetalert-dev.js <span style='color:#111;'> 118.93KB </span>","children":null,"spread":false},{"title":".gitignore <span style='color:#111;'> 176B </span>","children":null,"spread":false},{"title":"vcs.xml <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"misc.xml <span style='color:#111;'> 288B </span>","children":null,"spread":false},{"title":"modules.xml <span style='color:#111;'> 258B </span>","children":null,"spread":false},{"title":"profiles_settings.xml <span style='color:#111;'> 174B </span>","children":null,"spread":false},{"title":"jwc.iml <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"dataSources.xml <span style='color:#111;'> 644B </span>","children":null,"spread":false},{"title":"trigger_teacher.txt <span style='color:#111;'> 200B </span>","children":null,"spread":false},{"title":"trigger.txt <span style='color:#111;'> 5.55KB </span>","children":null,"spread":false},{"title":"trigger_on_temp.txt <span style='color:#111;'> 372B </span>","children":null,"spread":false},{"title":"trigger_on_o <span style='color:#111;'> 179B </span>","children":null,"spread":false},{"title":"admin.py <span style='color:#111;'> 63B </span>","children":null,"spread":false},{"title":"models.py <span style='color:#111;'> 4.11KB </span>","children":null,"spread":false},{"title":"0003_s_xfh.py <span style='color:#111;'> 370B </span>","children":null,"spread":false},{"title":"__init__.cpython-37.pyc <span style='color:#111;'> 146B </span>","children":null,"spread":false},{"title":"0001_initial.cpython-37.pyc <span style='color:#111;'> 682B </span>","children":null,"spread":false},{"title":"__init__.py <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"0002_s_jj.py <span style='color:#111;'> 372B </span>","children":null,"spread":false},{"title":"0001_initial.py <span style='color:#111;'> 5.07KB </span>","children":null,"spread":false},{"title":"teacher_views.py <span style='color:#111;'> 10.62KB </span>","children":null,"spread":false},{"title":"tests.py <span style='color:#111;'> 258B </span>","children":null,"spread":false},{"title":"urls.cpython-37.pyc <span style='color:#111;'> 333B </span>","children":null,"spread":false},{"title":"views.cpython-37.pyc <span style='color:#111;'> 2.17KB </span>","children":null,"spread":false},{"title":"__init__.cpython-37.pyc <span style='color:#111;'> 135B </span>","children":null,"spread":false},{"title":"models.cpython-37.pyc <span style='color:#111;'> 439B </span>","children":null,"spread":false},{"title":"admin.cpython-37.pyc <span style='color:#111;'> 176B </span>","children":null,"spread":false},{"title":"__init__.py <span style='color:#111;'> 0B </span>","children":null,"spread":false},{"title":"apps.py <span style='color:#111;'> 91B </span>","children":null,"spread":false},{"title":"views.py <span style='color:#111;'> 56.58KB </span>","children":null,"spread":false},{"title":"add.html <span style='color:#111;'> 710B </span>","children":null,"spread":false},{"title":"student_CourseTable.html <span style='color:#111;'> 12.06KB </span>","children":null,"spread":false},{"title":"teacher_write.html <span style='color:#111;'> 8.98KB </span>","children":null,"spread":false},{"title":"testlogin.html <span style='color:#111;'> 2.26KB </span>","children":null,"spread":false},{"title":"Management.html <span style='color:#111;'> 28.50KB </span>","children":null,"spread":false},{"title":"teacher_open.html <span style='color:#111;'> 11.63KB </span>","children":null,"spread":false},{"title":"student_DeleteCourse.html <span style='color:#111;'> 15.23KB </span>","children":null,"spread":false},{"title":"admin_index.html <span style='color:#111;'> 7.66KB </span>","children":null,"spread":false},{"title":"testcheckbox2.html <span style='color:#111;'> 6.59KB </span>","children":null,"spread":false},{"title":"student_QueryCourse.html <span style='color:#111;'> 10.90KB </span>","children":null,"spread":false},{"title":"student_AddCourse.html <span style='color:#111;'> 12.36KB </span>","children":null,"spread":false},{"title":"deal_with_apply.html <span style='color:#111;'> 14.55KB </span>","children":null,"spread":false},{"title":"student_index.html <span style='color:#111;'> 8.06KB </span>","children":null,"spread":false},{"title":"teacher_check_detial.html <span style='color:#111;'> 7.85KB </span>","children":null,"spread":false},{"title":"teacher_check.html <span style='color:#111;'> 9.50KB </span>","children":null,"spread":false},{"title":"login.html <span style='color:#111;'> 290B </span>","children":null,"spread":false},{"title":"index.html <span style='color:#111;'> 910B </span>","children":null,"spread":false},{"title":"testcheckbox.html <span style='color:#111;'> 5.01KB </span>","children":null,"spread":false},{"title":"student_QueryGrades.html <span style='color:#111;'> 11.97KB </span>","children":null,"spread":false},{"title":"......","children":null,"spread":false},{"title":"<span style='color:steelblue;'>文件过多,未全部展示</span>","children":null,"spread":false}],"spread":true}]

评论信息

免责申明

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