<% sql="select * from s2" kk=0 sjname=Request("sjname") if sjname="" and Request("yz123")="" then sjname=22 sc=Request("sc") zk=Request("zk") jg=Request("jg") ds=Request("ds") rq1=Request("rq1") rq2=Request("rq2") bf11=Request("bf11") bf12=Request("bf12") bf21=Request("bf21") bf22=Request("bf22") bf31=Request("bf31") bf32=Request("bf32") sj1=Request("sj1") sj2=Request("sj2") df1=Request("df1") df2=Request("df2") zg1=Request("zg1") zg2=Request("zg2") rb11=Request("rb11") rb12=Request("rb12") rb21=Request("rb21") rb22=Request("rb22") rb31=Request("rb31") rb32=Request("rb32") gm1=Request("gm1") gm2=Request("gm2") qd1=Request("qd1") qd2=Request("qd2") sw1=Request("sw1") sw2=Request("sw2") fg1=Request("fg1") fg2=Request("fg2") tl11=Request("tl11") tl12=Request("tl12") tl21=Request("tl21") tl22=Request("tl22") tl31=Request("tl31") tl32=Request("tl32") f11=Request("f11") f12=Request("f12") f21=Request("f21") f22=Request("f22") f31=Request("f31") f32=Request("f32") fq11=Request("fq11") fq12=Request("fq12") fq21=Request("fq21") fq22=Request("fq22") fq31=Request("fq31") fq32=Request("fq32") if not sjname="" then if kk=0 then sql=sql&" where" kk=1 end if box=sjname box=Replace(box," ","") box=Split(box,",") for aa=0 to UBound(box) sql=sql&" s="&box(aa) if not aa=UBound(box) then sql=sql&" or" next end if if sc=1 then sql="select * from ("&sql&") a where sc=true" end if if sc=2 then sql="select * from ("&sql&") a where sc=false" end if if zk=1 then sql="select * from ("&sql&") a where zk=true" end if if zk=2 then sql="select * from ("&sql&") a where zk=false" end if if jg=1 then sql="select * from ("&sql&") a where jg=true" end if if jg=2 then sql="select * from ("&sql&") a where jg=false" end if if not ds="" then box=ds box=Replace(box," ","") box=Split(box,",") sql="select * from ("&sql&") a where" for aa=0 to UBound(box) sql=sql&" ds="&box(aa) if not aa=UBound(box) then sql=sql&" or" next end if if not rq1="" and not rq2="" then sql="select * from ("&sql&") a where rq>=#"&rq1&"# and rq<=#"&rq2&"#" else if not rq1="" then sql="select * from ("&sql&") a where rq>=#"&rq1&"#" if not rq2="" then sql="select * from ("&sql&") a where rq<=#"&rq2&"#" end if if not bf11="" then sql="select * from ("&sql&") a where bf1>="&bf11 if not bf12="" then sql="select * from ("&sql&") a where bf1<="&bf12 if not bf21="" then sql="select * from ("&sql&") a where bf2>="&bf21 if not bf22="" then sql="select * from ("&sql&") a where bf2<="&bf22 if not bf31="" then sql="select * from ("&sql&") a where Abs(bf1-bf2)>="&bf31 if not bf32="" then sql="select * from ("&sql&") a where Abs(bf1-bf2)<="&bf32 if not sj1="" then sql="select * from ("&sql&") a where sj>="&sj1 if not sj2="" then sql="select * from ("&sql&") a where sj<="&sj2 if not df1="" then sql="select * from ("&sql&") a where df>="&df1 if not df2="" then sql="select * from ("&sql&") a where df<="&df2 if not zg1="" then sql="select * from ("&sql&") a where zg>="&zg1 if not zg2="" then sql="select * from ("&sql&") a where zg<="&zg2 if not gm1="" then sql="select * from ("&sql&") a where gm>="&gm1 if not gm2="" then sql="select * from ("&sql&") a where gm<="&gm2 if not qd1="" then sql="select * from ("&sql&") a where qd>="&qd1 if not qd2="" then sql="select * from ("&sql&") a where qd<="&qd2 if not sw1="" then sql="select * from ("&sql&") a where sw>="&sw1 if not sw2="" then sql="select * from ("&sql&") a where sw<="&sw2 if not fg1="" then sql="select * from ("&sql&") a where fg>="&fg1 if not fg2="" then sql="select * from ("&sql&") a where fg<="&fg2 if not rb11="" then sql="select * from ("&sql&") a where rb1>="&rb11 if not rb12="" then sql="select * from ("&sql&") a where rb1<="&rb12 if not rb21="" then sql="select * from ("&sql&") a where rb2>="&rb21 if not rb22="" then sql="select * from ("&sql&") a where rb2<="&rb22 if not rb31="" then sql="select * from ("&sql&") a where (rb1+rb2)>="&rb31 if not rb32="" then sql="select * from ("&sql&") a where (rb1+rb2)<="&rb32 if not tl11="" then sql="select * from ("&sql&") a where tl1>="&tl11 if not tl12="" then sql="select * from ("&sql&") a where tl1<="&tl12 if not tl21="" then sql="select * from ("&sql&") a where tl2>="&tl21 if not tl22="" then sql="select * from ("&sql&") a where tl2<="&tl22 if not tl31="" then sql="select * from ("&sql&") a where tl2>0 and (tl1/tl2)>="&tl31/100 if not tl32="" then sql="select * from ("&sql&") a where tl2>0 and (tl1/tl2)<="&tl32/100 if not f11="" then sql="select * from ("&sql&") a where f1>="&f11 if not f12="" then sql="select * from ("&sql&") a where f1<="&f12 if not f21="" then sql="select * from ("&sql&") a where f2>="&f21 if not f22="" then sql="select * from ("&sql&") a where f2<="&f22 if not f31="" then sql="select * from ("&sql&") a where f2>0 and (f1/f2)>="&f31/100 if not f32="" then sql="select * from ("&sql&") a where f2>0 and (f1/f2)<="&f32/100 if not fq11="" then sql="select * from ("&sql&") a where fq1>="&fq11 if not fq12="" then sql="select * from ("&sql&") a where fq1<="&fq12 if not fq21="" then sql="select * from ("&sql&") a where fq2>="&fq21 if not fq22="" then sql="select * from ("&sql&") a where fq2<="&fq22 if not fq31="" then sql="select * from ("&sql&") a where fq2>0 and (fq1/fq2)>="&fq31/100 if not fq32="" then sql="select * from ("&sql&") a where fq2>0 and (fq1/fq2)<="&fq32/100 %> <% set rs1=Server.CreateObject("ADODB.Recordset") rs1.Open sql&" order by rq desc",conn,1,1 fsc=0 fzk=0 fjg=0 fsj=0 ftl1=0 ftl2=0 ff1=0 ff2=0 ffq1=0 ffq2=0 fqd=0 fgm=0 ffg=0 fzg=0 frb1=0 frb2=0 fdf=0 %> 姚明中文网-姚明数据查询器-NBA火箭队比赛在线直播|BBS论坛|新闻|资料|数据|图片|视频|赛程
09-10季前赛 - 09-10常规赛
08-09季后赛 - 08-09常规赛 - 08-09季前赛 | 07-08季后赛 - 07-08常规赛 - 07-08季前赛 | 06-07季前赛 - 06-07常规赛 - 06-07季后赛
05-06季前赛 - 05-06常规赛 | 04-05季前赛 - 04-05常规赛 - 04-05季后赛 | 03-04季前赛 - 03-04常规赛 - 03-04季后赛 | 02-03常规赛

