用ASP和WML来实现数据库查询 -pc6资讯

您的位置：首页 → 技术开发 → ASP技巧 → 用ASP和WML来实现数据库查询

用ASP和WML来实现数据库查询 时间：2004/11/7 4:10:00来源：本站整理作者：蓝点我要评论(0): 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"%>

1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">

<%

    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

%>





          Please enter username to find?















<%

    else

　　　　strSQL = "SELECT * FROM tblUsers WHERE Username ='& strWhoIs & '"

　　　　Set rs = conn.Execute(strSQL)



%>




<%

          if not rs.EOF then

           rs.MoveFirst

              Response.Write "User Search Results"

              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

%>





<%

    end if

%>

文章评论

查看所有0条评论>>

热门文章 没有查询到任何记录。