friendsite.jsp

网上购物系统

<%@ page contentType="text/html; charset=gb2312"%>

<div align="center">
<marquee  direction="up" width="90%" height="80" scrollAmount=1 scrollDelay=150 onMouseOver="this.stop()" onMouseOut="this.start()" >
<div align="center">
<%
//文字链接
Statement stmtFriendSite=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqlFriendSite="Select * from tFriendSite where fLinkType=0 and fIsOK=true";
ResultSet RsFriendSite=stmtFriendSite.executeQuery(sqlFriendSite); 
while (RsFriendSite.next())
{
	%>
	&nbsp; <a href="<%=RsFriendSite.getString("fSiteUrl")%>" target="_blank" title="<%=RsFriendSite.getString("fSiteIntro")%>"><%=RsFriendSite.getString("fSiteName")%></a><br />
	<%
}

RsFriendSite.close(); //关闭记录集对象
stmtFriendSite.close(); //关闭语句对象
%>

<%
//图片链接
Statement stmtFriendSitePic=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqlFriendSitePic="Select * from tFriendSite where fLinkType=1 and fIsOK=true";
ResultSet RsFriendSitePic=stmtFriendSitePic.executeQuery(sqlFriendSitePic); 
while (RsFriendSitePic.next())
{
	%>
	<a href="<%=RsFriendSitePic.getString("fSiteUrl")%>" target="_blank" ><img border="0" src="<%=RsFriendSitePic.getString("fLogoUrl")%>" width="88" height="31" alt="<%=RsFriendSitePic.getString("fSiteName")%><%=RsFriendSitePic.getString("fSiteIntro")%>" /></a><br /><br />
	<%
}

RsFriendSitePic.close(); //关闭记录集对象
stmtFriendSitePic.close(); //关闭语句对象
%>

</div>
</marquee>
</div>