-- 作者：yglyjf
-- 发布时间：6/14/2004 3:38:00 PM
-- ASP+XML+FLASH的问题 [原创]
用ASP读取SQL SERVER数据库中的数据生成XML代码，然后作为FLASH的数据源，动态生成统计图。有什么好的解决办法？请指教。 1、用ASP读取SQL SERVER数据库中的数据生成XML代码 <%
xmlContent = xmlContent & "<graph caption='' xAxisName='DATE' yAxisName='API' canvasbgcolor='FFC700' gridbgcolor='FFECAA' hovercapbg='FFECAA' hovercapborder='F47E00' divlinecolor='F47E00' numdivlines='5' yaxisminvalue='50' yaxismaxvalue='300' >"&CHR(10)&CHR(13) xmlContent = xmlContent & "<categories>"&CHR(10)
for j=1 to MaxVal
xmlContent = xmlContent &CHR(9)& "<category name='"+mydate(j)+"' />"&CHR(10)
next
xmlContent = xmlContent & "</categories>"&CHR(10)&CHR(13) xmlContent = xmlContent & "<dataset seriesname='S02' color='00A900' showValue='0' lineThickness='1'>"&CHR(10)
for j=1 to MaxVal
xmlContent = xmlContent &CHR(9)& "<set value='"+myValue(1,j)+"' link=''/> "&CHR(10)
next
xmlContent = xmlContent & "</dataset>"&CHR(10)&CHR(13) xmlContent = xmlContent & "<dataset seriesname='N02' color='0099FF' showValue='0' lineThickness='2'>"&CHR(10)
for j=1 to MaxVal
xmlContent = xmlContent &CHR(9)& "<set value='"+myValue(2,j)+"' link=''/> "&CHR(10)
next
xmlContent = xmlContent & "</dataset>"&CHR(10)&CHR(13) xmlContent = xmlContent & "<dataset seriesname='TSP' color='0372Ab' showValue='0' >"&CHR(10)
for j=1 to MaxVal
xmlContent = xmlContent &CHR(9)& "<set value='"+myValue(3,j)+"' link=''/> "&CHR(10)
next
xmlContent = xmlContent & "</dataset>"&CHR(10)&CHR(13) xmlContent = xmlContent & "<trendlines>"&CHR(10)
xmlContent = xmlContent &CHR(9)& "<line value='50' color='#6666FF' displayValue='Ⅰ ' thickness='50' alpha='20'/>"&CHR(10)
xmlContent = xmlContent &CHR(9)& "<line value='100' color='#009999' displayValue='Ⅱ ' thickness='50' alpha='10'/>"&CHR(10)
xmlContent = xmlContent &CHR(9)& "<line value='200' color='#FFFF00' displayValue='Ⅲ ' thickness='100' alpha='10'/>"&CHR(10)
xmlContent = xmlContent &CHR(9)& "<line value='300' color='#FF0066' displayValue='Ⅳ ' thickness='100' alpha='10'/>"&CHR(10)
xmlContent = xmlContent &CHR(9)& "<line value='350' color='#CC0000' displayValue='Ⅴ ' thickness='50' alpha='10'/>"&CHR(10)
xmlContent = xmlContent & "</trendlines>"&CHR(10)&CHR(13) xmlContent = xmlContent & "</graph>"&CHR(10) xmlContent = xmlContent & "</xsl:stylesheet>"&CHR(10) 'Response.Write(xmlContent)
session("xmlContent")=cstr(xmlContent)
%> 2、FLASH对象的dataURL该怎么写？ 上面的代码将生成XML的文件，如果将其存为test2.xml，下面的方法可以出现统计图。有更好的方法吗？ <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="./swflash.cab#version=6,0,0,0" width="665" height="420" id="FC2Column" align="middle">
<param name=movie value="FC2MSColumn.swf?IsLocal=1&dataURL=test2.xml<%'=xmlContent%>"><!-- MSColumn1.xml Air_DataXML.asp-->
<param name=quality value=high>
<param name=bgcolor value=#FFFFFF>
<embed src="FC2MSColumn.swf?IsLocal=1&dataURL=test2.xml<%'=xmlContent%>" quality=high bgcolor=#FFCC00 width="665" height="420" name="FC2Column" align="middle" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer">
</embed>
</object>
|