Summary of some related techniques and materials of XMLHTTP

XmlHTTP tips: -------------------------------------------------------- 1. an important part of the modern Internet-based WAN application is remote database monitoring. First, let's look at the data on the Internet.

XmlHTTP tips:
----------------------------------------------------------
I. database remote management skills

Remote Database monitoring is an important part of the modern Internet-based wide area network (WAN) utilization. First, let's briefly review the development process and methods of the remote database management skills on the Internet:

Early through the preparation of CGI-BIN program module for remote database governance. But the CGI-BIN running speed is slow, the protection is inconvenient, and now the basic has been abandoned.

Over the past few years, the Component Object Model (COM) has been widely used and has good consequences. However, if the app is a third-party server (the author's website is built on a third-party virtual host), the server often fails to answer questions due to confidentiality or other trade reasons.

In recent years, Microsoft launched the. NET platform and SUN's J2EE platform are both very advanced database remote management and service platforms. It can provide high-quality multi-Tier (n-Tier) exploitation services.
Where ,. NET Simple Object Access Protocol (SOAP) application Hypertext Transfer Protocol (Hypertext Transfer Protocol, HTTP) and extended Markup Language (Extensible Markup Language, XML) cross-system (such as Windows-Linux) communication service methods have been widely accepted and applied by developers. Many large-scale exploitation such as Enterprise resource planning (ERP) are built on such a large platform.
However, for small-and medium-size exploitation, such as the construction and protection of a website, such a large-scale exploitation platform seems to be too large at the end, and the overhead is too large.

Microsoft, once out of date in terms of internet and Java skills, is ahead in XML exploitation and development. The XMLHTTP protocol in her XML parser (MSXML) is a very convenient and practical client/service communication pipeline. The application of XMLHTTP and ActiveX Data Objects (ActiveX Data Objects, ADO/ADOX) can easily achieve remote database management.

This article describes how to comprehensively apply XMLHTTP and ADO/ADOX for remote database governance.

2. remote database management system

The task process of remote database governance is as follows:
1. the client sends a query or correction command for the database structure and data to the server.
2. the server receives and executes relevant commands and returns results to the client.
3. the client receives and displays the command fulfillment results returned by the server.

Two important links for achieving remote database governance are:
1. the command Upload between the client and the server and the data channel for result transfer are implemented by XMLHTTP.
2. command transmission between the server and the database and result return are completed by the ADO/ADOX interface serving as the intermediate layer.
3. XMLHTTP application

As the name suggests, XMLHTTP is a hypertext transfer protocol for transmitting XML format data.

In fact, the data transmission process of XMLHTTP is more mobile:
It uploads commands that can be XML format data, strings, streams, or an unsigned integer array. It can also be a URL parameter.
The results can be XML format data, strings, streams, or an unsigned integer array.
For more information, see the link at the end of the article.

The process for the client to call XMLHTTP is very simple, with only five steps:
1. create an XMLHTTP object
2. open a connection to the service, and define the command sending method, service webpage (URL), and request permissions.
The client opens a connection to the service webpage through the Open command. Like normal HTTP command transmission, you can use the "GET" method or "POST" method to point to a service webpage.
3. send commands.
4. wait for and receive the processing results returned by the server.
5. release XMLHTTP objects

XMLHTTP method:
Open bstrMethod, bstrUrl, varAsync, bstrUser, bstrPassword
BstrMethod: data transmission method, that is, GET or POST.
BstrUrl: The URL of the service webpage.
VarAsync: whether to perform synchronization. The default value is True, that is, synchronous performance, but can only be performed in the DOM.
In use, it is usually set to False, that is, asynchronous performance.
BstrUser: user name, which can be omitted.
BstrPassword: user password, which can be omitted.

2 pages in total: previous 1 [2] Next