untitled-1.jsp~18~

用JSP制作的个人网站

        else{
	if(Page2>maxPage2){
		Page2=maxPage2;
	}
}
rs_shipin.absolute((Page2-1)*pagesize2+1);
for(int i=1;i<=pagesize2;i++){
                 s_shipinid=rs_shipin.getInt(1);
                    s_swupinming = rs_shipin.getString(2);
                      s_syanse = rs_shipin.getString(3);
                       s_schangjia = rs_shipin.getString(4);
                        s_scailiao = rs_shipin.getString(5);
                         s_sshiyongnianxian = rs_shipin.getString(6);
                          s_sshengchanriqi = rs_shipin.getString(7);
                          s_sgoumaichishu= rs_shipin.getString(8);
                           s_stuijianzhishu= rs_shipin.getString(9);
                            s_syoudian= rs_shipin.getString(10);
                            s_sprice= rs_shipin.getString(14);
                 if (username==null || username==""){%>
                <tr> <td height="28"><a href="shipin_detail.jsp?ID=<%=s_shipinid%>"><%=s_shipinid%></a></td>
                      <td height="28"><%=s_swupinming%></td>
                      <td><%=s_syanse%></td>
                      <td><%=s_schangjia %></td>
                      <td><%=s_scailiao%></td>
                      <td><%=s_sshiyongnianxian%></td>
                      <td><%=s_sshengchanriqi%></td>
                      <td><%=s_sgoumaichishu%></td>
                      <td><%=s_stuijianzhishu%></td>
                      <td><%=s_syoudian%></td>
                      <td><div align="center" class="style2"><strong>请先登陆</strong></div></td>
                </tr>
                    <%}else{%>
                    <tr> <td height="31" align="top"><a href="shipin_detail.jsp?ID=<%=s_shipinid%>"><%=s_shipinid%></a></td>
                      <td height="31"><%=s_swupinming%></td>
                      <td><%=s_syanse%></td>
                      <td><%=s_schangjia %></td>
                      <td><%=s_scailiao%></td>
                      <td><%=s_sshiyongnianxian%></td>
                      <td><%=s_sshengchanriqi%></td>
                      <td><%=s_sgoumaichishu%></td>
                      <td><%=s_stuijianzhishu%></td>
                      <td><%=s_syoudian%></td>
                      <td><%=s_sprice%></td>
                    </tr><%}
                       try{
		if(!rs_shipin.next()){break;}
		}
        catch(Exception e){}
                       }%>
                    <tr>
                      <td height="31" colspan="11" align="top">&nbsp;<table width="100%" >
                        <tr>
                           <td align="right"><span class="style7">当前页数：</span>[<%=Page2%>/<%=maxPage2%>]&nbsp;
	<%if(Page2>1){%>
	<a href="index.jsp?Page2=1" class="style7">第一页</a>　<a href="index.jsp?Page2=<%=Page2-1%>" class="style7">上一页</a>
	<%
	}
	if(Page2<maxPage2){
	%>
	　<a href="index.jsp?Page2=<%=Page2+1%>" class="style7">下一页</a>　<a href="index.jsp?Page2=<%=maxPage2%>"><span class="style7">最后一页</span>&nbsp;</a>
	<%}
	%>	</td>
                        </tr>
                      </table></td>
                    </tr>

                  </table>
                  <table width="100%" height="149" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
                    <tr>
                      <td height="32" colspan="11" background="images/zuihou.png">　　　 生活用品</td>
                    </tr>
                    <tr> <td width="9%" height="27"><div align="center">编号</div></td>
                      <td width="10%"><div align="center">物品名</div></td>
                      <td width="7%"><div align="center">颜色</div></td>
                      <td width="9%"><div align="center">厂家</div></td>
                      <td width="9%"><div align="center">材料</div></td>
                      <td width="10%"><div align="center">使用年限</div></td>
                      <td width="10%"><div align="center">生产日期</div></td>
                      <td width="11%"><div align="center">购买次数</div></td>
                      <td width="10%"><div align="center">推荐指数</div></td>

                      <td width="7%"><div align="center">优点</div></td>
                      <td width="8%"><div align="center">价格</div></td>
                    </tr>
                  <%
 String str3=(String)request.getParameter("Page3");
        if(str3==null){
	    str3="0";
                        }
          int pagesize3=2;
         rs_shenghuoyongpin.last();
    int RecordCount3=rs_shenghuoyongpin.getRow();
 int maxPage3=0;
 maxPage3=(RecordCount2%pagesize3==0)?(RecordCount3/pagesize3):(RecordCount3/pagesize3+1);

  int Page3=Integer.parseInt(str3);
   if(Page3<1){
	Page3=1;}
        else{
	if(Page3>maxPage3){
		Page3=maxPage3;
	}
}
rs_shenghuoyongpin.absolute((Page3-1)*pagesize3+1);
for(int i=1;i<=pagesize3;i++){

                    s_shenghuoyongpinid=rs_shenghuoyongpin.getInt(1);
                    s_hwupinming = rs_shenghuoyongpin.getString(2);
                      s_hyanse = rs_shenghuoyongpin.getString(3);
                       s_hchangjia = rs_shenghuoyongpin.getString(4);
                        s_hcailiao = rs_shenghuoyongpin.getString(5);
                         s_hshiyongnianxian = rs_shenghuoyongpin.getString(6);
                          s_hshengchanriqi = rs_shenghuoyongpin.getString(7);
                          s_hgoumaichishu= rs_shenghuoyongpin.getString(8);
                           s_htuijianzhishu= rs_shenghuoyongpin.getString(9);
                            s_hyoudian= rs_shenghuoyongpin.getString(10);
                             s_hprice= rs_shenghuoyongpin.getString(14);
                  if (username==null || username==""){%>
                  <tr><td><a href="shenghuoyongpin_detail.jsp?ID=<%=s_shenghuoyongpinid%>"><%=s_shenghuoyongpinid%></a></td>
                    <td><%=s_hwupinming%></td>
                    <td><%=s_hyanse %></td>
                    <td><%=s_hchangjia%></td>
                    <td><%=s_hcailiao%></td>
                    <td><%=s_hshiyongnianxian%></td>
                    <td><%=s_hshengchanriqi%></td>
                    <td><%=s_hgoumaichishu%></td>
                    <td><%=s_htuijianzhishu%></td>

                    <td><%=s_hyoudian%></td>
                    <td><div align="center" class="style2"><strong>请先登陆</strong></div></td>
                  </tr>
                    <%}else{%>
                    <tr><td height="30"><a href="shenghuoyongpin_detail.jsp?ID=<%=s_shenghuoyongpinid%>"><%=s_shenghuoyongpinid%></a></td>
                      <td><%=s_hwupinming%></td>
                      <td><%=s_hyanse %></td>
                      <td><%=s_hchangjia%></td>
                      <td><%=s_hcailiao%></td>
                      <td><%=s_hshiyongnianxian%></td>
                      <td><%=s_hshengchanriqi%></td>
                      <td><%=s_hgoumaichishu%></td>
                      <td><%=s_htuijianzhishu%></td>

                      <td><%=s_hyoudian%></td>
                      <td><%=s_hprice%></td>
                    </tr><%}
                       try{
		if(!rs_shenghuoyongpin.next()){break;}
		}
        catch(Exception e){}
                     }%>
                    <tr>
                      <td height="30" colspan="11"><table width="100%" >
                        <tr>
                           <td align="right"><span class="style7">当前页数：</span>[<%=Page3%>/<%=maxPage3%>]&nbsp;
	<%if(Page3>1){%>
	<a href="index.jsp?Page3=1" class="style7">第一页</a>　<a href="index.jsp?Page3=<%=Page3-1%>" class="style7">上一页</a>
	<%
	}
	if(Page3<maxPage3){
	%>
	　<a href="index.jsp?Page3=<%=Page3+1%>" class="style7">下一页</a>　<a href="index.jsp?Page3=<%=maxPage3%>"><span class="style7">最后一页</span>&nbsp;</a>
	<%}
	%>	</td>
                        </tr>
                      </table></td>
                    </tr>

                  </table>
                  <table width="100%" height="130" border="1" cellpadding="0" cellspacing="0" bordercolor="#cccccc" bgcolor="#f1f5ff">
                    <tr>
                      <td height="34" colspan="11" background="images/zuihou.png">　　　其他</td>
                    </tr>

                    <tr><td width="9%"><div align="center">物品名</div></td>
                      <td width="10%"><div align="center">物品名</div></td>
                      <td width="7%"><div align="center">颜色</div></td>
                      <td width="9%"><div align="center">厂家</div></td>
                      <td width="9%"><div align="center">材料</div></td>
                      <td width="10%"><div align="center">使用年限</div></td>
                      <td width="10%"><div align="center">生产日期</div></td>
                      <td width="11%"><div align="center">购买次数</div></td>
                      <td width="10%">推荐指数</td>
                      <td width="7%"><div align="center">优点</div></td>
                      <td width="8%"><div align="center">价格</div></td>
                    </tr>
               <%
