网站导航网学 原创论文 原创专题 网站设计 最新系统 原创论文 论文降重 发表论文 论文发表 UI设计定制 论文答辩PPT格式排版 期刊发表 论文专题
返回网学首页
网学原创论文
最新论文 推荐专题 热门论文 论文专题
当前位置: 网学 > 设计下载 > ASP类作品 > 正文

ASP+SQL新闻系统设计+论文ASP+SQLinformationsystemsdesign+Papers-ASP

论文降重修改服务、格式排版等 获取论文 论文降重及排版 论文发表 相关服务

第一节  系统功能描述

新闻发布及管理系统包括新闻类别管理、新闻发布管理、图片处理、新闻查询、网友评论和用户管理等模块。具体描述如下:

1.新闻类别管理:

(1)新闻类别的录入,包括类别编号和类别名称等信息;

(2)新闻类别的修改;

(3)新闻类别的删除;

(4)新闻类别的查询。

2.新闻发布管理:

(1)基本新闻信息的录入,包括新闻标题、新闻内容和所属类别等;

(2)基本新闻信息的修改;

(3)基本新闻信息的删除;

3.图片处理模块:

(1)选择图片文件;

(2)上传图片文件;

(3)存储图片新闻;

(4)修改新闻图片;

(5)删除新闻图片;

(6)在网页中浏览新闻图片。

4.新闻查询模块:

(1)按照新闻类别分页显示新闻;    -

(2)按照日期分页显示新闻。

5.网友留言模块:

(1)网友对某条新闻发表评论;

(2)管理员可以删除新闻评论。

6.系统用户管理功能:

(1)系统用户信息的录入,包括用户名和密码等信息;

(2)系统用户信息的修改;

(3)系统用户信息的删除。







目  录 第一章  诸论 3

第一节  开发工具的选用及介绍 3

第二节  ASP技术访问WEB数据库 4

第二章  系统分析与总体设计 8

第一节  系统功能描述 8

第二节  系统功能模块划分 9

第三节  系统流程分析 11

第三章  数据库结构设计与实现 12

第一节  创建数据库 12

第二节  数据库逻辑结构设计 13

第三节  创建表的脚本文件 15

第四章  目录结构与通用模块 17

第一节  目录结构 17

第二节  通用模块 18

第五章  系统主界面与登录程序设计 23

第一节  设计主界面 23

第二节  登录程序设计 28

第三节  设计管理界面 29

第六章  新闻类别管理模块设计 35

第一节  设计新闻类别管理界面 35

第二节  添加新闻类别 39

第三节  修改新闻类别 41

第四节  删除新闻类别 42

第七章  新闻发布管理模块设计 45

第一节  添加新闻 45

第二节  修改新闻 50

第三节  删除新闻 52

第四节  新闻查询管理 53

第八章  调试与安装 63

第一节  安装IIS. 63

第二节  ASP硬件要求 64

结束语 65

参 考 文 献 66

后    记 66

 

摘要

【摘要】我们从建站的实际情况出发,经过对有关网站新闻发布事项的一番考察和分析,确立了新闻发布系统的具体实现功能。并阐述系统的结构设计和功能设计,实现新闻的分类显示,最近新闻的提示,新闻滚动功能等。经过授权的用户可以通过Web浏览器,以人机交互式的客户端程序实现对学校新闻的发布、管理、实时的进行行为统计和记录。本系统是学校网站的一个子系统,具有很好的外部接口,能够很好的配合站点的其它子系统服务于网站的新闻发布.该系统是一个基于新闻发布和内容管理的全站管理系统;基于B/S模式WEBMIS系统,本系统可以将杂乱无章的信息(包括文字、图片和影音)经过组织,合理而且有序地呈现在大家面前。简单的说,新闻发布系统就是充当一个网络新闻媒介的功能。

主要实现对新闻的分类,审核,发布,模拟了一般新闻媒介的发布的过程

【Abstract】  we embark from the station construction actual situation,pass through to a related website news issue item inspection and theanalysis, has established the news issue system concrete realizationfunction. And the elaboration system structural design and thefunctional design, realize the news classification to demonstratethat, the recent news prompt, the news rolls the function and so on.After the authorized user may through the Web browser, by theman-machine interactive customer end procedure realization to theschool news issue, the management, real-time carry on the behaviorstatistics and the record. This system is a school website sub-system, has the very good exterior connection, can the very goodcoordinate stand other subsystems serve the website news issue This system is based on the news issue and the content managemententire station management system management system; Based on B/S thepattern WEBMIS system, this system may the chaotic information(including writing, picture and video and music) the processorganization, reasonably has the foreword to present in front ofeverybody. Simple saying, the news issued the system is acts as a NetNews medium the function, the main realization to the newsclassification, the verification, the issue, has simulated the commonnews medium news issue process

