indexnews.jsp

网上购物系统

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

<%
//新闻栏目配置
Statement stmt_Class=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql_Class = "Select * from tArticleClass where fClassName='本站动态' order by fOrderID";
ResultSet RsClass = stmt_Class.executeQuery(sql_Class);
int NewsClassID;
String NewsClassName;
while(RsClass.next())
{

NewsClassName=RsClass.getString("fClassName");
NewsClassID=RsClass.getInt("fClassID");
%>

<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr>
          <td height="26" colspan="2" background="images/t-1-bg.gif">
		  &nbsp;  &nbsp;
		  <span class="word_Red">新 闻 动 态</span>&nbsp;&nbsp;
		  &nbsp;　　　　　　　　　　　　　　　　　　　　　&nbsp; 
		  <a href="ArticleClass.jsp?ID=<%=NewsClassID%>&ArticleClass=<%=NewsClassName%>" target="_blank" title="更多<%=NewsClassName%>">more..</a>
		  </td>
        </tr>
		<!--子 开始-->
        <tr>
          <td height="220" class="table-youxia" bgcolor="#f5f5f5">
		  
			<!--biaoti-->
			<%
//新闻栏目配置

		Statement stmt_Article=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		String sql_Article = "Select top 10 * from tArticle where fClassID="+NewsClassID+" order by fUpdateTime DESC";
		ResultSet RsArticle = stmt_Article.executeQuery(sql_Article);
		while(RsArticle.next())
		{
			String ArticleTitle=RsArticle.getString("fTitle");

		%>
				&nbsp;　·　<a href="ArticleContent.jsp?ID=<%=RsArticle.getInt("fArticleID")%>&Class=<%=NewsClassName%>" target="_blank" title="标题：<%=ArticleTitle%>
	作者：<%=RsArticle.getString("fAuthor")%>
	浏览次数：<%=RsArticle.getInt("fHits")%>
	发表时间：<%=RsArticle.getString("fUpdateTime")%>"><%=ArticleTitle%></a><br />

<%
}
RsArticle.close(); //关闭记录集对象
stmt_Article.close(); //关闭语句对象
%>	
			<!--biaoti-->                

		  </td>
		<!--子 结束-->
		</tr>
      </table>
<%
}
RsClass.close(); //关闭记录集对象
stmt_Class.close(); //关闭语句对象
%>