摘要
随着高校教学改革的深入,实验教学管理范围不断扩大,其内容涵盖了实验用房、实验课程、实验项目、资源共享等诸多元素。面对繁杂的实验教学管理工作,传统管理模式的弊端逐渐显露出来,亟需使用功能完善、数据高度共享、扩展性好、基于网络的实验教学管理系统,方便学生获取实验教学信息和开展实验,提高教学效率和资源共享程度,减轻实验管理人员和教师的工作负担,充分发挥实验示范中心的辐射作用。
为进一步提高信息化管理水平,本文综合了对西南交通大学国家级机械基础实验教学示范中心的需求调研结果和几年来的建设经验,采用ASP.NET 3.5与SQL SERVER2008相结合,开发建设了信息化管理平台。信息管理平台的结构由客户端层、应用逻辑层、数据库层3个层次组成,具有易扩展、易维护、智能化、开放化和安全可靠等特点。
本文首先介绍了设计与开发实验中心信息化管理平台的开发环境与理论基础,其中理论部分包括ASP.NET概述、ASP.NET AJAX技术简介、ADO.NET技术以及关系数据库技术,然后简单阐述了信息化管理平台的系统分析和体系结构设计,系统分析包括可行性分析与需求分析,为系统设计与实现提供了方向和目标。系统的体系结构设计部分提出了B/S模式开发系统的总体思路,并介绍了体系结构的设计目标。一个成功的管理信息系统,数据库设计的好坏是关键。本文的系统设计部分较为详细地阐述了数据库设计原则与系统的数据库设计,详细设计了各功能模块。系统功能实现部分给出了系统功能的具体实现方法,包括采用ASP.NET和JavaScript脚本语言混合编写的方法开发实现前台页面中心图片的自动间隔刷新,用Ajax技术实现下拉列表框的无刷新联动,用C#语言编写后台代码,实现数据批量导入等等。这些功能的实现充分体现了ASP.NET技术开发信息系统项目效率高的优势,同时也为.NET平台下基于B/S模式的信息管理系统的开发提供了一套开发框架。
本信息管理平台经多方调试、试运行、完善补充相关内容,目前已投入正式使用,收到较好的使用效果,有效提升了实验中心的信息化管理水平。
With the gradual promotion of college teaching reform, experimental teaching management scope has been expanding constantly and includes a series of elements, such as experiment rooms, courses, experiments, resource sharing and so on. Traditional management model is no longer able to solve such complicated experimental teaching management work. A new web-based experiment teaching management system is needed which has perfect function, high level of data sharing and easy extension. This new system is very convenient for students to get information and select experiments and can improve teaching efficiency, increase the extent of source sharing, reduce experiment management staff and teachers'workload and better ensure its exemplifying role.
To improve the information management level, a new platform has been developed by adopting ASP.NET 3.5 and SQL SERVER 2008 on the basis of sufficient investigation and construction experience which the National Experiment Center of Mechanical Basis at Southwest Jiabtong University has got in recent years. The system structure consists of client layer, application logic layer and database layer, featuring easy extension, easy maintenance, openness, intellectualization, high safety and reliability, etc.
Firstly, the development environment and theories to design and develop an information-based system for experiment center are introduced in detail, including ASP.NET framework, ASP.NET AJADX, ADO.NET technology and relational database technology.
Secondly, structure design and system analysis including feasibility analysis and requirement analysis are described in brief. The requirement analysis provides goal and direction for the design and implementation of the system while the structure design presents a general idea of B/S model to develop the system and its purpose.
Thirdly, functional modules design and database design are introduced in the system design section. Since a successful information system depends on the quality of database design, the database design rules and its design are discussed in detail.
Finally, the implementation methods of the management system are elaborated, including the application of ASP.NET and JavaScript language to develop automatic interval refresh of center pictures of the front interface, Ajax to fulfill non-refresh linkage, C# to develop the back stage code and achieve the data importation. The implementation procedure above fully displays the high-efficiency superiority of ASP.NET platform to develop information system projects and supplies a suite of development framework for system based on the B/S model on the.NET platform.
By constantly debugging, trial operation and improvement, the system has been formally put into use and obtained good application effect which has improved the information management level of the Experiment Center.
引文
[1]肖夏.实验室综合管理系统的设计与实现[D].重庆大学.2009.04.
[2]王茂蛟.实验室综合管理系统的设计与实现[D].电子科技大学.2008.12：2.
[3]Ferraiolo D,Kuhn R. Role-Based access control[J].Proceedings of the 15th National Computer Security Conference.Baltimore,MD,1992:554-563
[4]Abraham SibersFig.z,Henry F.Korth. Database System Concepts[M].The McGraw-Hill Companies,Inc.
[5]蔡明山.高校实验室综合管理系统研究与设计[D].湖南大学.2003.09：2-3.
[6]胡勇辉,曹倬璜,兰湘涛ASP.NET开发实战详解：入门、模块、系统[M].电子工业出版社,2006.07.
[7]吕洋波ASP.NET 2.0宝典[M].电子工业出版社,2007.
[8]李和平.基于.NET平台的电子政务系统的研究与实现[D].电子科技大学.2006.06：17-18.
[9]刘乃丽.精通ASP.NET 2.0+SQL Server 2005项目开发[M].人民邮电出版社,2007.05：10-11.
[10]罗艳玲.基于ASP.NET的通用型中小企业管理信息系统的研究[D].武汉理工大学.2008.05.
[11]K.W.VanVuren. an empirical investigation of the effeetiveness of enierprise resource planning(ERP)systems,as assessed by management accountants[D].Ameriea:the university of Mississippi,2003.12.
[12]浦卫,吴豪SQL Server 2005开发者指南[M].科学出版社,2008.06：58-59.
[13]HeGuo,FengChen,YuxinWang. A Reusable Software Architecture Model for manufactory Management Information System.IEEE Computer Society.2002.
[14]房春英.基于.NET组件技术的实验室信息管理系统的分析与设计[D].吉林大学.2007.06：19.
[15]Ronald E.Barnett,LABORATORY SOFTWARE IMPLEMENTATION IN REGULATED INDUTRLES,Jossey Bass Publishers,1999:12-15
[16]王继成,高珍.软件需求分析的研究.计算机工程与设计[J].2002,23(8)：1.
[17]Pressman R S.Software Engineering:A Practitioner's, AP-proach[M].New York:eGraw-Hill,Inc,1992.
[18]Robert SA.software Engineering[M].Los Alamitos:IEEE Computer Society Press,1993.
[19]陈冠军.精通ASP.NET 2.0企业级项目开发[M].人民邮电出版社,2007.02：39.
[20]徐军,刘瑞斌,王春燕.国家级基础化学实验教学示范中心网站的开发[J].实验技术与管理,2007.12,12(24)：2.
[21]张旸肠.大型灌区基础数据库的设计[D].河海大学.2006.03：8-9.
[22]Microsoft Technet [EB/OL]. http://www.microsoft. com/china/tech-net/itsolutions/ techguide/msm/smf/smfjobsc.mspx.
[23]马保国,贾寅波,乔玲玲.存储过程解决疑难算法问题[J].软件导刊,2009.05,8(5)：58.
[24]孙娜,曹君.存储过程的数据库安全性应用研究[J].计算机与数字工程,2009(3)：155.
[25]袁苏亮,章民融.运用存储过程和作业调度实现数据库的高级管理[J].计算机应用与软件,2008.09,9(25)：152.
[26]张艳花,钟一环,徐淑华.电工电子实验教学中心的信息化管理[J].实验技术与管理,2009.04,4(26)：106-107.
[27]邬文瑜.基于.NET的企业级门户网站设计与实现[D].吉林大学.2005.04：32.
[28]康亚,邵康,吴满意.一种高效的Excel表导入数据库的实现方法[J].电脑知识与技术,2008.06.
[29]黄湘情,谢琳,张静妍SQL Sever 2005管理员手册[M].人民邮电出版社,2009.01：287.
[30]李烨.别具光芒DIV+CSS网页布局与美化[M].人民邮电出版社,2006.11.
[31]李烨.别具光芒CSS属性、浏览器兼容与网页布局[M].人民邮电出版社,2008.10.
[32]卢成均ASP.NET中Repeater控件高级应用研究[J].重庆工商大学学报(自然科学版),2006.08,23(4)：360.
[33]微软官方支持网站.Web服务器控件模板[EB/OL]. http://msdn.microsoft.com /library/chs/default. asp?url=/library/CHS/vbcon/html/vbconwebformscontrolstemplates. asp,2006-03-01
[34]周辉山,文秀ASP.NET中用TreeView控件实现树目录的方法研究[J].福建电脑,2007,1：88.
[35]李万宝ASP.NET 2.0技术详解与应用实例[M].兵器工业出版社,2007.02：246.
[36]明日科技,张跃廷,王小科等ASP.NET数据库系统开发案例精选[M]：人民邮电出版社,2007.01：95-96.
[37]Henderson,K. TheGuru's Guide to Transact-SQL[M].北京：中国电力出版社,2002.
[38]Teeter,T.A.Teaching on the internet.Paper Presented at the Fall Conferene of the Arkansas Assoeiation of College of Teacher Edueation.ERIC Doeument Reproduction Service No.1997:418—957P.
[39]RJ Keeble,RD Macridie.Assistant agent for the world wide web intelligent interface design challenges.Interacting Computers.2000(12):357—381P.
[40]RamanthanP,ShinK.G.On the knowledge Database in Future ICAI system. Information System.2002(12):135—142P.
[41]Raghu R, Johannes G.Database management system (2nd Ed)[M].USA:McGraw-Hill Companies,2000:383-392.
[42]A.Matta and Y.Dallery. Analysis of assembly systems controlled with kanbans.European Journal of Operation Research,vol.3,2004:1-27.