index_bottom.jsp

来自「网上购物系统」· JSP 代码 · 共 43 行

<%@ page contentType="text/html; charset=gb2312"%>
<table width="995" border="0" align="center" bgcolor="#FFFFFF">
  <tr>
    <td>
	<div align="center">
	<hr noshade="noshade" color="#999999" />
		<!--bottom栏目 开始-->
		|&nbsp;
	<%
//网站配置
Statement stmt_BottomChannel=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_BottomChannel = "select * from tChannel where fPlace=1";
ResultSet Rs_BottomChannel = stmt_BottomChannel.executeQuery(sql_BottomChannel);
while(Rs_BottomChannel.next())
{
	if (Rs_BottomChannel.getInt("fViewType")==0)
	{
%>
	　<a href="<%=Rs_BottomChannel.getString("fLinkUrl")%>" target="_blank" title="<%=Rs_BottomChannel.getString("fReadMe")%>" ><%=Rs_BottomChannel.getString("fChannelName")%></a>
	<%
	}
	else
	{
	%>
	　<a href="ChannelContent.jsp?ID=<%=Rs_BottomChannel.getInt("fChannelID")%>" target="_blank" title="<%=Rs_BottomChannel.getString("fReadMe")%>"><%=Rs_BottomChannel.getString("fChannelName")%></a>
<%
	}%>
	　|
<%
}
//*********** 数据库关闭代码 *******************************
Rs_BottomChannel.close(); //关闭记录集对象
stmt_BottomChannel.close(); //关闭语句对象
%>	
	<!--bottom栏目 结束-->
	<br />&nbsp; <%=RsSiteConfig.getString("fCopyright")%>&nbsp; 
	<br />&nbsp; 站长：<%=RsSiteConfig.getString("fWebmasterName")%>
	<br />&nbsp; 程序设计: <a href="http://www.deepteach.com/" target="_blank">吕海鹏</a>
	</div>
  </td>
  </tr>
</table>