<%
Set MRs=server.CreateObject("adodb.recordset")
MRs.open"select ID,yintao,juzi,shucai,apli from [表名] order by ID asc",conn,3,1
if Not MRs.Eof then
Response.Write "
ID | Yintao | Juzi | Shucai | apli | Count |
"&StrID&" | "&StrYintao&" | "&StrJuzi&" | "&StrShucai&" | "&StrApli&" | "&StrCount&" |