left.jsp

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

<table width="171" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td colspan="3" class="txt2"><img src="images/sou.jpg" width="171" height="35"></td>
            </tr>
            <form action=search.jsp method=get target=_blank><tr>
              <td width="8" align="right">　</td>
              <td width="136" height="30">
                <input name="key" type="text" class="f1" size="18">
              </td>
              <td width="27"><input type=image src="images/go.gif" width="20" height="20" border="0"></td>
            </tr></form>
          </table> 
            <table width="171" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td><img src="images/ling.gif" width="171" height="28" border="0" usemap="#Map7"></td>
            </tr>
            <tr>
              <td background="images/bg1.jpg"><table width="98%"  border="0" cellspacing="2" cellpadding="0">
                <tr>
                  <td class="txt1">
                  <td class="txt1">
		    <%     
       String sql="select classid,class from scott.class where parentid=19 order by rootid,ordersid";
	ResultSet   rst=stmt.executeQuery(sql); 
                                    	int  ii=0;
                                      while(ii<4&&rst.next()) {  
                                          %>		 
                   ·<a href="show.jsp?id=<%=rst.getString("classid")%>" title="<%=rst.getString("class")%>" class="list5"><%=rst.getString("class")%></a><br>
      <%ii++;
      }%> </td>
                </tr>
              </table></td>
            </tr>
          </table>
          
          <table width="171" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td><img src="images/guo.gif" width="171" height="32" border="0" usemap="#Map7Map"></td>
            </tr>
            <tr>
              <td background="images/bg2.jpg"><table width="98%"  border="0" cellspacing="2" cellpadding="0">
                <tr>
                  <td class="txt1">
		   <%     
        sql="select articleid,title from scott.article,scott.class where class.parentid=4 and class.classid=article.classid 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="list5"><%=rst.getString("title")%></a><br>
      <%ii++;
      }%> </td>
                </tr>
              </table></td>
            </tr>
          </table>
          <map name="Map7Map">
            <area shape="rect" coords="37, 7, 112, 28" href="list.jsp?classid=4">
          </map> <br>