<%@ page import="java.net.InetAddress" %> <%@ include file="header.jsp" %> <%@ include file="sidebar.jsp" %> Local Sites: This Server
<%@ page language="java" import="yahoo.*" %> <%@ page import="java.sql.*" %>

My Resume <% /* Although I SELECTED all of the columns (id,itsgroup,url,title,thedate) in the YahooBean3 bean, I only need to use two of those columns (title and url) in this JSP page to create the links for the Yahoo-style index. The title is getString(4), the url is getString(3). However, the methods ("stored procedures") in the YahooBean3 bean automatically select ALL columns in the table "thesites" for ease of use in other projects that require other columns. The "while" statements below are responsible for formatting and printing the raw ResultSets retrieved through the Sites() method of the YahooBean3 bean. The "while" statements could just as easily be used to create a drop-down form with a series of tags, a simple table displaying the data, or any other method of presentation your heart desires. */ %> <% ResultSet rs = yahool.getResumeLocal(); InetAddress local1 = java.net.InetAddress.getLocalHost(); String la1= local1.getHostAddress(); while (rs.next() ) { String url=rs.getString(3).trim(); String title=rs.getString(4).trim(); out.print(""+(title)+" "); } %>

Technical Playground <% ResultSet rs2 = yahool.getTechLocal(); InetAddress local2 = java.net.InetAddress.getLocalHost(); String la2= local2.getHostAddress(); while (rs2.next() ) { String url2=rs2.getString(3).trim(); String title2=rs2.getString(4).trim(); out.print(""+(title2)+" "); } %>

IIS Site Maintenance (Private-Password Required)

---

---

My Sites: AOL Server

Home Page <% ResultSet rs3 = yahool.getHome(); while (rs3.next() ) { String url3=rs3.getString(3).trim(); String title3=rs3.getString(4).trim(); out.print(""+(title3)+" "); } %>	NYC Site <% ResultSet rs4 = yahool.getNyc(); while (rs4.next() ) { String url4=rs4.getString(3).trim(); String title4=rs4.getString(4).trim(); out.print(""+(title4)+" "); } %>
Lesbian-Gay <% ResultSet rs5 = yahool.getLgbt(); while (rs5.next() ) { String url5=rs5.getString(3).trim(); String title5=rs5.getString(4).trim(); out.print(""+(title5)+" "); } %>	Hiphop <% ResultSet rs6 = yahool.getHiphop(); while (rs6.next() ) { String url6=rs6.getString(3).trim(); String title6=rs6.getString(4).trim(); out.print(""+(title6)+" "); } %>
Reggae <% ResultSet rs7 = yahool.getReggae(); while (rs7.next() ) { String url7=rs7.getString(3).trim(); String title7=rs7.getString(4).trim(); out.print(""+(title7)+" "); } %>	My Resume <% ResultSet rs12 = yahool.getResume(); while (rs12.next() ) { String url12=rs12.getString(3).trim(); String title12=rs12.getString(4).trim(); out.print(""+(title12)+" "); } %>
About Me <% ResultSet rs8 = yahool.getAboutMe(); while (rs8.next() ) { String url8=rs8.getString(3).trim(); String title8=rs8.getString(4).trim(); out.print(""+(title8)+" "); } %>	Site Search <% ResultSet rs9 = yahool.getSearch(); while (rs9.next() ) { String url9=rs9.getString(3).trim(); String title9=rs9.getString(4).trim(); out.print(""+(title9)+" "); } %>
Ghetto Haunted House <% ResultSet rs10 = yahool.getGhettoHaunted(); while (rs10.next() ) { String url10=rs10.getString(3).trim(); String title10=rs10.getString(4).trim(); out.print(""+(title10)+" "); } %>	Computers/IT <% ResultSet rs11 = yahool.getComputers(); while (rs11.next() ) { String url11=rs11.getString(3).trim(); String title11=rs11.getString(4).trim(); out.print(""+(title11)+" "); } %>