原创投稿 |　常用软件
您的位置：网站首页 > 源码分享 > ASP程序 > 正文

用ASP和WML来实现数据库查询ASP技巧

文章作者：三亚上门维修电脑 发布日期：2012/2/11 9:04:06
Shows how to perform a search with a WAP page and use asp on the server to do the database query and then
display the results.


<%Response.ContentType = "text/vnd.wap.wml"%>
<?xml version="1.0"?><!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML
1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<%  
    Dim conn, rs  
    Dim strSQL,strFirstName, strLastName  
    Set conn = Server.CreateObject("ADODB.Connection")
    Set rs   = Server.CreateObject("ADODB.Recordset")

    conn.open session("myconnect_string") 'Replace with your connect string  

    strWhoIs = Request.QueryString("username")
    if strWhoIs="" then
%>
    <card id="UserSearch" title="Search">  
       <p>
          Please enter username to find? <input name="username" type="text" maxlength="15"/>
             <do type="accept" label="Locate">
                <go href="thispage.asp" method="get">
                   <postfield name="username" value="$username"/>
                </go>
             </do>     
       </p>
    </card>
<%
    else
strSQL = "SELECT * FROM tblUsers WHERE Username ='& strWhoIs & '"
Set rs = conn.Execute(strSQL)
      
%>  <card id="UserResult" title="Result">
         <p>            
<%
          if not rs.EOF then
           rs.MoveFirst
              Response.Write "<strong>User Search Results</strong>"
              While not rs.EOF
                 strFirstName = "First Name " & rs("FirstName")
                 strLastName = "Last Name " & rs("LastName")
                 Response.Write strFirstName
                 Response.Write strLastName
                 rs.MoveNext          
              Wend
          else
              Response.Write "Sorry, no user found."
          end if
%>
         </p>
       </card>
<%
    end if
%>
</wml>

注意：联系我时，请一定说明是从【S】看到的信息，谢谢。

编辑：
联系电话：
联系 QQ：
打电话给我、或者加QQ好友时，请一定说明来自（三亚上门维修电脑）谢谢您！
三亚上门维修电脑

上一篇：在JSP、ASP和PHP网站网页中使用XHTMLASP技巧
下一篇：域名登记查询whois很复杂吗方法一ASP技巧