<% if rs1.Eof then %> <% else fs=0 do while not rs1.eof %> > <% rs1.movenext loop end if %>
上场 比赛日期 主客 对手&比分 结果 时间 投篮 三分 罚球 抢断 盖帽 失误 犯规 助攻 篮板(前/后/总) 得分
暂无记录
<% if rs1("sc")=true then Response.Write("是") fsc=fsc+1 else Response.Write("否") end if %> <%=rs1("rq")%> <% if rs1("zk")=true then Response.Write("主") fzk=fzk+1 else Response.Write("客") end if %> <% set rs2=Server.CreateObject("ADODB.Recordset") rs2.Open "select * from qd where id="&rs1("ds"),conn,1,1 if rs1("zk")=true then Response.Write(rs2("name")&" "&rs1("bf2")&"-"&rs1("bf1")&" 火箭") else Response.Write("火箭 "&rs1("bf1")&"-"&rs1("bf2")&" "&rs2("name")) end if rs2.Close set rs2=nothing %> <% if rs1("jg")=true then Response.Write("胜") fjg=fjg+1 else Response.Write("负") end if %> <%=rs1("sj")%><%fsj=fsj+rs1("sj")%> <%=rs1("tl1")%>/<%=rs1("tl2")%><%ftl1=ftl1+rs1("tl1")%><%ftl2=ftl2+rs1("tl2")%> <%=rs1("f1")%>/<%=rs1("f2")%><%ff1=ff1+rs1("f1")%><%ff2=ff2+rs1("f2")%> <%=rs1("fq1")%>/<%=rs1("fq2")%><%ffq1=ffq1+rs1("fq1")%><%ffq2=ffq2+rs1("fq2")%> <%=rs1("qd")%><%fqd=fqd+rs1("qd")%> <%=rs1("gm")%><%fgm=fgm+rs1("gm")%> <%=rs1("sw")%><%fsw=fsw+rs1("sw")%> <%=rs1("fg")%><%ffg=ffg+rs1("fg")%> <%=rs1("zg")%><%fzg=fzg+rs1("zg")%> <%=rs1("rb1")%><%frb1=frb1+rs1("rb1")%> <%=rs1("rb2")%><%frb2=frb2+rs1("rb2")%> <%=rs1("rb1")+rs1("rb2")%> <%=rs1("df")%><%fdf=fdf+rs1("df")%>