前言

在Internet飞速发展的今天,互联网成为人们快速获取、发布和传递信息的重要渠道,它在人们政治、经济、生活等各个方面发挥着重要的作用。Internet上发布信息主要是通过网站来实现的,获取信息也是要在Internet“海洋”中按照一定的检索方式将所需要的信息从网站上下载下来。因此网站建设在Internet应用上的地位显而易见,它已成为政府、企事业单位信息化建设中的重要组成部分,从而倍受人们的重视。

由于时间有限,加之信息系统开发经验的缺少和编程能力的有限,所以本系统难免存在各种各样的缺点。敬请指导老师能够提出批评和宝贵意见,也希望各位读者提出宝贵意见并进行指正,谢谢!

第一章  诸论

第一节  开发工具的选用及介绍

1. ASP的优势:Active Server Pages:“动态服务器网页”,一般简称为“ASP”,ASP之所以能受到大家的重视与使用的原因,主要在于所产生的执行结果都是标准的HTML格式,而且这些程序是在网络服务端中执行,使用一般的浏览器(如IE 或Netscape)都可以正确地获得ASP的“执行”结果,并且将这ASP执行的结果直接在浏览器中“浏览”,不像VBScript或 JavaScript是在客户端(Client)的浏览器上执行,若使用VBScript来设计程序,客户端(Client)在IE浏览器中可以显示程序执行的结果,可是,客户端(Client)若使用Netscape浏览器就无法显示VBScript的执行结果。
    2.ASP的特点:任何开发工具皆可发展ASP。只要使用一般的文书编辑程序,如Windows记事本,就可以编辑。当然,其他网页发展工具,例如,FrontPage Express、 FrontPage等也都可以;不过还是建议你用记事本来写,既省钱又方便,若是使用那些所见即所得的网页编辑来写ASP,可能会发生一些意想不到的离奇状态。

3.通吃各家浏览由于ASP程序是在网络服务器端中执行,执行结果所产生的HTML文件适用于不同的浏览器。
    4.语言相容性高:ASP与所有的ActiveX Script语言都相容,除了可结合HTML,VBScript、Java Script、Active X服务器组件来设计外,并可经由“plug-In(外挂组件模组)的方式,使用其他厂商(Third Party)所提供的语言。
隐密安全性高。如果我们在浏览器中直接查看网页的原始代码,就只能看到HTML文件,原始的ASP程序代码是看不到的!这是因杰ASP程序先于网站服务(Web Server)端执行后,将结果转换成标准HTML文件,再传送到客户端(Client)的浏览器上,因此,我们所辛苦撰写的ASP程序并不会轻易地被看见进而被盗用。
    5.易于操控数据库:ASP可以轻易地通过ODBC(Open Database Connectivity)驱动程序连接各种不同的数据库,例如:Acess、Foxpro、dBase、Oracle等等,另外,ASP亦可将“文本文件”或是”Excel” 文件当成数据库用。
    6.面向对象学习容易:ASP具备有面向对象(Object-Oriented)功能,学习容易,ASP提供了五种方便能力强大的内建对象:Request、Response、Sever、Application以及Session,同时,若使用ASP内建的“Application”对象或”Session”对象所撰写出来的ASP程序可以在多个网页之间暂时保存必要的信息。
    ASP的六大内部对象Request、Response、Server、Session、Application、ObjectContext 从客户端取得信息将信息送给客户端提供一些Web服务器工具储存在一个Session内的用户信息,该信息仅可被该用户访问在一个ASP-Application中让不同的客户端共享信息可以用来配合Microsoft Transaction 服务器进行分布式事务处理。
    所以我选择了ASP结合Frontpage架构网站。在此期间本人将使用Macromedia Dreamweaver MX 2004进行ASP页面的编码,并使用IIS6.0对页面进行调试。

第二节  ASP技术访问WEB数据库

一.访问WEB数据库的多种方案

目前在WINDOWS环境下有多种访问WEB数据库的技术,主要有:

(1).公共网关接口CGI(Common Gateway Interface)

CGI是较早实现的技术。适用于多种服务器平台,如UNIX、WINDOWS等,但CGI的开发成本高、维护困难、功能有限、不具备事务处理功能、占用服务器资源较多。

(2). INTERNET数据库连接器IDC(Internet Database Connector)。

IDC集成在ISAPI(Internet Server API)中,充分利用了DLL技术,易扩充,但编程较CGI更为复杂,只适用于小型数据库系统。

 (3). 先进数据库连接器ADC(Advance Database Connector)

ADC提供了ActiveX Control来访问数据库,它的主要特点是数据查询由用户端浏览器执行,因而需将服务器端数据库中的部分记录下载到用户端,系统开销较大、响应慢,只适用于特别频繁的数据库查询操作。

 (4). JAVA/JDBC语言编程

