leftmz.jsp

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

<TABLE  width="100%" border=0 align=left cellPadding=1 cellSpacing=2>
  <TBODY>  <TR>
					<%	String 	sqlname1="select sort,id from scott.allsort order by id";
       ResultSet rst=stmt.executeQuery(sqlname1);
					%>
                       
      <TD height="188" class=text> <div align="left">
	 <% while(rst.next()){%>
	  &nbsp;&nbsp; <img src="images/rj-tp1.gif" width="10" height="10" border="0"> 
          <a href="sorts.jsp?id=<%=rst.getString("id")%>"> 
          <%=rst.getString("sort")%></a><br>
		  <%}%>
         </div></TD>
                    </TR>
                  </TBODY>
                </TABLE>