indexclasstop.jsp

网上购物系统

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

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

int td_Class =0;
while(RsClassTop.next())
{
%>

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

//====================================
Statement stmtcount=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqlcount="Select * from tArticleClass where fParentID="+ClassTopClassID+" order by fOrderID";
ResultSet rscount=stmtcount.executeQuery(sqlcount); 

int ClassCount=0; //总的记录数 
while (rscount.next()){ 
ClassCount=rscount.getInt(1); 
}
//out.print(ClassCount);

rscount.close(); //关闭记录集对象
stmtcount.close(); //关闭语句对象
//================================================

int hang=0;
int lie=0;
while(RsClassX.next())
{
	String ClassXClassName=RsClassX.getString("fClassName");
	int ClassXClassID=RsClassX.getInt("fClassID");
	
	if (hang % 2 ==0) out.print("<tr>");
%>
        
          <td height="100" class="table-youxia" <%if (lie % 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>
				<!--biaoti-->
				
			<%	//====================================
				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>
			          
		<%	hang =hang + 1;
			lie =lie+1;
			if (lie >3)  lie =0 ;
				if ((ClassCount==hang) && (hang % 2!=0))
				{%>
					<td height="100" class="table-youxia" <%if (lie % 3==0) out.print("bgcolor='#FFFFF4'");%> >&nbsp;</td>
				<%
				}			
			if (hang % 2 == 0)  out.print("</tr>");
		}
		RsClassX.close(); //关闭记录集对象
		stmtClassX.close(); //关闭语句对象
		%>
		<!--子 结束-->
		
</table>
<%
	td_Class=td_Class+1;
	if (td_Class >3)  td_Class =0;

}
RsClassTop.close(); //关闭记录集对象
stmtClassTop.close(); //关闭语句对象
%>