JAVA语言是一种面向对象、易移植、多线程控制的语言,可通过JDBC去连接数据库。用JAVA/JDBC编写的软件可移植性强,适用于多种操作系统,但其执行效率和执行速度还不理想,目前无法建立高效、高速的应用。

 (5). 动态服务器页面ASP(Active Server Page)

ASP是微软公司最新推出的WEB应用开发技术,着重于处理动态网页和WEB数据库的开发,编程灵活、简洁,具有较高的性能,是目前访问WEB数据库的最佳选择。

Function Description Section System
Press release and management system, including news category management, press release management, image processing, press inquiries, User comments and user management modules. Specifically described as follows:

1. News Category Management:

(1) News categories of entry, including the type number and class names and other information;

(2) News categories of changes;

(3) News categories of deleted;

(4) news categories query.

2. Press Release Management:

(1) basic input of news and information, including news headlines, news content and their respective types, etc.;

(2) basic news and information changes;

(3) basic news and information deleted;

3. Image processing module:

(1) Select image file;

(2) upload picture file;

(3) storage picture news;

(4) Modification of news photos;

(5) to delete news photos;

(6) In the page view news pictures.

4. News Query Module:

(1) According to news category page displays news; --

(2) The page displays news by date.

5. User Comments module:

(1) User comments for a particular news;

(2) The administrator can delete the news commentary.

6. Users of the system management functions:

(1) system user information input, including user name and password information;

(2) system user information changes;

(3) system, the deletion of user information.










Contents Chapter Zhu On 3



Section selection of development tools and introduction 3

Section ASP technology to access WEB database 4

Chapter II Analysis and Design 8

System functions described in Section 8

Section II of the system function modules into 9

Section III system flow analysis 11

Chapter III Design and Implementation of the database structure 12

Section 12 to create a database

Section 13 of the logical database structure design

Create table Section 15 of the script file

Chapter IV directory structure with General Module 17

Section directory structure 17

Universal Module II 18

Chapter V system main interface with the login program design 23

The main interface design section 23

Log in programming Section 28

Section III Design Management Interface 29

Chapter VI News Category Management Module 35

Section Design News Category Management Interface 35

Add a news category II 39

Class III amend the press 41

Section IV removes a category 42

Chapter VII of the Press Release Management Module 45

Add a news section 45

Section 50 amendments news

Section 52 removes

Section IV news about the management 53

Chapter VIII of the debugging and installation of 63

Section I installed IIS. 63

Section ASP Hardware Requirements 64

Conclusion 65

References 66

Postscript 66


















Abstract



Abstract We Jianzhan actual situation, after a press release about the site investigation and analysis of some matters, established the news release system, the specific implementation features. And describes the structural design and functionality of the system design, implementation, the classification of news shows, the recent news tips, news scrolling functions. Authorized users can Web browser in order to man-machine interactive client programs to achieve the school news release, management, real-time behavioral statistics and records. This system is a subsystem of the school site, with a good external interface, can be a very good co-ordination of site services to other subsystems on the website of the press release. The system is based on press releases and content management of the whole station management system; Based on B / S mode WEBMIS system, the system can be chaotic information (including text, pictures, and video) through the organization, reasonable and orderly manner presented in front of everyone. Simply put, the press release system is to serve as a network of media function.


To achieve the classification of the major news, review, publish, simulate the process of the general media release


【Abstract】 we embark from the station construction actual situation, pass through to a related website news issue item inspection and theanalysis, has established the news issue system concrete realizationfunction. And the elaboration system structural design and thefunctional design, realize the news classification to demonstratethat , the recent news prompt, the news rolls the function and so on.After the authorized user may through the Web browser, by theman-machine interactive customer end procedure realization to theschool news issue, the management, real-time carry on the behaviorstatistics and the record. This system is a school website sub-system, has the very good exterior connection, can the very goodcoordinate stand other subsystems serve the website news issue This system is based on the news issue and the content managemententire station management system management system; Based on B / S thepattern WEBMIS system, this system may the chaotic information (including writing, picture and video and music) the processorganization, reasonably has the foreword to present in front ofeverybody. Simple saying, the news issued the system is acts as a NetNews medium the function, the main realization to the newsclassification, the verification, the issue, has simulated the commonnews medium news issue process


Preface


Today in the rapid development of Internet, the Internet become faster access, publish, and an important channel for transmitting information, it''s political, economic, and other aspects of life play an important role. Internet posting of information is mainly achieved through the web site, access to information is also to be in the Internet "sea" in the search according to certain manner the information needed to be downloaded from the web site down. So if your site building in the status of Internet applications is obvious, it has become the Government, enterprises and institutions in the information technology an important part of the building, which oft attention.

