Application of ASP and ADO in Web Database Check

---- * Specific implementation ---- Query the main page for Hong Kong and Macao ID information queries, the corresponding program is gacx.asp, the query results are displayed in two ways, one is to show the main information - Hong Kong and Macao ID information query results list, The corresponding program is gacxlb.asp, one is to display all information-Hong Kong and Macao ID information query results, the corresponding program is gacx xq.asp, if the query criterion is not satisfied, a hint page will be displayed, telling the user that there is no satisfaction result This is done by the program gacXTs.as P. ---- First, according to the database provided by the customer and the query, query results, query results list page, and give a simple prompt interface, tell the user that there is no result of the condition, please re-query, These work can be done with FrontPage 98, and the entire page should be simple and generous, and the theme is clear. The program code is written under Microsoft Visual Inter-DEV. ---- The lower surface is processed the contents of the code data library zd.dbf. From the figure below, there are many options, such as "Sex", "Birthplace", etc., these options are extracted from the zd.dbf database, which is exactly during the database processing. A flash point (this part is designed and implemented by Tao Zhenmin Engineer), because there are many options, such as 101 outbound ports, although you can also use ... format The various options are listed in the HTML page, but it will bring a lot of trouble to the maintenance of the program. Once the content of the coded database changes, the program will have to make a lot of modifications, and the pull box The options are encoded in zd.dbf. When entering data in the main database, these options are only entered, but the encoding cannot be displayed, but the Chinese characters corresponding to the encoding must be displayed.

This program code is as follows: <% set conn = server.creatobject ("adodb.connection") conn.open "gacx" set = conn.execute ("SELECT BC, MC from ZD WHERE BC LIKE "SE%" "") response.write "

" do while "" "& ='" rs (0) "'>" Rs.movenext loop response.write "" rs.colse conn.colse%> ---- where zd.dbf contains two fields MC, BC, MC to represent items to be encoded, such as men, women, BC Indicates the encoding, such as the first two digits of gender encoding, "SE", male uses "SE 1", and the female "SE2" is represented. ---- The most important thing in the data library check is how to check the query. The items to be queried in this example can be divided into two categories: a class is the input TEXT type query condition, and the other is the item selected from the drop-down box. When processing, the TEXT type query condition is very Good treatment, such as name, I am named "XM" to the input content, add a query condition "Name = Request.form (" XM ") if the input query item is not empty;" XM ")" To be much more complicated, when the box is selected, such as gender selection, "SE1" is entered in the drop-down box, (but "SEX = 1" is reflected in the database, because the database is entered in the Dictionary in the database Enter only the encoding when you want to query the "SEX = SE1" item. When processing "SE1", "SE1" is extracted, only one function MID is required, the query condition is "SEX = MID ("SE1", 3, 1) ", that is, lookup of SEX = 1 from the database, and list all items that satisfy the conditions are not repeated.