[计算机软件设计精品] 教学资源管理系统 论文

A1A0A3A2A6A4A5A7A10A8A9A11学生毕业设计（论文）课题名称教学资源管理系统姓名学号院、系、部微软IT学院专业软件开发指导教师A1A0A3A2A6A4A5A7A10A8A9A11前言管理系统是当今计算机软件发展的热门课题之一。近几年来，管理系统的出现从根本上改良了昔日教学资源处理事务造成的周期长、效率低、误差、遗漏等问题。在此基础上，以计算机为载体的应用软件层出不穷。本系统就是针对目前教学资源的日趋复杂化和多元化而设计的。人工的教学资源管理显得十分的落后而且效率低下，尤其在查询方面效率低。本系统将资源文件以二进制数据形式存储在关系型数据库中，对教育资源的管理都是基于对数据库的操作。所有的资源都以结G7512化的方式存储，数据G19400的关G13864G5627G5390，G5194G17902G17819数据G15932G1147G10995关系G7156G4568。G18331用计算机化的G16792G4462G8181式，查询、G1474改等操作都G1363用了计算机的数据库G6228G7427G15G8616G17227以前G6175工计算的方G8873有了G5468G3835的进G8505G15G6564G1391了G11468当G3835的方G1427，而且G16311G1927了G3252G6175工操作出现的工作G18339G3835、周期长、效率低、误差、遗漏等问题，G1363用G6155对教学资源的查询等操作G2476得G5567G6475、G12628G1427、G1946G11842。目前，有G12879G1296的教学资源管理系统G14033G4466现对资源的管理。G1306G3835多对用G6155之G19400的G1144G1126以G2462管理G2604G994用G6155之G19400的G1144G1126方面有G8436G13582。本G8437设计就是针对现存以上的G2520G12193G13582G9869，将在现有的管理软件的基础上作G5468G3835G12255G5242的改G2904，G1363教学管理系统G14033G3827G4466G7057一G1135G12628G2345的G1144G1126G2163G14033。A1A0A3A2A6A4A5A7A10A8A9A11目录1A12A131A14A15A14A16A17A18A19A20A21A22A23A24A25A261A14A15A27A16A17A18A19A20A21A22A23A28A29A30A31A321A14A15A33A34A35A36A37A38A39A40A41A42A43A44A452A46A47A48A34A35A36A37A38A39A40A41A49A50A51A5222A53A54A55A56A53A54A55A563A57A58A59A60A61A62A633A57A58A57A64A65A66A62A633A67A68A67A68A69A70A71A72A73A743A67A68A67A68A67A75A76A72A73A743A67A68A67A68A77A78A79A72A73A7433A80A81A82A83A84A85A86A87A88A89A90A80A81A82A83A84A85A86A87A88A894A91A92A93A94A95A96A97A98A99A100A1014A102A103A104A103A104A105A106A107A108A109A110A1114A102A103A104A103A112A113A114A115A113A116A1094A117A118A119A120A121A122A123A124A1255A102A103A112A103A104A113A114A126A127A128A129A130A131A132A1335A102A103A112A103A112A107A134A135A107A136A137A138A136A137A139A14054A141A142A143A144A141A142A143A1446A145A146A147A148A149A150A151A152A1536A154A155A156A155A156A157A158A159A160A161A162A163A164A1656A154A155A156A155A166A157A158A159A167A168A169A170A171A172A173A174A175A1766A154A155A156A155A177A157A158A160A161A178A179A180A1816A182A183A184A185A186A187A188A189A190A191A1927A154A155A166A155A156A193A194A169A170A195A196A171A172A197A198A175A1767A154A155A166A155A166A193A194A169A170A195A196A199A200A201A202A197A198A175A1768A154A155A166A155A177A203A204A205A169A170A195A196A197A198A175A1769A182A183A206A207A208A209A191A1929A154A155A177A155A156A210A211A180A1819A154A155A177A155A166A212A213A214A215A180A181105A216A217A218A21913A220A221A222A223A224A225A22613A220A221A227A228A229A224A230A225A22613A220A221A231A232A233A234A235A224A230A225A22614A220A221A236A237A238A234A235A239A240A224A230A225A22614A220A221A220A241A242A243A244A245A246A247A24815A249A250A251A252A253A254A255A7A0A1A2A3A245A246A247A24815A76A4A77A4A5A78A6A8A9A10A11A12A1315A76A4A77A4A14A81A15A16A8A9A10A11A12A13A25A17A27A28A18A19A20A21A28A18A19A20A21A33A22A23A24A26A29A30A31A32A34A35A36A37A76A4A38A4A39A48A40A8A9A10A11A12A1316A76A4A38A4A41A42A43A8A9A44A8A9A10A11A12A13166A45A46A47A49A50A47A49A5017A66A51A52A72A53A54A5517A56A57A58A57A58A85A59A60A61A62A63A6417A56A57A58A57A65A85A59A60A67A60A68A69A7017A71A73A74A75A79A80A82A83A8417A56A57A65A57A58A86A87A85A59A63A64A88A8917A56A57A65A57A65A86A87A85A59A90A9117A71A73A92A93A94A95A96A97A98A99A100A101A102A103A104A105A106A102A103A104A105A106A107A108A109A110A11120A112A11321A114A115A11622A117A118A119A120A121A122A120A121A122A123A124A125A126A127A128A129A130A131A132A133A134A135A136A137A138A139A140A141A142A143教学资源管理系统A144A145A146A147A148A149A150A151A152A153A154A155A156A157A158A159A160A161A162A163A160A164A165A166A167A161A168A166A169A162A164A170A171A172A164A167A167A166A172A173A174A175A176A177A178A179A180A181A182A180A183A184A185A178A186A176A187A188A189A172A164A169A190A166A172A191A192A166A172A193A166A172A194A195A196A197A198A199A193A199A200A201A196A202A203A204A205A206A207A176A208A209A210A211A212A213A214A210A176A189A191A192A178A186A196A215A216A217A218A210A176A219A203A196A220A202A221A222A154A155A196A223A159A210A224A225A226A210A211A208A209A210A197A222A154A155A158A159A161A168A190A227A199A167A192A171A227A165A168A164A228A229A229A230A231A232A154A155A196A233A214A194A195A234A235A176A160A168A236A172A164A190A164A237A171A192A238A239A192A166A172A193A166A172A228A229A229A230A231A232A240A214A241A242A243A194A195A234A235A197A244A245A168A170A165A164A169A190A246A247A248A249A159A198A250A189A162A251A252A253A254A255A106A241A242A243A196A0A1A197A154A155A255A106A221A114A2A159A217A3A4A5A6A224A120A7A224A122A8A149A9A10A11A12A13A14A15A16A17A18A148A253A224A134A19A20A21A22A23A24A141A114A2A159A217A244A99A25A26A27A28A29A224A148A195A30A201A224A120A7A224A150A31A224A152A32A33A34A35A36A22A37A252A38A231A141A160A39A176A152A153A40A207A41A42A224A165A43A211A44A45A12A13A224A148A253A211A20A21A141A169A159A217A150A31A14A15A46A32A196A33A34A35A36A47A48A49A50A196A51A52A211A152A153A22A197A53A54A55A53A54A146教学资源管理系统；ASPNETMVC；B/S模式；SQLSERVER2000THESYSTEMFORTEACHINGRESOURCEMANAGEMENTBASEDONWEBABSTRACTTHESYSTEMFORTEACHINGRESOURCEMANAGEMENTBASEDONWEBISDEVELOPEDWITHMVCA56A57A58A59A60A61A61A62A63A59A64A62A61A65A57A66A67A68A57A60A60A59A68A69SOFTWAREARCHITECTUREANDBROWSEA177SERVERMODELWITHTHEA70A71A72A73A74A75A76A77A78A79A80A81HELPOFMVCSFLEXIBILITYANDMAINTAINABILITYCODE,ANDCROSSPLATFORMASWELLASB/SSSIMPLECLIENT,THESYSTEMHASGREATADVANTAGEINAPPLICABILITY,FLEXIBILITYANDSECURITYTHEWEBBASEDTEACHINGRESOURCEMANAGEMENTSYSTEM,TAKINGVISUALSTUDIO2008ASFOREGROUNDDEVELOPMENTTOOL,ANDMICROSOFTSQLSERVER2008ASTHEBACKSTAGEDATABASEDEVELOPMENTKIT,ANDUSINGTHEJDBCDRIVERINWINDOWSXPTOACHIEVETHECONNECTIONBETWEENTHEDATABASE,CANHELPTHECUSTOMERTOMAKETHEFASTSEARCHING,BROWSING,ANDDOWNLOADINGTHESCHOOLNEWESTANNOUNCEMENTASWELLASTHENEEDCOURSEANDRELATEDCOURSEWAREITALSOHELPTHECUSTOMERTOPROPOSETHEINTERACTIVEOPERATIONSSUCHASWRITINGTHEMEMORANDUM,SENDINGANDRECEIVINGMESSAGE,BROWSING,ASKINGANDANSWERINGTHEQUESTIONSONLINEINADDITION,THESYSTEMMANAGERCANADD,DELETEANDMODIFYTHENOTES,COURSESWITHOUTANYDIFFICULTIES,ANDTOACHIEVETHEEFFECTIVEORGANIZATIONANDMANAGEMENTWITHALLKINDSOFTHEQUESTIONSOFTHEUSERSKEYWORDSTEACHINGRESOURCEMANAGEMENTSYSTEMSMVCB/SMODEA82A83A84A82A85A86A87A85A86A88A89A89A90A91A92A93A94A95A96A97A98A100A101A102A10311绪论11本教学资源管理系统的发展随着INTERNET的飞速发展，教学资源的数量与日俱增。如何对这些资源进行有效的管理和组织是相当有必要的。但是，简单地实现以二进制形式组织教学资源、以计算机管理代替人工管理教学资源这个功能是不能满足信息化教育教学的要求的。随着教育改革的深入发展，改变传统课程实施过于强调学生在教室接受学习、死记硬背、机械训练的现状，倡导学生主动参与、勇于探究、勤于动手，培养学生搜集和G3800理信息的能G2159、G14731G2474G7044G11705G16794的能G2159、G2010G7524和G16311G1927G19394G20076的能G2159以G2462G2524G1328的能G2159是当G1182信息化教学的G980个发展G7053G2533。G2375教学的G18337G5527G5332G3999G11013G256教G257G17728G2533G256学G257，G1363学生G4448G1852G1186教G5084G6523制的G4490教式、G15999动式学习状G5589G17728变G1038G14270主学习、G2464G2533G1144G8981的状G5589。G11458G2081，G13666G3281和G14533G3281G12573发G17810G3281G4490的教育资源管理系统G18129G5460G13605G13488化G7053G2533发展。G2375在G2419有功能G3534G11796G990增G2164G980些实G7114的教学功能，G8616如G726教G5084在G13459G16311G12584G11109G19602G19394G20076、学生G17902过G16278G11487在G13459G16282G20069、G16282G20069G9869G6785G6122G13785进入G15406G6323教室G7481实G7114地进行学习，这G1075是G6117G3281教学资源管理系统的G980个发展G17247G2195。12本教学资源管理系统功能和特点G7424系统能实现G980G14336教学资源管理系统G5224G16825G1867有的G3534G7424功能。G8616如G726学生G11004G6155G5567速搜G13046、G8995G16284、G991G17745学G7669G7380G7044G1856G2590和G1866G6164G19668教程、课G1226；教G5084G11004G6155发G5079课G1226、G990传相G1863教学G17753G2173G7460G7021、G991G17745制G1328课G1226G2462G1866G1194教育教学工G1328G1025G6164G19668的G2520G12193G7003G7735、G3282G10267G13044G7460G12573。教学工G1328的G5332展是G2464G2533的，G2494有G1038G5084生G1055G19400的G1144G8981G6564G1391G980个G3921的G5191G2500，G14841造出民主、和谐、G5191G12573的教学环境，才能G6564高教学效率，适G5224信息化社会对教育教学的要求。G3534于以G990考虑，G7424系统实现了G11004G6155在G13459书写备忘录、收发留言G12573功能。学生可以利G11004留言箱给同学、老G5084发送留言，讨论学习G1025遇到的G19394G20076，实现学生的G14270主学习。老G5084可以G17902过学生留言G7481得到G980些教学的反馈信息，以改进教学。此外，学生G11004G6155、教G5084G11004G6155G18129可以G17902过G7424系统G11705道吧版块G7481进行讨论G2520G12193G19394G20076，进行非实G7114的G1144G8981。管理员则对G1856G2590、教参资G7021、G19394G20076信息G12573进行组织和管理。G2462G7114更G7044资源、维护系统的安G1852。A104A105A107A108A109A110A111A112A113A115A116A117213本教学资源管理系统设计目的G17902过此次设计掌握G3534于WEB的教学资源管理系统软G1226的G3534G11796思路和G7053法，熟悉软G1226工程思想，进G980步G6564高利G11004NETG5332发软G1226水G5191，并能够熟练掌握G3534于SQLSERVER的数据库的管理的G5332发，熟悉利G11004G7424地API部G2010JAVA驱动程序访G19394模型实现对数据库的访G19394和B/S软G1226G5332发模式。14本教学资源管理系统开发步骤G980G14336G7481说，软G1226G5332发的过程主要包括软G1226定义规划、软G1226G5332发和软G1226运行维护三个G7114期组成，G1866G1025软G1226的定义过程G17902常又进G980步划G2010G1038G19394G20076定义、可行性研究和G19668求G2010G7524三个阶段。软G1226G5332发G7114期又G2010G1038系统的总体设计、详细设计、编码和单元测试、综G2524测试四个阶段。G7424教学资源管理系统采G11004软G1226工程G1025G5224G11004G7380广泛的过程模型瀑G5079式G5332发，阶段G19400G1867有顺序性和依赖性，G2081G980阶段的输出G7003G7735就是后G980阶段的输入G7003G7735，G2494有G2081G980阶段的输出G7003G7735正确，后阶段的工G1328才能顺利进行。A104A105A107A108A109A110A111A112A113A115A116A11732需求说明21需求分析当G2081计算机G13605G13488教育的迅速发展，G1363得教学资源呈现出数量大、G12193类多、形式杂的状况。实现对这些资源进行有效的组织和管理，让学生在繁多的教学资源G1025G5567速搜G13046、G8995G16284G6164G19668信息，让教G5084能G7053便G5567G6475地进行课G1226发G5079是G980个G1139G5465G16311G1927的G19394G20076。此外，教学资源管理系统主要是G1038学G7669教育教学G7393G2165，以G6564高教学效率，G1431进学生G1852G19766发展。系统G11004G6155G13688主要是教G5084和学生，教学是G980个G5084生G1144G1126、G1144G8981的过程，G6937G17836要求系统能实现G980定的G11004G6155G1144G1126，成G1038G980个生生、G5084生G1144G8981的G5191G25001。22可行性分析221技术可行性G17G49EG55运行和G5332发环境G726G8995G16284G3132G726IE；数据库G726SQLSERVER200G27；G6817G1328系统G726WG76NG71G82G90G86G59G51；G5332发工G1867G726G48G76G70RG82G86G82G73TG57G76G86G88G68G79STG88G71G76G82200G27；WEG69G7393G2165G3132G726G55G82G80G70G68T；综G2524G5332发G7424系统G5224G11004到NETG6228G7427对G5332发环境的要求的考虑，在G6228G7427G990是可行的，G13792G1000可G19764性G5468高2A1184。222经济可行性G7424系统是G1038G7053便管理员对教学资源进行管理，运行G16825G5224G11004软G1226，G2375可G1363G11004，系统成G7424G17751G4581，G13792当G6249入运行后便可G1038学G7669的教学资源管理G14422G13434大量的人G2159，G10301G2159。系统G6164G5114G7481的效G11422G17840G17840大于系统软G1226的G5332发成G7424，G7053便有效，简单G7143行。223操作可行性G7424系统G13475过G1192细的G2010G7524后G6164设计的G11040G19766简G8917G9177G7236，G4625可能考虑人G1216G1363G11004G7114的G980些习G5827，G1363得G6817G1328简单，G8611G980个G6817G1328后G18129会对G11004G6155有G6164G2721G5224，数据G16847G2474G9801G8975可G19764，功能规G14551G21796G1852，G1363G11004G4493G7143。A119A121A123A124A125A126A127A128A129A130A131A13243系统构架及开发工具简介31应用系统架构方式311B/S架构概述G7424系统采G11004G8995G16284G3132/G7393G2165G3132G7562G7512G7053式实现。B/SG7562G7512G7053式G11013G8995G16284G3132和G7393G2165G3132组成。G8995G16284G3132是G15932G12046G4630，在G15932G12046G4630G1025包G2559了系统的G7186G12046G17935G17765。G4439的G1231G2165是G11013G8995G16284G3132G2533G13605G13488G990的G7588G980WEG69G7393G2165G3132G6564出G7393G2165G16843求，WEG69G7393G2165G3132对G11004G6155G17535G1233进行G20576G16789后G11004G43G55G55G51G2339G16770G6238G6164G19668的主G20041传送给G4470G6155G12483，G4470G6155G12483接受传G7481的主G20041G7003G1226，并G6238G4439G7186G12046在G8995G16284G3132G9905。教学资源管理系统采G11004此G7512G7562G7053式主要G3534于以G991G1972G9869考虑G726G321在G7393G2165G3132G990对数据进行G3800理并G4570G3800理G13479G7536生成G13605G20041，G1363得G4470G6155机G990对数据的G3800理G15999进G980步简化。G4470G6155机G990以G8995G16284G3132G1328G1038G4470G6155G12483的G5224G11004程序实现对数据G7186G12046，G13792不G11004G1889G1038G4470G6155G12483单G10432编写和安G16025G1866G1194类型的G5224G11004程序。G322G11013于数据的G3800理、G4396G1660G18129是在G7393G2165G3132G990G4448成，G3252此G4570G7481对系统G11G7092论是硬G1226G17836是软G1226G12的G2331G13435G18129G2494是对G7393G2165G3132进行。G6164以，G13605G13488G5224G11004软G1226G7143于管理和维护，G13792G1000G6205展性G3921。312系统体系结构教学资源管理系统G7380G5225G4630是G13605G13488G6817G1328系统WG76NG71G82G90G86G91G83SERVER；G12544二G4630是数据库系统G4630；G12544三G4630是数据库接G2487G4630，G17902过G5224G11004G7393G2165G3132G4570数据信息采集到G2520接G2487系统G1025；G12544四G4630G1038G7393G2165G4630，G17902过G68G86G83与G5224G11004G7393G2165G3132进行信息G1144G6454，同G7114G17902过G43G55G55G51与BRG82G90G86ER进行信息G1144G6454；G12544G1128G4630G1038G11004G6155G4630，G4439G19766G2533G7380G13468G11004G6155，G17902过G11004G6155G20041G19766与系统进行信息G1144G6454。G3252此G16825系统设计包括G11004G6155G20041G19766设计G708G2081G2500G20041G19766G709、数据库设计、G5224G11004程序设计G708后G2500G20041G19766G709。数据库G1313于G16825系统WEG69G12461G9869的数据库G7393G2165G3132G990，G11004G6155G11040G19766G1313于WEG69G7393G2165G3132G990，WEG69G7393G2165G3132和数据库G7393G2165G3132可同G3800于同G980G10301理G7393G2165G3132G990。G6984个系统G11013WEG69G7393G2165G3132统G980进行管理和发送，G11004G6155G17902过G8995G16284G3132以G43G55G55G51G2339G16770G2533SERVER发送G16843求，并接收和G7186G12046SERVERG6564G1391的WEG69信息。在G7393G2165G3132G12483运行G45G68VG68SG70RG76G83TG14062G7424G16833言代码，SQLG2641G1208和G7643准G43G55G48L代码，G17902过G45DBC驱动程序，连接到支持G45DBC的数据库G7481G4396G2474G13605G13488数据库。A133A135A136A137A138A139A140A142A143A144A145A1465系统体系G13479G7512如G991G32821G6164G12046A147A149A151A153A154A151A155A15632开发工具简介321系统开发技术JSPG57C模式G7380早G11013G55RYGVEREENG86KG68G88G在1974年G6564出过G4570G5224G11004程序G2010G1038模型、G16282G3282和G6523制G3132，化繁G1038简的工G1328更G2164轻松。G17902过G1363G11004G980G12193G17902过单G980G6523制G3132G3800理WEG69G5224G11004程序G16843求的G2081G12483G6523制G3132模式。这G1363G5332发人员可以设计G980个支持丰富路G11013G3534G11796G13479G7512的G5224G11004程序。322SQLSERVER简介G3534于WEB的教学资源管理系统是以SQLSERVER200G27G1328G1038G5191G2500G5332发的教学资源管理系统，适G2524G980G14336规模学G7669G1363G11004。SQLSERVER是G980个G1863系数据库管理系统。SQLSERVER是G980个G1852G19766的、集成的、G12483到G12483的数据G16311G1927G7053案，G4439G1038G11004G6155G6564G1391G980个安G1852、可G19764和高效的G5191G2500G11004于数据管理。G7424系统采G11004的数据库G6228G7427G1038G45DBCG11G45G68VG68DG68TG68BG68G86ECG82NNEG70TG76VG76TYG12。G45DBCG11G45G68VG68DG68TG68BG68G86ECG82NNEG70TG76VG76TYG12是G980G12193能G17902过G45G68VG68G16833言访G19394G13479G7512化数据库的G5224G11004程序接G2487G708G45DBCAG51IG709。数据库驱动程序类型G1038G726G7424地AG51I部G2010G45G68VG68驱动程序7A1579。A158A159A161A162A163A164A166A167A168A170A171A17264概要设计41系统具体功能411系统的整体功能模块G321G11004G6155登录模块G322G1856G2590信息管理模块教参信息G708教程、课G1226G709管理模块资G7021G990传模块个人信息管理模块G11705道吧信息管理模块412系统的不同用户操作权限介绍G321管理员G726G7424系统管理员登录G13475审核G17902过后可以进行G726G8995G16284、添G2164、删除、修改G1856G2590、教程、课G1226G12573信息；G8995G16284、添G2164、删除、修改G11705道吧版块G2462版主信息；查询、添G2164、删除G11004G6155信息；G8995G16284、添G2164、删除管理员信息、修改管理员密码；审核G11004G6155G990传的资G7021G12573G6817G1328。G322教G5084G726G8995G16284管理员发G5079的G1856G2590信息，根据G19668要可选择G991G17745并保G4396G1856G2590G1867体内G4493；G8995G16284、G991G17745教程和课G1226；G990传教程、课G1226；在G11705道吧按不同G19394G20076G2010类G7053式G8995G16284G19394G20076、G6564出G19394G20076和G6564G1391G19394G20076G16311G12584信息。学生G726G8995G16284管理员发G5079的G1856G2590信息，根据G19668要可选择G991G17745并保G4396G1856G2590G1867体内G4493；G8995G16284、G991G17745教程和课G1226；G990传教程、课G1226；在G11705道吧按不同G19394G20076G2010类G7053式G8995G16284G19394G20076、G6564出G19394G20076和G6564G1391G19394G20076G16311G12584信息。访G4470G726匿名访G4470登录后，可以G8995G16284G1856G2590、教程、课G1226、G19394G20076G12573信息，G7092权进行添G2164、删除G12573G6817G1328。413系统整体界面设计G321G6984个G13605G12461的G20041G19766G5079局简G8917明了，风格大体G980致，色彩搭配G14270然G2339调，让G11004G6155G1363G11004起G7481感觉G1852舒适G14270然。G322G2520G2010G20041G19766G1055G19400皆有导航条链接，G7053便已G13475登录的G11004G6155在G2520个G20041G19766G1055G19400G14270G11013跳G17728翻G11487。A173A174A175A176A178A179A180A181A182A183A184A185742系统整体结构设计G3534G7424系统模型如G32822G6164G12046G726A186A187A188A189A190A191A192A193A186421一般用户登陆操作流程介绍G980G14336G11004G6155G708G15999授权的教G5084G6122G13785学生G11004G6155G709登陆G6817G1328G8981程如G32823G6164G12046G726A186A194A195A196A197A198A199A200A201A202A203A204A186G32823注释说明G726G1856G2590信息模块G726G980G14336G11004G6155G9869击G1856G2590G7643G20076链接可以G8995G16284G1856G2590，可根据G19668要选择要G991G17745、保G4396的G1856G2590内G4493；个人信息管理模块G726G980G14336G11004G6155进入个人信息后，在备忘录G1025可以添G2164、删除、修改G14270己的备忘录信息。在留言箱G1025可以阅G16284收到的留言信息、删除留言、给G1866G1194G11004G6155发送留言信息；G990传模块G726G980G14336G11004G6155可以进行教参资G7021的G990传，此功能主要是实现教学资源的共享，教G5084可以G7053便地G17902过此模块实现课G1226的G990传，G1391学生G991G17745，以G6564高教学效率；教参信息模块G726G7424系统G4570教参信息G2010G1038教程和课G1226两大类。学生G11004G6155可以G8995A205A206A207A208A209A210A211A212A213A214A215A216A217A218A219A220A213A221A222A216A217A223A224A212A225A226A227A228A216A217A229A230A231A232A233A234A227A235A236A237A238A239A236A237A240A241A242A243A244A245A242A243A246A247A248A249A250A251A252A253A254A255A10A0A1A28G16284、G991G17745选择的教程、课G1226信息进行学习，教G5084G11004G6155可以G8995G16284、G991G17745G2520G12193教程、课G1226信息，包括G2520G12193课G1226制G1328G13044G7460G12573；G11705道吧模块G726G11004G6155登陆以后，可以G8995G16284G19394G20076、回G12584G19394G20076，G1075可以G6564出G19394G20076。实现G11004G6155G19400的非实G7114的G1144G1126。422一般用户登陆后台验证流程介绍G980G14336G11004G6155登陆后G2500G20576G16789程序G8981程如G32824G6164G12046G726A3A25A15A4A5A6A7A8A9A11A12A13A14A16A3A17A18A19A20A21A22A23A24A26A27A28A299423管理员用户登陆流程介绍管理员G11004G6155登陆G6817G1328G8981程如G32825G6164G12046G726A30A31A32A33A34A35A36A37A38A39A40A30G32825注释说明G726G7003章管理G1025G7003章指G726G990传的G1856G2590、教程和课G1226三G12193G7003G1226资G7021。43数据库设计数据库在G6984个管理系统G1025占有非常G18337要的地G1313,数据库G13479G7512设计的G3921坏G4570直接对G5224G11004系统的效率以G2462实现的效G7536产生影G2721。G2524理的数据库G13479G7512可以G6564高数据G4396G1660的效率,保G16789数据的G4448G6984和G980致。在数据库建立G7114,大体G990选建立G980个总体的数据库G4396G7003G1226,以便统G980调G11004数据库连接G16833句10A4111。431逻辑设计G16825系统有三个不同G11004G6155G17535G1233，G2010别G1038学生、教G5084和管理员。G8611个不同的G17535G1233的G11004G6155权限不同。在系统G11004G6155G1025，学生G11004G6155和教G5084G11004G6155共G11004G980个G15932，除学生学号、教G5084工号、姓名、登陆密码G12573登录必G19668信息外，G17836有在G11705道吧G1025涉G2462到的积G12573G13435G12573G1867体信息。管理员则G2494G19668要G11004G6155名和密码。另外，备忘录、留言箱、G990传G7003章G12573模块G17836要有不同的G15932G7481G4396G1660信息。G13475过G2010G7524，初步设计如G991G15932G726A42A43A44A45A46A47A48A42A43A49A50A42A43A51A52A42A43A53A54A42A43A44A42A43A55A56A47A48A57A58A47A48A59A60A47A48A61A62A47A48A59A60A63A50A59A60A63A64A61A62A63A50A57A58A63A50A65A66A51A52A67A68A57A58A42A43A44A67A68A61A62A42A43A44A67A68A55A56A42A43A44A67A68A57A58A51A52A67A68A61A62A51A52A67A68A59A60A69A70A71A72A73A74A75A76A73A74A77A78A79A80A81A82A83A84A85A86A87A88A89A90A91A92A93A9410G321管理员G3534G7424信息G15932G11G68G71G80G76NG12包括G726管理员编号、管理员G11004G6155名、密码、G990次登录G7114G19400、G7380近登陆G7114G19400、登陆次数G12573信息；G322普G17902G11004G6155信息G15932G11TG86_G88G86ERG12包括G726G11004G6155编号、学号G6122G13785工号、姓名、密码、昵称、G11004G6155积G2010、G11705道吧G12573G13435、G11004G6155G17535G1233G7643G16794G12573信息；G7003G1226信息G15932G11TG86_G68RTG76G70G79EG12包括G726G7003G1226编号、G7003G1226G7643G20076、G7003G1226内G4493、G990传G7003G1226G1328G13785姓名、创建G7114G19400、G7003G1226G1852称、G7003G1226G6164属版块编号G7081G726G1856G2590类，2G726教程类，3G726课G1226类G709、G7003G1226G9869击次数；G7003章类别信息G11TG86_G86G82RTG76G71G12包括G726类别编号、类别名称；备忘录G7003G1226信息G11TG86_G