String str4=(String)request.getParameter("Page4");
        if(str4==null){
	    str4="0";
                        }
          int pagesize4=2;
         rs_qita.last();
    int RecordCount4=rs_qita.getRow();
 int maxPage4=0;
 maxPage4=(RecordCount4%pagesize4==0)?(RecordCount4/pagesize4):(RecordCount4/pagesize4+1);

  int Page4=Integer.parseInt(str4);
   if(Page4<1){
	Page4=1;}
        else{
	if(Page4>maxPage4){
		Page4=maxPage4;
	}
}
rs_qita.absolute((Page4-1)*pagesize4+1);
for(int i=1;i<=pagesize4;i++){

                    s_qitaid=rs_qita.getInt(1);
                    s_qwupinming = rs_qita.getString(2);
                      s_qyanse = rs_qita.getString(3);
                       s_qchangjia = rs_qita.getString(4);
                        s_qcailiao = rs_qita.getString(5);
                         s_qshiyongnianxian = rs_qita.getString(6);
                          s_qshengchanriqi = rs_qita.getString(7);
                          s_qgoumaichishu= rs_qita.getString(8);
                           s_qtuijianzhishu= rs_qita.getString(9);
                            s_qyoudian= rs_qita.getString(10);
                            s_qprice= rs_qita.getString(14);
                  if (username==null || username==""){%>
                  <tr><td height="33"><a href="qita_detail.jsp?ID=<%=s_qitaid%>"><%=s_qitaid%></a></td>
                    <td height="33"><%=s_qwupinming%></td>
                    <td><%=s_qyanse%></td>
                    <td><%=s_qchangjia%></td>
                    <td><%=s_qcailiao%></td>
                    <td><%=s_qshiyongnianxian%></td>
                    <td><%=s_qshengchanriqi%></td>
                    <td><%=s_qgoumaichishu%></td>
                    <td><%=s_qtuijianzhishu%></td>
                    <td><%=s_qyoudian%></td>
                    <td><div align="center" class="style2"><strong>请先登陆</strong></div></td>
                  </tr>
                     <%}else{%>
                     <tr><td height="33"><a href="qita_detail.jsp?ID=<%=s_qitaid%>"><%=s_qitaid%></a></td>
                       <td height="33"><%=s_qwupinming%></td>
                       <td><%=s_qyanse%></td>
                       <td><%=s_qchangjia%></td>
                       <td><%=s_qcailiao%></td>
                       <td><%=s_qshiyongnianxian%></td>
                       <td><%=s_qshengchanriqi%></td>
                       <td><%=s_qgoumaichishu%></td>
                       <td><%=s_qtuijianzhishu%></td>
                       <td><%=s_qyoudian%></td>
                       <td><%=s_qprice%></td>
                     </tr> <%}
                        try{
		if(!rs_qita.next()){break;}
		}
        catch(Exception e){}
                        }%>
                     <tr>
                       <td height="33" colspan="11"><table width="100%" >
                        <tr>
                           <td align="right"><span class="style7">当前页数：</span>[<%=Page4%>/<%=maxPage4%>]&nbsp;
	<%if(Page4>1){%>
	<a href="index.jsp?Page4=1" class="style7">第一页</a>　<a href="index.jsp?Page4=<%=Page4-1%>" class="style7">上一页</a>
	<%
	}
	if(Page4<maxPage4){
	%>
	　<a href="index.jsp?Page4=<%=Page4+1%>" class="style7">下一页</a>　<a href="index.jsp?Page4=<%=maxPage4%>"><span class="style7">最后一页</span>&nbsp;</a>
	<%}
	%>	</td>
                        </tr>
                      </table></td>
                     </tr>

                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
    </table>
          <div align="center"></div>          </tr>
</table>
</body>
</html>
<%conn.close();%>