Unix平台下的数据库查询开发工具（Web-DTools）的设计与实现

【作者】 王玉华；

【导师】 姚文琳；

【作者基本信息】 中国海洋大学 ， 计算机技术， 2011， 硕士

【摘要】 在企业级用户服务器操作系统中,如金融、电信、政府等部门,基于安全性、稳定性的Unix系统几乎一统天下。简洁、高效、安全是Unix的文化哲学,但同样,以命令行、字符界面为特征的操作方式,也提高了操作者的门槛。Web方式是基于超文本协议、CGI接口、图形化和易于导航的流行查询方式,客户容易接受。对服务器而言,数据查询是频繁而又重要的职能。所谓Web-DTools是指一个用于查询的界面函数库,只要写简单的几句话马上就可以生成对表数据的Web交互查询动态页面。本文研究的目的就是设计一种工具软件,通过Web动态方式实现对架设在Unix平台上的数据库查询。本文研究的思路是通过表结构描述脚本,直接生成CGI (公共网关界面)的C语言源码,然后编译生成CGI,实现数据库的动态访问。本文着重从脚本翻译、Web界面、数据库接口等三个方面进行了分析与设计,并通过实例来说明具体实现方法。更多还原

【Abstract】 The UNIX system that based on security and stability almost dominate the world in the enterprise server operating systems, such as finance, telecommunications, government and other departments. The culture of UNIX philosophy is Simple, efficient and safe, but also, the mode of operation which characterized by the command line and character interface increased the threshold for the operator. The client is easy to accept Web which based on hypertext protocol, CGI interface, graphical and easy way to navigate popular queries. For the server, the data query is frequent and important functions. The so-called Web-DTools is one interface function library for the query, with writing a few sentences, so immediately generate Web interactive query dynamic pages of table data.The purpose of this study is to design a software tool to achieve database queries through the Web dynamically which set up in the UNIX platform. The idea of this paper is that through the table schema describe script, then directly generate CGI (Common Gateway Interface) of the C language source code, and then compiled CGI, to achieve dynamic access of database. This article focuses on the three aspects which include script translation, Web interface, and database interface to analysis and design, and uses example to illustrate the specific implementation.更多还原