首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > ASP >

动态从数据库中读取数据解决思路

2012-03-07 
动态从数据库中读取数据scriptlanguage JavaScript1.2 !--/*设置下面的参数。设置scrollerwidth和scr

动态从数据库中读取数据
<script   language= "JavaScript1.2 ">  
<!--  
/*设置下面的参数。   设置scrollerwidth和scrollerheight参数,设置成滚动显示的图片中尺寸最大的。*/
var   scrollerwidth=400
var   scrollerheight=20
var   scrollerbgcolor= 'white '
//修改下面的每个图间暂停时间,本例为3秒。
var   pausebetweenimages=3000
//改变下面的图像地址,如果希望logo都是带连接的,只要将#改为相应的链接地址。
var   slideimages=new   Array()
slideimages[0]= ' <a   href= "# "   target= "_blank "> 文字1 </a> '
slideimages[1]= '文字2 '
slideimages[2]= '文字3 '
slideimages[3]= '文字4 '
//////下面的行不要编辑///////////////////////
if   (slideimages.length> 1)
i=2
else
i=0
function   move1(whichlayer){
tlayer=eval(whichlayer)
if   (tlayer.top> 0&&tlayer.top <=5){
tlayer.top=0
setTimeout( "move1(tlayer) ",pausebetweenimages)
setTimeout( "move2(document.main.document.second) ",pausebetweenimages)
return
}
if   (tlayer.top> =tlayer.document.height*-1){
tlayer.top-=5
setTimeout( "move1(tlayer) ",100)
}
else{
tlayer.top=scrollerheight
tlayer.document.write(slideimages[i])
tlayer.document.close()
if   (i==slideimages.length-1)
i=0
else
i++
}}
function   move2(whichlayer){
tlayer2=eval(whichlayer)
if   (tlayer2.top> 0&&tlayer2.top <=5){
tlayer2.top=0
setTimeout( "move2(tlayer2) ",pausebetweenimages)
setTimeout( "move1(document.main.document.first) ",pausebetweenimages)
return
}
if   (tlayer2.top> =tlayer2.document.height*-1){
tlayer2.top-=5
setTimeout( "move2(tlayer2) ",100)
}
else{
tlayer2.top=scrollerheight
tlayer2.document.write(slideimages[i])
tlayer2.document.close()
if   (i==slideimages.length-1)
i=0
else
i++
}}
function   move3(whichdiv){
tdiv=eval(whichdiv)
if   (tdiv.style.pixelTop> 0&&tdiv.style.pixelTop <=5){
tdiv.style.pixelTop=0
setTimeout( "move3(tdiv) ",pausebetweenimages)
setTimeout( "move4(second2) ",pausebetweenimages)
return
}
if   (tdiv.style.pixelTop> =tdiv.offsetHeight*-1){
tdiv.style.pixelTop-=5
setTimeout( "move3(tdiv) ",100)
}
else{
tdiv.style.pixelTop=scrollerheight
tdiv.innerHTML=slideimages[i]
if   (i==slideimages.length-1)
i=0
else
i++
}
}
function   move4(whichdiv){
tdiv2=eval(whichdiv)
if   (tdiv2.style.pixelTop> 0&&tdiv2.style.pixelTop <=5){
tdiv2.style.pixelTop=0
setTimeout( "move4(tdiv2) ",pausebetweenimages)
setTimeout( "move3(first2) ",pausebetweenimages)
return
}
if   (tdiv2.style.pixelTop> =tdiv2.offsetHeight*-1){
tdiv2.style.pixelTop-=5
setTimeout( "move4(second2) ",100)
}
else{
tdiv2.style.pixelTop=scrollerheight
tdiv2.innerHTML=slideimages[i]
if   (i==slideimages.length-1)
i=0
else
i++
}}
function   startscroll(){
if   (document.all){
move3(first2)
second2.style.top=scrollerheight
}
else   if   (document.layers){
move1(document.main.document.first)
document.main.document.second.top=scrollerheight+5
document.main.document.second.visibility= 'show '
}}
window.onload=startscroll
//-->
</script>
<ilayer   id= "main "   width= "&{scrollerwidth}; "   height= "&{scrollerheight}; "   bgcolor= "&{scrollerbgcolor}; ">


<layer   id= "first "   left= "0 "   top= "1 "   width= "&{scrollerwidth}; ">
<script   language= "JavaScript1.2 ">
if   (document.layers)
document.write(slideimages[0])
</script>
</layer>
<layer   id= "second "   left= "0 "   top= "0 "   width= "&{scrollerwidth}; "   visibility= "hide ">
<script
language= "JavaScript1.2 ">
if   (document.layers)
document.write(slideimages[1])
</script>
</layer>
</ilayer>

<p> <script   language= "JavaScript1.2 ">
<!--  
if   (document.all){
document.writeln( ' <span   id= "main2 "   style= "position:relative;width: '+scrollerwidth+ ';height: '+scrollerheight+ ';overflow:hiden;background-color: '+scrollerbgcolor+ ' "> ')
document.writeln( ' <div   style= "position:absolute;width: '+scrollerwidth+ ';height: '+scrollerheight+ ';clip:rect(0   '+scrollerwidth+ '   '+scrollerheight+ '   0);left:0;top:0 "> ')
document.writeln( ' <div   id= "first2 "   style= "position:absolute;width: '+scrollerwidth+ ';left:0;top:1; "> ')
document.write(slideimages[0])
document.writeln( ' </div> ')
document.writeln( ' <div   id= "second2 "   style= "position:absolute;width: '+scrollerwidth+ ';left:0;top:0 "> ')
document.write(slideimages[1])
document.writeln( ' </div> ')
document.writeln( ' </div> ')
document.writeln( ' </span> ')
}
//--> </script>   </p>


这个轮流显示功能,,   我想实现从数据库中取数据,怎么实现啊

[解决办法]
<script>

<%
set rsz=conn.execute( "select top 5 id,topic,pic from news ")
for i=0 to 4
if rsz.eof then
exit for
end if
id=rsz( "id ")
topic=left(rsz( "topic "),18)
%>
slideimages[ <%=i%> ]= ' <%=topic%> '
<%
rsz.movenext
next
rsz.close
set rsz=nothing
%>
</script>

热点排行