【作者】 希凡；

【导师】 薛胜军；

【作者基本信息】 武汉理工大学 ， 计算机应用技术， 2006， 硕士

【摘要】 随着Internet的飞速发展,万维网(WWW,World Wide Web)得到了很大的发展。WWW系统和数据库是网络化信息服务的基础,Web技术和数据库技术相结合成为当前研究的热点,其中关键就是Web数据库访问技术。传统的数据库访问技术己渐渐不能满足高速存取、断开连接存取和内置的全面的XML支持等的需要,研究Internet的数据库访问技术也就成为数据库研究的主要方向之一。 目前基本的数据库访问技术主要有开放数据库连接(ODBC,OpenDatabase Connectivity)、基于ODBC的数据访问对象(DAO,Data AccessObject)和远程数据对象(RDO,Remote Data Object)、Java数据库连接(JDBC,Java Database Connectivity)、对象链接和嵌入式数据库(OLE DB,Objcot Linking and Embedding Database)/ActiveX数据对象(ActiveXData Object,ADO),他们都是在不同时期出现并被广泛使用的技术,很多技术现在仍很流行。而常用的Web数据库访问实现技术主要包括通用网关接口(CGI,Common Gateway Interface)、服务器应用程序接口(SAPI,ServerApplication Programming Interface)、动态服务器端语言(ASP,Active ServerPage)、超文本预处理器(PHP,Professional HyperText PreProcessor)、Java服务器端语言(JSP,Java Server Pages),这些技术各有自己的优缺点和适宜场合,仍被广泛采用来编写Web应用程序。随着微软.NET的推出,ASP.NET为编写大量的Web应用程序带来了巨大的变革。本文着重就.NET框架的最新数据库访问技术——ADO.NET的体系结构、对象模型、各个对象的重点特性等进行了深入而详细的分析和研究,就ADO.NET在Web应用中主要性能优化包括四种.NET数据提供程序性能优化、比较和选择,存储过程的优化,安全性,数据一致性等作了深入的探究。提出了在.NET环境下如何开发高效的面向Internet的数据库访问技术,这些探讨对于目前大量的Web数据库应用程序的开发具有较大的实用和指导意义。 基于上述Web数据库访问技术研究,根据黄石市公路管理处的实际需求,设计并实现了B/S模式的管理信息系统。该系统基于.NET平台,采用ADO.NET数据访问技术和相关性能优化技术,利用VB语言设计实现。该系统由表示层、业务层和数据层组成。表示层处在客户端,由一个通用的浏更多还原

【Abstract】 With the developing rapidly of Internet, WWW (World Wide Web) has got the very big development. WWW is the most popular and leading information service method. WWW system and database are the foundations of network information service, the technique of Web has become the current focus of research with the database technique, the key is a Web database access technique. The traditional database access technique can’t satisfy little by little the demand of high speed access, the data access on broken connection and Complete support of XML, etc. The study of database access technique based on Internet has become one of main direction of database research.Current basic database access technique primarily contain Open Database Connectivity (ODBC), Data Access Object (DAO) and Remote Data Object (RDO) based on ODBC, Java Database Connectivity (JDBC), Object Linking and Embedding Database (OLE DB)/ ActiveX Data Object (ADO), they appear separately on different period and used broadly, a lot of techniques are still very popular now. General Web database access implementation technique includes the Common Gateway Interface (CGI), Server Application Programming Interface (SAPI), Active Server Page (ASP), Professional HyperText Preprocessor (PHP), Java Server Pages (JSP) primarily, these techniques each have their advantages, shortcomings and the proper situations, still are extensive adopted to write the Web application program. Along with the Microsoft .NET releasing, the ASP.NET brings enormous varieties for writing a flood of Web application program. This paper investigates thoroughly the performance optimize of ADO.NET on Web application, which includes comparison, choice and performance optimize of four kinds of .NET data providers, applicable occasion and optimize of stored procedure, security, data consistency etc. In addition, it puts forward that how to develop efficiently database access application of facing to the Internet on .NET environment. These studies provide bigger practical values and guiding meaning for a great deal of the currentdevelopment of database application on Web.Based on the above studies of Web database access technique, according to actual need of Huangshi Road Administrative Office, a Information system of B/S mode has been designed and realized. That system on .NET platform is the implementation with VB language by adoption ADO.NET data access technique and related performance optimize technique. This system consists of browser, Web server and database server. The browser is placed in client anywhere supported by general browser. Business data logic as center agent is usually named Web server. The backstage is a SQL Server database server. The Web server of the system uses AD0.NET technique (such as SQL Server.NET data providers, stored procedures, security, data consistency) connecting and accessing database. Such things enhance consumedly data access efficiency and performance of application program.更多还原