ASP按汉字首字母排序(测试可用)

人气:
68
日期:
2019/9/11
HTML 网页设计 W3C 68

摘要:ASP按汉字首字母排序(测试可用)

<%

function getpychar(char)

aa=asc(char)

tmp=65536+aa'中文处理

tmpe=asc(char)'英文处理

if(tmp>=45217 and tmp<=45252) then

getpychar= "A"

elseif(tmpe=97) then

getpychar= "A"

elseif(tmp>=45253 and tmp<=45760) then

getpychar= "B"

elseif(tmpe=98) then

getpychar= "B"

elseif(tmp>=45761 and tmp<=46317) then

getpychar= "C"

elseif(tmpe=99) then

getpychar= "C"

elseif(tmp>=46318 and tmp<=46825) then

getpychar= "D"

elseif(tmpe=100) then

getpychar= "D"

elseif(tmp>=46826 and tmp<=47009) then

getpychar= "E"

elseif(tmpe=101) then

getpychar= "E"

elseif(tmp>=47010 and tmp<=47296) then

getpychar= "F"

elseif(tmpe=102) then

getpychar= "F"

elseif(tmp>=47297 and tmp<=47613) then

getpychar= "G"

elseif(tmpe=103) then

getpychar= "G"

elseif(tmp>=47614 and tmp<=48118) then

getpychar= "H"

elseif(tmpe=104) then

getpychar= "H"

elseif(tmp>=48119 and tmp<=49061) then

getpychar= "J"

elseif(tmpe=105) then

getpychar= "J"

elseif(tmp>=49062 and tmp<=49323) then

getpychar= "K"

elseif(tmpe=106) then

getpychar= "K"

elseif(tmp>=49324 and tmp<=49895) then

getpychar= "L"

elseif(tmpe=107) then

getpychar= "L"

elseif(tmp>=49896 and tmp<=50370) then

getpychar= "M"

elseif(tmpe=108) then

getpychar= "M"

elseif(tmp>=50371 and tmp<=50613) then

getpychar= "N"

elseif(tmpe=109) then

getpychar= "N"

elseif(tmp>=50614 and tmp<=50621) then

getpychar= "O"

elseif(tmpe=110) then

getpychar= "O"

elseif(tmp>=50622 and tmp<=50905) then

getpychar= "P"

elseif(tmpe=111) then

getpychar= "P"

elseif(tmp>=50906 and tmp<=51386) then

getpychar= "Q"

elseif(tmpe=112) then

getpychar= "Q"

elseif(tmp>=51387 and tmp<=51445) then

getpychar= "R"

elseif(tmpe=113) then

getpychar= "R"

elseif(tmp>=51446 and tmp<=52217) then

getpychar= "S"

elseif(tmpe=114) then

getpychar= "S"

elseif(tmp>=52218 and tmp<=52697) then

getpychar= "T"

elseif(tmpe=115) then

getpychar= "T"

elseif(tmp>=52698 and tmp<=52979) then

getpychar= "W"

elseif(tmpe=116) then

getpychar= "W"

elseif(tmp>=52980 and tmp<=53640) then

getpychar= "X"

elseif(tmpe=117) then

getpychar= "X"

elseif(tmp>=53689 and tmp<=54480) then

getpychar= "Y"

elseif(tmpe=118) then

getpychar= "Y"

elseif(tmp>=54481 and tmp<=62289) then

getpychar= "Z"

elseif(tmpe=119) then

getpychar= "Z"

else '如果不是中文,则不处理

getpychar=char

end if

end function


function getpy(str)

for i=1 to len(str)

getpy=getpy&getpychar(mid(str,i,1))

next

end function


'Function show(wchar)

Set rs = Server.CreateObject ("ADODB.Recordset")

sql = "Select * from az"

rs.Open sql,conn,1,1


if rs.EOF and rs.BOF then

  response.write ("暂时还没有记录")

else

  Do while not  rs.EOF

    'if getpychar(rs("name"))=wchar then

     response.write("歌手:"& rs("name"))

     response.write("&nbsp;歌名:"& rs("name"))

     response.write("<br>")

    'end if

     rs.MoveNext    

  Loop

end if

rs.close

Set rs = Nothing

end function

%>


<%

mchr=request.querystring("mchr")

if mchr="" then

%>

   D开头的<hr>

       <%=show("D")%><br>

   L开头的<hr>

       <%=show("L")%><br>

   Z开头的<hr>

       <%=show("Z")%>

<%else%>

   <%=mchr%>开头的<hr>

       <%=show(mchr)%>

<%end if%>


<%

for i = 65 to 90

response.write("<a href=index.asp?mchr="&chr(i)&">"&chr(i)&"</a>&nbsp;")

next

%>





Copyright © 2014 ASP技巧教程源码大全 All Rights Reserved
晋ICP备14006235号-3 页面执行时间:93.750毫秒 返回顶部

?分享按钮