WEB-based database query

---- In 97 years, the WEB-based data library should be widely used in the data library field.
Mostly, based on the application of the WEB data library, is to combine the data library and WEB technology
And access the data base through the browser built by BROWS/SERVER
Service system.
Product, original form, or design with WEB data library as the flag
There are many design cases and research papers, and the WEB application of data warehouse should be developed.
WEB pages that can interwork with data databases have three methods: The first is
The second is JDBC (java database connectivity), and the third is
Each data warehouse has its own WEB room.
---- Although the WEB components of each data warehouse developed by each data warehouse are not accessible
Usage; JDBC portability, security, and reliability have obvious advantages,
The development difficulty is high, and it cannot meet the needs of many non-professional staff; CGI side
Style should use the spirit of live, the development of rich work, through the CGI process is also a lot.
Ben
People can search for a WEB data database CGI interface sequential ODBIC (101 K
The word festival is big or small.
Database (including FOXPRO columns, SQL SERVER, ORACLE, and so on) is established and connected.
---- ODBIC (open database interne connector) is run on windows nt and WIN95
Shared software on, can be obtained through the http://www.iodbc.com
ODBIC1.5 is available. This document uses ODBIC1.4 ). ODBIC is in the browser
A connection port is provided between the database and the data base, that is, a CGI program.
When the browser is used, the data warehouse will be updated and accessed.
---- The following ansi SQL statements that can be used by ODBIC: SELECT, INSERT,
UPDATE, or DELETE performs operations on all data databases set in ODBC. ODBIC
The biggest advantage is that you can use the TouchPad file as the input, the TouchPad file is also
Capable of receiving
User input parameters sent by submit in the command order, and the TouchPad package contains the standard
HTML command and text, and these command and text ODBIC directly output
On the browser, the TouchPad also contains the ODBIC command and change volume.
When ODBIC
When using the touchpad as the input and operation, the standard HTML command and text are directly connected.