首页 设备管理课程设计.zip

设备管理课程设计.zip

上传者： 42636264 | 上传时间： 2021-06-22 16:42:13 | 文件大小： 2.39MB | 文件类型： ZIP
按照关系型数据库的基本原理，根据数据库设计方法，综合运用所学的知识，设计开发一个小型的数据库- 某高校设备管理系统数据库。熟练掌握相关数据库的分析、设计、实现过程，前台设计语言自选，系统完成对数据库数据的增加、修改、删除、查询功能。
设计内容：
某高校设备管理系统数据库包括以下功能：实现设备类别、设备信息管理（录入、修改、删除等）；实现用户管理；实现设备入库管理，必须自动修改相应设备的数量；实现设备的领用和归还管理（要自动修改相应设备的可领用数量）；实现设备的报损管理（报损后要自动修改相应设备的数量和可领用数量）；创建存储过程，统计各种类型设备的数量；创建存储过程，统计指定月份各设备的领用归还情况；具有数据备份和数据恢复功能。
要求：
数据库系统要根据设计内容和要求进行分析与设计，要考虑系统的完整性约束，系统中的数据表设计应合理、高效，尽量减少数据冗余。（规范到3NF或BCNF
系统完成对数据库数据的增加、修改、删除、查询功能。

文件下载

资源详情

