Add a smart Search to an ASP application

Using ASP to achieve the function of the search engine is a very convenient thing, but, how to achieve a similar 3721 intelligent search? For example, when you enter the "Chinese people" in the search conditions box, automatically extracts "China", "people" and other keywords and search in the database. After reading this article, you will find that this function is so simple to achieve.

The first step is to create a database called Db_sample.mdb (this article takes the Access2000 database as an example) and creates a table t_sample in it. The table T_sample includes the following fields:

ID Auto Number

U_name text

U_info notes

The second step, we start to design the search page search.asp. The page includes a form (Frm_search) that includes a text box and a Submit button in the form. The form's Method property is set to "get" and the Action property is set to "Search.asp", which is submitted to the Web page itself. The code is as follows:

＜!-- Search.asp --＞
＜form name="frm_Search" method="get" action="Search.asp"＞
请输入关键字：
＜input type="text" name="key" size="10"＞
＜input type="submit" value="搜索"＞
＜/form＞

Below, you are entering a key part of implementing intelligent search.

First, establish a database connection. Add the following code at the beginning of the Search.asp:

＜%
　Dim strProvider,CNN
　strProvider="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
　strProvider=strProvider & Server.MapPath("\") & "\data\db_Sample.mdb" 假设数据库存放在主页根目录下的data目录下
　Set CNN = Server.CreateObject("ADODB.connection")
　CNN.Open strProvider 打开数据库连接
%＞