indexclassmiddlet.jsp

网上购物系统

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

<%
//中部通栏文章栏目
//创建语句对象
Statement stmtClassMiddleT=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqlClassMiddleT = "Select * from tArticleClass where fParentID=0 and fPlace=1 order by fOrderID";
ResultSet RsClassMiddleT = stmtClassMiddleT.executeQuery(sqlClassMiddleT);

int td_ClassMiddleT =0;
while(RsClassMiddleT.next())
{
%>
<table width="995" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
        <tr>
		<%
		switch (td_ClassMiddleT)
		{
		case 0:
			{
		%>
          <td height="22" colspan="4" background="images/t-2-bg2.gif"><img src="images/t-2-2.gif" width="23" height="21" align="absmiddle" /><span class="word_White">&nbsp;&nbsp;&nbsp;<%=RsClassMiddleT.getString("fClassName")%></span></td>
		<%
			break;
			}
		case 1:
			{
		%>
          <td height="22" colspan="4" background="images/t-3-bg.gif"><img src="images/t-3-1.gif" width="27" height="22" align="absmiddle" /><span class="word_Red">&nbsp;&nbsp;&nbsp;<%=RsClassMiddleT.getString("fClassName")%></span></td>
		<%
			break;
			}
		default :
			{
		%>
          <td height="22" colspan="4" background="images/t-2-bg.gif"><img src="images/t-2-1.gif" width="23" height="21" align="absmiddle" /><span class="word_White">&nbsp;&nbsp;&nbsp;<%=RsClassMiddleT.getString("fClassName")%></span></td>
	  <%
			break;
	  		}
		}
	  %>
		  
        </tr>
		<!--子 开始-->
<%
int ClassMiddleTClassID=RsClassMiddleT.getInt("fClassID");		
//创建语句对象
Statement stmtClassX=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqlClassX = "Select * from tArticleClass where fParentID="+ClassMiddleTClassID+" order by fOrderID";
ResultSet RsClassX = stmtClassX.executeQuery(sqlClassX);

		int hangM=0;
		int lieM=0;
		while(RsClassX.next())
		{
			String ClassXClassName=RsClassX.getString("fClassName");
			int ClassXClassID=RsClassX.getInt("fClassID");
			
			if (hangM % 4 ==0) out.print("<tr>");
%>
        
          <td height="100" class="table-youxia" <%if (lieM % 3==0) { %>bgcolor="#FFFFF4"<%}%> >
		  <table width="95%" align="center" cellpadding="0" cellspacing="0">
              <tr>
                <td height="22">&nbsp;&nbsp;
				<img src="images/Dian_SanJiao.gif" width="6" height="8" />
				  <span class="word_Red"><%=ClassXClassName%></span>
			    &nbsp;　　&nbsp;<a href="ArticleClass.jsp?ID=<%=ClassXClassID%>&ArticleClass=<%=ClassXClassName%>" target="_blank" title="更多<%=ClassXClassName%>">more..</a>
			    </td>
              </tr>
              <tr>
                <td>
			<%	//====================================
				Statement stmtArticle=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
				String sqlArticle="Select  * from tArticle where fClassID="+ ClassXClassID +" order by fUpdateTime DESC"; 
				ResultSet RsArticle=stmtArticle.executeQuery(sqlArticle); 
				int i=0;
				while (RsArticle.next()&& i<3)
				{ 
					i++;
					int ArticleID = RsArticle.getInt("fArticleID");
					String ArticleTitle=RsArticle.getString("fTitle");
				%>
				·<a href="ArticleContent.jsp?ID=<%=ArticleID%>&Class=<%=ClassXClassName%>" target="_blank" title="标题：<%=ArticleTitle%>
	作者：<%=RsArticle.getString("fAuthor")%>
	浏览次数：<%=RsArticle.getInt("fHits")%>
	发表时间：<%=RsArticle.getString("fUpdateTime")%>"><%=ArticleTitle%></a><br />

				<%
				}
				RsArticle.close(); //关闭记录集对象
				stmtArticle.close(); //关闭语句对象
				//================================================
				%>
				<!--biaoti-->
                </td>
              </tr>
            </table>
			</td>
			          
		<%	hangM =hangM + 1;
			lieM =lieM+1;
			if (lieM >3)  {lieM =0 ;}
			if (hangM % 4 == 0)  out.print("</tr>");
		}
		RsClassX.close(); //关闭记录集对象
		stmtClassX.close(); //关闭语句对象
		%>
		<!--子 结束-->
		
</table>


<%
	td_ClassMiddleT=td_ClassMiddleT+1;
	if (td_ClassMiddleT >3)  td_ClassMiddleT =0;
}
RsClassMiddleT.close(); //关闭记录集对象
stmtClassMiddleT.close(); //关闭语句对象
%>