19
2020
03

让用户来选择根据那一列来进行排序


ASP源代码:


<html>

<body>


<table border="1" width="100%" bgcolor="#fff5ee">

<tr>

<th align="left" bgcolor="#b0c4de">

<a href="/example/adoe/demo_adoe_sort_3.asp?sort=companyname">Company</a>

</th>

<th align="left" bgcolor="#b0c4de">

<a href="/example/adoe/demo_adoe_sort_3.asp?sort=contactname">Contact</a>

</th>

</tr>

<%

if request.querystring("sort")<>"" then

   sort=request.querystring("sort")

else

   sort="companyname"

end if


set conn=Server.CreateObject("ADODB.Connection")

conn.Provider="Microsoft.Jet.OLEDB.4.0"

conn.Open(Server.Mappath("/db/northwind.mdb"))

set rs=Server.CreateObject("ADODB.recordset")

sql="SELECT Companyname,Contactname FROM Customers ORDER BY " & sort

rs.Open sql,conn


do until rs.EOF

   response.write("<tr>")

   for each x in rs.Fields

     response.write("<td>" & x.value & "</td>")

   next

   rs.MoveNext

   response.write("</tr>")

loop

rs.close

conn.close

%>

</table>


</body>

</html>


运行结果:


Screenshot_20200319_141445.jpg

« 上一篇 下一篇 »

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。