首页新闻图片轮换显示

最新推荐文章于 2024-09-22 11:17:00 发布

weixin_30765319

最新推荐文章于 2024-09-22 11:17:00 发布

阅读量96

点赞数

文章标签： javascript 数据库 ViewUI

原文链接：http://www.cnblogs.com/tiu/archive/2006/08/08/468744.html

版权

前两天在网站首页增加新闻图片轮换显示功能，在网上查了下，有这种功能的倒不少，但都是静态的，我需要的是从数据库去数据，如下：

SqlConnection conn2 = new SqlConnection();

string strConn = System.Configuration.ConfigurationSettings.AppSettings[ " connstr " ];

conn2.ConnectionString = strConn;

conn2.Open();

sqlstr = " select top 5 * from artical where imgnews=1 order by id desc " ;

SqlCommand cmd = new SqlCommand(sqlstr,conn2);

SqlDataReader re = cmd.ExecuteReader();

while (re.Read())

{

pics+="artical/"+re["pic"]+"|";

links+="detail.aspx?aid="+re["id"]+"|";

texts+=getSubStr(re["topic"].ToString(),14)+"|";

}

re.Close();

conn2.Close();

实现效果的javascript是在网上拷贝的，呵呵，如下：

< script type = " text/javascript " >

var focus_width = 186

var focus_height = 156

var text_height = 25

var swf_height = focus_height + text_height

var pics = " <%=pics%> "

var links = " <%=links%> "

var texts = " <%=texts%> "

pics = pics.substring( 0 ,pics.length - 1 );

links = links.substring( 0 ,links.length - 1 );

texts = texts.substring( 0 ,texts.length - 1 );

document.write( ' <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width=" ' + focus_width + ' " height=" ' + swf_height + ' "> ' );

document.write( ' <param name="allowScriptAccess" value="sameDomain"><param name="movie" value="images/focus.swf"><param name="quality" value="high"><param name="bgcolor" value="#F0F0F0"> ' );

document.write( ' <param name="menu" value="false"><param name=wmode value="opaque"> ' );

document.write( ' <param name="FlashVars" value="pics= ' + pics + ' &links= ' + links + ' &texts= ' + texts + ' &borderwidth= ' + focus_width + ' &borderheight= ' + focus_height + ' &textheight= ' + text_height + ' "> ' );

document.write( ' <embed src="pixviewer.swf" wmode="opaque" FlashVars="pics= ' + pics + ' &links= ' + links + ' &texts= ' + texts + ' &borderwidth= ' + focus_width + ' &borderheight= ' + focus_height + ' &textheight= ' + text_height + ' " menu="false" bgcolor="#F0F0F0" quality="high" width=" ' + focus_width + ' " height=" ' + focus_height + ' " allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" /> ' ); document.write( ' </object> ' );

</ script >

转载于:https://www.cnblogs.com/tiu/archive/2006/08/08/468744.html