[{"title":"（ 91 个子文件 2.39MB ） 设备管理课程设计.zip","children":[{"title":"设备管理课程设计","children":[{"title":".project <span style='color:#111;'> 924B </span>","children":null,"spread":false},{"title":".settings","children":[{"title":".jsdtscope <span style='color:#111;'> 567B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.component <span style='color:#111;'> 524B </span>","children":null,"spread":false},{"title":"org.eclipse.jdt.core.prefs <span style='color:#111;'> 364B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.common.project.facet.core.xml <span style='color:#111;'> 345B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.container <span style='color:#111;'> 49B </span>","children":null,"spread":false},{"title":"org.eclipse.wst.jsdt.ui.superType.name <span style='color:#111;'> 6B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"edu","children":[{"title":"conn","children":[{"title":"Conn.java <span style='color:#111;'> 440B </span>","children":null,"spread":false}],"spread":true},{"title":"dao","children":[{"title":"RentDao.java <span style='color:#111;'> 2.88KB </span>","children":null,"spread":false},{"title":"EquipmentDao.java <span style='color:#111;'> 9.92KB </span>","children":null,"spread":false},{"title":"UserDao.java <span style='color:#111;'> 4.97KB </span>","children":null,"spread":false}],"spread":true},{"title":"servlet","children":[{"title":"userUpdateServlet.java <span style='color:#111;'> 1.67KB </span>","children":null,"spread":false},{"title":"adminQueryServlet.java <span style='color:#111;'> 1.76KB </span>","children":null,"spread":false},{"title":"equDoUpdateServlet.java <span style='color:#111;'> 1.85KB </span>","children":null,"spread":false},{"title":"userQueryEquServlet.java <span style='color:#111;'> 1.93KB </span>","children":null,"spread":false},{"title":"StatisticsByMounthServlet.java <span style='color:#111;'> 1.79KB </span>","children":null,"spread":false},{"title":"equDeleteServlet.java <span style='color:#111;'> 1.60KB </span>","children":null,"spread":false},{"title":"equUpdateServlet.java <span style='color:#111;'> 1.64KB </span>","children":null,"spread":false},{"title":"userQueryServlet.java <span style='color:#111;'> 1.72KB </span>","children":null,"spread":false},{"title":"userInsertServlet.java <span style='color:#111;'> 1.92KB </span>","children":null,"spread":false},{"title":"userReturnEquServlet.java <span style='color:#111;'> 1.93KB </span>","children":null,"spread":false},{"title":"userRentEquServlet.java <span style='color:#111;'> 1.92KB </span>","children":null,"spread":false},{"title":"equInsertExistServlet.java <span style='color:#111;'> 1.84KB </span>","children":null,"spread":false},{"title":"userLoginServlet.java <span style='color:#111;'> 2.15KB </span>","children":null,"spread":false},{"title":"userQueryRentServlet.java <span style='color:#111;'> 1.95KB </span>","children":null,"spread":false},{"title":"userDamageEquServlet.java <span style='color:#111;'> 2.04KB </span>","children":null,"spread":false},{"title":"adminQueryEquServlet.java <span style='color:#111;'> 1.77KB </span>","children":null,"spread":false},{"title":"equInsertNewServlet.java <span style='color:#111;'> 1.76KB </span>","children":null,"spread":false},{"title":"adminQueryRentServlet.java <span style='color:#111;'> 1.87KB </span>","children":null,"spread":false},{"title":"StatisticsByTypeServlet.java <span style='color:#111;'> 1.69KB </span>","children":null,"spread":false},{"title":"userDoUpdateServlet.java <span style='color:#111;'> 1.74KB </span>","children":null,"spread":false}],"spread":false},{"title":"user","children":[{"title":"User.java <span style='color:#111;'> 817B </span>","children":null,"spread":false}],"spread":true},{"title":"equipment","children":[{"title":"Equipment.java <span style='color:#111;'> 1.51KB </span>","children":null,"spread":false},{"title":"Rent.java <span style='color:#111;'> 1005B </span>","children":null,"spread":false}],"spread":true},{"title":"date","children":[{"title":"NewDate.java <span style='color:#111;'> 371B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true},{"title":"build","children":[{"title":"classes","children":[{"title":"edu","children":[{"title":"conn","children":[{"title":"Conn.class <span style='color:#111;'> 975B </span>","children":null,"spread":false}],"spread":true},{"title":"dao","children":[{"title":"EquipmentDao.class <span style='color:#111;'> 8.77KB </span>","children":null,"spread":false},{"title":"RentDao.class <span style='color:#111;'> 3.47KB </span>","children":null,"spread":false},{"title":"UserDao.class <span style='color:#111;'> 4.88KB </span>","children":null,"spread":false}],"spread":true},{"title":"servlet","children":[{"title":"userLoginServlet.class <span style='color:#111;'> 2.43KB </span>","children":null,"spread":false},{"title":"userDoUpdateServlet.class <span style='color:#111;'> 1.68KB </span>","children":null,"spread":false},{"title":"userQueryRentServlet.class <span style='color:#111;'> 1.91KB </span>","children":null,"spread":false},{"title":"equDoUpdateServlet.class <span style='color:#111;'> 1.85KB </span>","children":null,"spread":false},{"title":"StatisticsByMounthServlet.class <span style='color:#111;'> 2.05KB </span>","children":null,"spread":false},{"title":"StatisticsByTypeServlet.class <span style='color:#111;'> 1.73KB </span>","children":null,"spread":false},{"title":"userUpdateServlet.class <span style='color:#111;'> 1.72KB </span>","children":null,"spread":false},{"title":"userQueryEquServlet.class <span style='color:#111;'> 2.02KB </span>","children":null,"spread":false},{"title":"equInsertExistServlet.class <span style='color:#111;'> 1.93KB </span>","children":null,"spread":false},{"title":"equUpdateServlet.class <span style='color:#111;'> 1.80KB </span>","children":null,"spread":false},{"title":"equDeleteServlet.class <span style='color:#111;'> 1.60KB </span>","children":null,"spread":false},{"title":"userInsertServlet.class <span style='color:#111;'> 2.29KB </span>","children":null,"spread":false},{"title":"userReturnEquServlet.class <span style='color:#111;'> 1.75KB </span>","children":null,"spread":false},{"title":"userQueryServlet.class <span style='color:#111;'> 1.88KB </span>","children":null,"spread":false},{"title":"equInsertNewServlet.class <span style='color:#111;'> 1.80KB </span>","children":null,"spread":false},{"title":"adminQueryRentServlet.class <span style='color:#111;'> 1.71KB </span>","children":null,"spread":false},{"title":"userRentEquServlet.class <span style='color:#111;'> 1.74KB </span>","children":null,"spread":false},{"title":"adminQueryEquServlet.class <span style='color:#111;'> 1.71KB </span>","children":null,"spread":false},{"title":"adminQueryServlet.class <span style='color:#111;'> 1.68KB </span>","children":null,"spread":false},{"title":"userDamageEquServlet.class <span style='color:#111;'> 1.92KB </span>","children":null,"spread":false}],"spread":false},{"title":"user","children":[{"title":"User.class <span style='color:#111;'> 1.24KB </span>","children":null,"spread":false}],"spread":true},{"title":"equipment","children":[{"title":"Rent.class <span style='color:#111;'> 1.46KB </span>","children":null,"spread":false},{"title":"Equipment.class <span style='color:#111;'> 2.16KB </span>","children":null,"spread":false}],"spread":true},{"title":"date","children":[{"title":"NewDate.class <span style='color:#111;'> 857B </span>","children":null,"spread":false}],"spread":true}],"spread":true}],"spread":true}],"spread":true},{"title":"WebContent","children":[{"title":"ExistEquInsert.jsp <span style='color:#111;'> 758B </span>","children":null,"spread":false},{"title":"UserSelect.jsp <span style='color:#111;'> 879B </span>","children":null,"spread":false},{"title":"WEB-INF","children":[{"title":"lib","children":[{"title":"jstl-1.2.jar <span style='color:#111;'> 404.53KB </span>","children":null,"spread":false},{"title":"mysql-connector-java-8.0.15.jar <span style='color:#111;'> 2.04MB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"UserLogin.jsp <span style='color:#111;'> 1.14KB </span>","children":null,"spread":false},{"title":"AdminSelectRent.jsp <span style='color:#111;'> 892B </span>","children":null,"spread":false},{"title":"UserSelectRent.jsp <span style='color:#111;'> 1.27KB </span>","children":null,"spread":false},{"title":"META-INF","children":[{"title":"MANIFEST.MF <span style='color:#111;'> 39B </span>","children":null,"spread":false}],"spread":true},{"title":"AdminManger.jsp <span style='color:#111;'> 2.27KB </span>","children":null,"spread":false},{"title":"suc.html <span style='color:#111;'> 267B </span>","children":null,"spread":false},{"title":"Mounth.jsp <span style='color:#111;'> 1.05KB </span>","children":null,"spread":false},{"title":"image","children":[{"title":"top.png <span style='color:#111;'> 2.40KB </span>","children":null,"spread":false},{"title":"top1.png <span style='color:#111;'> 42.53KB </span>","children":null,"spread":false}],"spread":false},{"title":"StatisticsByMounth.jsp <span style='color:#111;'> 914B </span>","children":null,"spread":false},{"title":"UserManger.jsp <span style='color:#111;'> 2.54KB </span>","children":null,"spread":false},{"title":"UserRent.jsp <span style='color:#111;'> 1.05KB </span>","children":null,"spread":false},{"title":"NewEquInsert.jsp <span style='color:#111;'> 913B </span>","children":null,"spread":false},{"title":"StatisticsByType.jsp <span style='color:#111;'> 801B </span>","children":null,"spread":false},{"title":"LoginFail.jsp <span style='color:#111;'> 1.62KB </span>","children":null,"spread":false},{"title":"UserInsert.jsp <span style='color:#111;'> 841B </span>","children":null,"spread":false},{"title":"InsertExist.jsp <span style='color:#111;'> 1.62KB </span>","children":null,"spread":false},{"title":"UserSelectEqu.jsp <span style='color:#111;'> 1.06KB </span>","children":null,"spread":false},{"title":"AdminSelect.jsp <span style='color:#111;'> 803B </span>","children":null,"spread":false},{"title":"EquInsert.jsp <span style='color:#111;'> 445B </span>","children":null,"spread":false},{"title":"AdminSelectEqu.jsp <span style='color:#111;'> 1.10KB </span>","children":null,"spread":false},{"title":"UserUpdate.jsp <span style='color:#111;'> 819B </span>","children":null,"spread":false},{"title":"EquUpdate.jsp <span style='color:#111;'> 1.16KB </span>","children":null,"spread":false}],"spread":false},{"title":".classpath <span style='color:#111;'> 685B </span>","children":null,"spread":false}],"spread":true}],"spread":true}]

评论信息

其他资源

免责申明

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

个人信息

下载历史

热门下载

最新下载