复件 index.jsp

JSP+ORACLE网站开发实例（下）.rar

                      </tr>
                      <tr>
                        <td background="images/iocn2.gif" height="1" colspan="3"></td>
                      </tr>
                      <%ii++;
					  }%> 
                    </table></td>
                  </tr>
                </table>
                <map name="Map3Map">
                  <area shape="rect" coords="325, 5, 395, 21" href="list.jsp?classid=5">
                </map>                <br>
                <table width="400" border="0" align="center" cellpadding="0" cellspacing="3">
                  <tr>
                    <td><img src="images/re.gif" width="400" height="25" border="0" usemap="#Map4"></td>
                  </tr>
                  <tr>
                    <td><table width="100%"  border="0" cellpadding="0" cellspacing="3" class="txt1">
                             <%     
        sql="select articleid,title,addtime from scott.article where  classid=13 order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<5&&rst.next()) {  
                                          %>
					 <tr>
                        <td width="4%"><img src="images/iocn1.gif" width="7" height="7"></td>
                        <td width="77%" class="txt1"><a href="show.jsp?id=<%=rst.getString("articleid")%>" title="<%=rst.getString("title")%>" class="list6" target=_blank><%=rst.getString("title")%></a></td>
                        <td width="19%" class="txt3">[<%=rst.getString("addtime")%>]</td>
                      </tr>
                      <tr>
                        <td background="images/iocn2.gif" height="1" colspan="3"></td>
                      </tr>
                      <%ii++;
					  }%> 
                    </table></td>
                  </tr>
                </table>
                <br></td>
              <td width="194" align="right" valign="top">
			            
						<table width="171" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td><img src="images/wenxian.gif" width="171" height="28" border="0" usemap="#Map6"></td>
              </tr>
              <tr>
                <td background="images/xr2.gif"><table width="98%"  border="0" cellspacing="2" cellpadding="0">
                  <tr>
                    <td class="txt1"> 
                  <td class="txt1">
				                              <%     
        sql="select articleid,title,addtime from scott.article where  classid=6 order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<6&&rst.next()) {  
                                          %>				  
                   ·<a href="show.jsp?id=<%=rst.getString("articleid")%>" title="<%=rst.getString("title")%>" class="list4"><%=rst.getString("title")%></a><br>
      <%ii++;
	  }%> </td>
                  </tr>
                </table></td>
              </tr>
                <tr>
                  <td><img src="images/xr3.gif" width="171" height="9"></td>
                </tr>
          </table><br>
                        <table width="171" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td><img src="images/shandong.gif" width="171" height="27" border="0" usemap="#Map11MapMap"></td>
                </tr>
                <tr>
                  <td background="images/xr2.gif"><table width="98%"  border="0" cellspacing="2" cellpadding="0">
                    <tr>
                      <td align="left" class="txt1">
                  <td class="txt1">
				               <%     
        sql="select articleid,title,addtime from scott.article where  classid=15 order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<7&&rst.next()) {  
                                          %>				
                   ·<a href="show.jsp?id=<%=rst.getString("articleid")%>" title="<%=rst.getString("title")%>" class="list4" target=_blank><%=rst.getString("title")%></a><br>
      <%ii++;
	  }%> </td>
                    </tr>
                  </table></td>
                </tr>
                <tr>
                  <td><img src="images/xr3.gif" width="171" height="9"></td>
                </tr>
              </table>
                <map name="Map11MapMap">
                  <area shape="rect" coords="26, 4, 97, 25" href="list.jsp?classid=15">
                </map>                <br>
                <table width="171" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td><img src="images/xr1.gif" width="171" height="30" border="0" usemap="#Map12"></td>
                </tr>
                <tr>
                  <td align="right" background="images/xr2.gif">
					<table width="98%"  border="0" cellspacing="2" cellpadding="0" id="table1">
                    <tr>
                      <td align="left" class="txt1">
                  <td class="txt1">
				          <%     
        sql="select articleid,title,addtime from scott.article where  classid=12 order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<8&&rst.next()) {  
                                          %>					  
                   ·<a href="show.jsp?id=<%=rst.getString("articleid")%>" title="<%=rst.getString("title")%>" class="list4" target=_blank><%=rst.getString("title")%></a><br>
      <%ii++;
	  }%> </td>
                    </tr>
                  </table>                    </td>
                </tr>
                <tr>
                  <td><img src="images/xr3.gif" width="171" height="9"></td>
                </tr>
              </table>
                <br>
                <table width="171" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td><img src="images/tui.gif" width="171" height="27" border="0" usemap="#Map11"></td>
                  </tr>
                  <tr>
                    <td background="images/xr2.gif"><table width="96%"  border="0" align="right" cellpadding="0" cellspacing="2">
                      <tr>
                        <td align="left" class="txt1">
						      <%     
        sql="select articleid,title,addtime from scott.article where  classid=12 order by addtime desc";
	   rst=stmt.executeQuery(sql); 
                                    	  ii=0;
                                      while(ii<8&&rst.next()) {  
                                          %>	
						<a href="<%=rst.getString("articleid")%>" target="_blank" class="list4"><%=rst.getString("title")%> </a><br>
                        <%ii++;
						}%></td>
                      </tr>
                    </table></td>
                  </tr>
                  <tr>
                    <td><img src="images/xr3.gif" width="171" height="9"></td>
                  </tr>
                </table>                
                <br></td>
            </tr>
          </table>          </td>
        </tr>
      </table>
	  <%@ include file="end.inc"%>
      </td>
  </tr>
</table>
<map name="Map2">
  <area shape="rect" coords="517, 2, 587, 22" href="list.jsp?classid=3">
</map>
<map name="Map">
  <area shape="rect" coords="325, 3, 394, 21" href="list.jsp?classid=9">
</map>
<map name="Map3">
  <area shape="rect" coords="325, 5, 395, 21" href="list.jsp?classid=10">
</map>
<map name="Map4">
  <area shape="rect" coords="324, 5, 395, 22" href="list.jsp?classid=13">
</map>
<map name="Map6">
  <area shape="rect" coords="38, 6, 111, 24" href="list.jsp?classid=6">
</map>
<map name="Map7">
  <area shape="rect" coords="37, 7, 112, 28" href="list.jsp?classid=7">
</map>
<map name="Map8">
  <area shape="rect" coords="39, 5, 110, 25" href="list2.jsp?classid=8">
</map>
<map name="Map10">
  <area shape="rect" coords="37, 6, 109, 25" href="list2.jsp?classid=11">
</map>
<map name="Map11">
  <area shape="rect" coords="16, 3, 87, 24" href="link.jsp">
</map>
<map name="Map12">
  <area shape="rect" coords="18, 5, 89, 25" href="list.jsp?classid=12">
</map>
</body>
</html>