共<%=rs1.RecordCount%>场比赛，其中<%=fzk%>个主场<%=rs1.RecordCount-fzk%>个客场，姚明出场<%=fsc%>场，伤停<%=rs1.RecordCount-fsc%>场，结果<%=fjg%>胜<%=rs1.RecordCount-fjg%>负。
总计：上场<%=fsj%>分钟，得<%=fdf%>分，<%=frb1+frb2%>个篮板(前<%=frb1%>后<%=frb2%>)，<%=fzg%>个助攻，<%=fgm%>个盖帽，<%=fqd%>个抢断，<%=fsw%>个失误，<%=ffg%>个犯规，投篮<%=ftl1%>/<%=ftl2%>，三分<%=ff1%>/<%=ff2%>，罚球<%=ffq1%>/<%=ffq2%>。
<%if fsc=0 then Response.Write("无上场场次") else %> 场均：上场<%=Round(fsj/fsc,1)%>分钟，得<%if Round(fdf/fsc,1)<1 and Round(fdf/fsc,1)>0 then Response.Write("0")%><%=Round(fdf/fsc,1)%>分，<%if Round((frb1+frb2)/fsc,1)<1 and Round((frb1+frb2)/fsc,1)>0 then Response.Write("0")%><%=Round((frb1+frb2)/fsc,1)%>个篮板(前<%if Round(frb1/fsc,1)<1 and Round(frb1/fsc,1)>0 then Response.Write("0")%><%=Round(frb1/fsc,1)%>后<%if Round(frb2/fsc,1)<1 and Round(frb2/fsc,1)>0 then Response.Write("0")%><%=Round(frb2/fsc,1)%>)，<%if Round(fzg/fsc,1)<1 and Round(fzg/fsc,1)>0 then Response.Write("0")%><%=Round(fzg/fsc,1)%>个助攻，<%if Round(fgm/fsc,1)<1 and Round(fgm/fsc,1)>0 then Response.Write("0")%><%=Round(fgm/fsc,1)%>个盖帽，<%if Round(fqd/fsc,1)<1 and Round(fqd/fsc,1)>0 then Response.Write("0")%><%=Round(fqd/fsc,1)%>个抢断，<%if Round(fsw/fsc,1)<1 and Round(fsw/fsc,1)>0 then Response.Write("0")%><%=Round(fsw/fsc,1)%>个失误，<%if Round(ffg/fsc,1)<1 and Round(ffg/fsc,1)>0 then Response.Write("0")%><%=Round(ffg/fsc,1)%>个犯规，投篮<%if ftl2=0 then Response.Write("0%") else%> <%=Round(ftl1/ftl2*100,1)&"%"%> <%end if%>，三分<%if ff2=0 then Response.Write("0%") else%> <%=Round(ff1/ff2*100,1)&"%"%> <%end if%>，罚球<%if ffq2=0 then Response.Write("0%") else%> <%=Round(ffq1/ffq2*100,1)&"%"%> <%end if%>。 <%end if%>
欢迎使用本站独创的姚明数据查询器!!
使用此查询器可以让您非常方便的查询到各种复杂条件下的姚明数据, 系统将列出符合您选择条件的
  所有比赛场次,并自动运算出总数据和场均数据,供您浏览。  
使用方法:在下列各种选项中勾选或填上您想要的条件,点击"提交查询"即可,不选择的请留空。

赛事选择(留空则为全选)
09-10赛季NBA季前赛 09-10赛季NBA常规赛  
08-09赛季NBA季前赛 08-09赛季NBA常规赛 08-09赛季NBA季后赛
07-08赛季NBA季前赛 07-08赛季NBA常规赛 07-08赛季NBA季后赛
06-07赛季NBA季前赛 06-07赛季NBA常规赛 06-07赛季NBA季后赛
05-06赛季NBA季前赛 05-06赛季NBA常规赛  
04-05赛季NBA季前赛 04-05赛季NBA常规赛 04-05赛季NBA季后赛
03-04赛季NBA季前赛 03-04赛季NBA常规赛 03-04赛季NBA季后赛
  02-03赛季NBA常规赛  
出场选择 主客场选择 胜负场选择
不选择     出场     伤停 不选择     主场     客场 不选择     胜场     负场
对阵对手选择(留空则为全选)
<% set rs3=Server.CreateObject("ADODB.Recordset") rs3.Open "select * from qd",conn,1,1 %> <%do while not rs3.eof%> <% for i=1 to 8%> <% rs3.movenext if rs3.eof then Exit For next%> <% loop %>
"> <%=rs3("name")%>
日期选择(以下选项不设置请留空)
从 至 之间的场次    日期格式例:2007-9-12
比分选择
火箭得分: 至      对手得分: 至       两队比分差: 至 分  (可配合"胜负场选择"查询胜分差和负分差)
上场时间 得分 助攻 前场篮板 后场篮板 总篮板
至 至 至 至 至 至
盖帽 抢断 失误 犯规  
至 至 至 至  
投篮(投中/出手) 三分(投中/出手) 罚球(投中/出手)
至 / 至 至 / 至 至 / 至
命中率: % 至 % 命中率: % 至 % 命中率: % 至 %