计算机实验课在线答疑系统的分析与设计
摘要：网上答疑系统为基于ASP.NET与C#技术的WEB应用程序，并以互联网为传播媒介来实现远程教育的一个教学平台。系统主要论述了其设计开发的基本过程，设计开发中主要运用了ASP.NET技术与C#语言、 SQL等相关技术，根据面向对象开发原理，采用了基于B/W/S三层体系结构的开发模式系统。以IIS为服务器，SQL server 2005为数据库平台，提供一个师生之间相互交流、相互探讨的网络空间,使学生在获取知识时更具有主动性。本系统包括即时答疑的管理与控制，文件资源的共享管理，问题及疑问留言解答的管理，后台数据库信息的管理维护等这些基本模块。
关键词：ASP.NET；在线答疑；实验室信息化；B/W/S结构
注：本论文（设计）题目来源于教师的国家级（或省部级、厅级、市级、校级、企业）科研项目，项目编号为： 。
Experimental computer courses o nline Q & A System Analysis and Design
Abstract: Online Q & A system based on ASP.NET and C # technologies WEB applications, and Internet media to achieve a long-distance education teaching platform. Focuses on system design and development of its basic processes, design and development of the main use of ASP.NET technology and C # language, SQL and related technologies, in accordance with the principle of object-oriented development, based on the use of B / W / S three-tier architecture system development model. To IIS server, SQL server 2005 database platform to provide a mutual exchange between teachers and students, to explore each other in cyberspace, so that when students acquire knowledge in a more proactive. The system includes real-time Q & A management and control, file-sharing management resources, problems and answer questions about the management of message, the background database information such as the management of the maintenance of the basic module.
Keywords: ASP.NET online Q & A of laboratory information B / W / S Structure
目 录
1 前言 6
2 设计前分析 7
2.1 需求分析 7
2.2 系统开发工具及思路 7
2.3 实现可行性分析 8
3 系统总体设计 9
4 系统详细设计 11
4.1 数据库设计 11
4.1.1 数据表的设计 11
4.1.2 数据库表间的逻辑关系图 13
4.2 系统主要功能模块详细设计与实现 13
4.2.1 前台主要功能模块介绍 13
4.2.2 后台主要功能模块介绍 21
参考文献 26
致谢 27
1 前言
计算机实验课在线答疑系统采用sql2005+asp.net为设计开发平台，主要为计算机机房提供一个利用现有设备进行课程教学，师生互动问答讨论的系统。通过相应功能模块实现问题的实时或留言问答，实验内容等文件资源的共享上传与下载，以及相关知识拓展，师生在电脑前就能完成全程教学，使学生摆脱了以前的羞涩心理,主动参与到网络学习活动中来,有效地调动了学生学习的积极性。同学与同学之间、教师与同学之间的讨论既活跃了思维,也拉近了彼此的距离,促进了教学活动的开展。本系统基于网络教学支撑平台的教学模式具备人机互动、师生互动的优势，体现出以人为本，自主学习的特点，突破时空界限，延伸课堂空间，拓展思维方法，有利于培养善思考、高素质的综合人才，适应信息时代教育发展的要求。
3.3系统总体流程
用户成功登录后，如果验证是管理员身份，则可选择进入前台显示还是后台管理，如果是普通用户，则定向到系统前台首页。
在首页里，默认是即时发言页面，也可通过页面链接到文件共享或者查看疑问页面。
在即时发言页面，可以选择发言字体的颜色，切换群聊和密谈模式。在文件共享页面，显示现有的文件列表，右击文件名即可选择下载，点击上传文件按钮，进入文件上传页面。
在查看疑问页面，可以发表疑问或者点击相应疑问，进入详细回答页面。各页面中，都包含返回主页面的链接按钮。
Computer experimental courses online Answering System Analysis and Design
Abstract: Online Q & A system based on ASP.NET and C # technology, WEB applications, and to the Internet for the media to achieve the long-distance education as a teaching platform. System is mainly discussed the basic process of its design and development, design and development of main use of the ASP.NET technology and C # language, SQL and related technologies, according to principles of object-oriented development, using based on B / W / S three-tier architecture of the development of model system. In IIS for the server, SQL server 2005 as the database platform, providing a mutual exchange between teachers and students with each other to explore cyberspace, so that students in acquiring knowledge is more proactive. The system includes real-time Q & A management and control, file sharing of resources management, answer questions and queries a message management, back-end database of information management and maintenance of these basic modules.
Keywords: ASP.NET; Online Q & A; laboratory information; B / W / S Structure
Note: This paper (design) the subject of teachers from national (or provincial level, departmental level, municipal, field-grade, enterprise) research project, the project number is:.
Experimental computer courses o nline Q & A System Analysis and Design
Abstract: Online Q & A system based on ASP.NET and C # technologies WEB applications, and Internet media to achieve a long-distance education teaching platform. Focuses on system design and development of its basic processes, design and development of the main use of ASP.NET technology and C # language, SQL and related technologies, in accordance with the principle of object-oriented development, based on the use of B / W / S three-tier architecture system development model. To IIS server, SQL server 2005 database platform to provide a mutual exchange between teachers and students, to explore each other in cyberspace, so that when students acquire knowledge in a more proactive. The system includes real-time Q & A management and control, file-sharing management resources, problems and answer questions about the management of message, the background database information such as the management of the maintenance of the basic module.
Keywords: ASP.NET online Q & A of laboratory information B / W / S Structure
Directory
1 Introduction 6
2 Design Analysis of seven pre -
2.1 Demand Analysis 7
2.2 The system development tools and ideas 7
2.3 Feasibility Analysis to achieve 8
3 System Design 9
4 system detailed design of the 11
4.1 Database Design 11
4.1.1 Design of data table 11
4.1.2 the logical relationship between database tables Figure 13
4.2 The system is mainly the detailed design and implementation of functional modules 13
4.2.1 Introduction 13 front main function modules
4.2.2 Introduction 21 Background main function modules
References 26
Thanks 27
1 Introduction
Computer experimental courses online Q & A system uses sql2005 + asp.net for the design and development platform, primarily for the computer room to use existing equipment to provide a curriculum of teaching, teachers and students an interactive Q & A discussion of the system. The corresponding function modules through the realization of real-time or message questions and answers, test the contents of the file sharing of resources such as uploading and downloading, as well as to expand knowledge, teachers and students in front of the computer will be able to complete a full course of teaching so that students from the previous shy psychology, take the initiative to participate in learning activities in the network to effectively mobilize the enthusiasm of students. Students and between students, teachers and students in discussions between both active thinking, closing the distance between us and promote the teaching activities. This system is based on the teaching-learning mode of supporting platform with human-computer interaction, student-teacher interaction strengths reflect the people-oriented, self-learning features, breaking time and space boundaries, extending the classroom space, expanded way of thinking will help foster good thinking, high-quality a comprehensive human resources to meet the requirements of development of education in the information age.
3.3 The overall system flow
After the user successfully logs on, if the verification is an administrator, you can choose to enter the foreground or background display management, if an ordinary user, then directed to the system front page.
On the home page, the default is a real-time speech pages, also available through the page link to a file share or view questions page.
In real-time speech page, you can choose the font color of the floor, switch group chat and private discussion mode. In the File Sharing page, showing the existing list of files, right-click the file name you can choose to download, click the Upload file button, and enter the file upload page.
View the page in question may be published or click on the appropriate questions of doubt to enter a detailed reply to the page. Each page, return to the main page contains a link to the button.