Owing to time constraints, coupled with a lack of experience in information systems development and programming capabilities are limited, so this system exists in a variety of shortcomings. Please instructor can give criticism and valuable comments, I also hope my readers valuable advice and make corrections, thank you!

Zhu On the first chapter

Section selection and introduction of development tools

1. ASP advantages: Active Server Pages: "Active Server Pages", generally referred to as "ASP", ASP is able to be everybody''s attention and use of reason, mainly arising from the implementation of the results are the standard HTML format, and that these procedures are performed in the network server, use the normal browser (such as IE or Netscape) can be correctly received ASP''s "executive" results and the results of the implementation of this ASP directly in the browser "Browse", Unlike VBScript, or JavaScript is the client (Client) browser running, the use of VBScript to design process, the client (Client) in the IE browser can display the results of program execution, but the client (Client) if using the Netscape browser can not display the results of the implementation of VBScript.
    
2.ASP features: the development of any development tools Jieke ASP. As long as the use of general clerical editing program, such as Windows Notepad, you can edit. Of course, other web development tools, such as, FrontPage Express, FrontPage, etc. can also be; but still suggest you use Notepad to write, both economical and convenient, if the use of those WYSIWYG Web page editor to write ASP, may occur some unexpected strange state.

3. Takes all Gejia here as ASP program is executed on a network server-side implementation of the results generated HTML files for different browsers.
    
4. Language Compatibility High: ASP with all compatible with ActiveX Script language, in addition to combine HTML, VBScript, Java Script, Active X server components to design things, and can be via "plug-In (plug-in component mode group) the way other manufacturers (Third Party) provided by the language.
Secret high security. If we are directly in the browser view the page source code, you can only see the HTML file, the original ASP program code is not visible! This is because the kit ASP program prior to Web services (Web Server) client implementation, it will translate the results into standard HTML documents, re-transmission sent to the client (Client) browser, so we have written in ASP program is not hard could easily be seen and then stolen.
    
5. Easy to manipulate the database: ASP can be easily through the ODBC (Open Database Connectivity) driver to connect a variety of databases, such as: Acess, Foxpro, dBase, Oracle, etc. In addition, ASP can also "Text File" or "Excel" file as a database to use.
    
6. Object-oriented learning easy: ASP possesses the object-oriented (Object-Oriented) function, learning easily, ASP provides the ability to facilitate a powerful built-in five kinds of objects: Request, Response, Sever, Application, and Session, at the same time, if the using the ASP built-in "Application" object or "Session" object ASP program can write out multiple pages in the temporary storage between the necessary information.
    
The six ASP intrinsic objects Request, Response, Server, Session, Application, ObjectContext obtain information from the client the information sent to the client to provide some tools for Web server, stored in a Session within the user information, the information may only be the user access to In an ASP-Application to allow different clients in the sharing of information can be used with Microsoft Transaction Server, distributed transaction processing.
    
So I chose the ASP web site with Frontpage structure. In the meantime I will use Macromedia Dreamweaver MX 2004 for ASP page code, and using IIS6.0 on the page for debugging.

Section ASP technology to access WEB Database

1. WEB a variety of programs to access the database

At present there are a variety of access under the WINDOWS environment, WEB database technology, are:

(1). Common Gateway Interface CGI (Common Gateway Interface)

CGI was an early realization of technology. Applicable to a variety of server platforms, such as UNIX, WINDOWS and so on, but the high cost of CGI development, maintenance problems, functionality is limited, do not have the transaction processing functions, take up more server resources.

(2). INTERNET Database Connector IDC (Internet Database Connector).

IDC integrated into the ISAPI (Internet Server API), the full use of DLL technology, easy to expand, but the programming is more complicated than the CGI is only applicable to small-scale database system.

 
(3). Advanced Database Connector ADC (Advance Database Connector)

ADC provides the ActiveX Control to access the database, and its main features is a data query from the client browser implementation, therefore, requires the server-side part of the records in the database to download to the client, the system overhead of a larger response to slow, only for the Special frequent database queries.

 
(4). JAVA / JDBC programming language

JAVA language is an object-oriented, easy to transplant, multi-threaded control language, to connect to the database through JDBC. Using JAVA / JDBC strong portability software written for a variety of operating systems, but its implementation efficiency and speed of execution is not ideal, is currently unable to establish a highly efficient, high-speed applications.

 
(5). Active Server Pages ASP (Active Server Page)

ASP is Microsoft''s latest WEB application development techniques, focused on dealing with dynamic pages and WEB database development, programming flexibility, simplicity, high performance, is currently the best choice for access to WEB database.

设为首页 | 加入收藏 | 网学首页 | 原创论文 | 计算机原创
版权所有 网学网 [Myeducs.cn] 您电脑的分辨率是 像素
Copyright 2008-2020 myeducs.Cn www.myeducs.Cn All Rights Reserved 湘ICP备09003080号 常年法律顾问:王律师