Web-based database query

This article through an example introduction uses Odbic to write in the Chinese WIN95 to access SQL Server database application, realizes the following odbic function flexible, convenient, easy to learn, recommends to everybody altogether exempts.

Since 97, web-based database applications in the database industry talk about a lot, web-based database application, is the database and Web technology, in accordance with the BROWS/SERVER structure established by the browser access to the database service system. At present, the Web database for the banner of products, prototypes or design programs and research papers, the development of Web applications database, building can interact with the database Web pages, there are three methods: one is the Gateway Interface (CGI), The second is JDBC (javadatabaseconnectivity), the third is the database manufacturers to develop their respective web intermediary.

The Web middleware developed by each database manufacturer is not universal; JDBC portability, security and reliability have significant advantages, but it is difficult to develop and can not meet the needs of the vast number of non-professional professionals; The CGI method is flexible in application, rich in development tools, and many common CGI programs. I traveled through the Internet to find a Web database CGI interface program odbic (101K byte size), small, flexible application, can and all kinds of data

Libraries (including FoxPro series, SQL Server, Oracle, etc.) to establish a connection.

The Odbic (opendatabaseinterneconnector) program is a shared software run on WindowsNT and WIN95, which is available through http:// Www.iodbc.com access to the software (currently has ODBIC1.5 version, this article is using the ODBIC1.4 version). The odbic provides an interface between the browser and the database, a CGI program that updates and browses the database from time to time through the browser.

With Odbic, you can use standard ANSISQL statements such as: Select,insert,update,ordelete to operate on all databases set up in ODBC. The biggest advantage of odbic is that it can be used as input by the Touch board file, the touch board file can also receive the user input parameters from the command, which contains standard HTML commands and text, and these commands and text odbic are directly exported to the browser, and of course the Touch board contains odbic commands and variables. When the odbic is run as input, the standard HTML commands and text are directly exported to the browser, executed immediately when the Odbic command is found, and the odbic variable is immediately replaced with the current value of the variable. The Odbic command is placed in the standard HTML language annotation line, the odbic variable is surrounded by a pair of symbols, and the following is a very simple example of how the Odbic commands and variables appear in the touch-board file: