| My Resume <% // ------ Setting up the driver and DB connection to MySQL Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); // ------ Setting up the query to be executed Statement stmt = conn.createStatement (); ResultSet rset = stmt.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='51'"); // --- I am only printing out TWO columns (title,url) from the four in the SELECT statement, // --- Selecting the four columns just to make this script more easily transportable to // --- other pages that may require other columns. // --- all four of the colums have been defined as string variables(below), even though only two // --- (url,title) are going to be printed in this page(I know it's lazy lol but it saves time) // --- printing out the results below as links.... while (rset.next ()) { String id=rset.getString(1).trim(); String itsgroup=rset.getString(2).trim(); String url=rset.getString(3).trim(); String title=rset.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> | Technical Playground <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn2 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt2 = conn2.createStatement (); ResultSet rset2 = stmt2.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='52'"); while (rset2.next ()) { String id=rset2.getString(1).trim(); String itsgroup=rset2.getString(2).trim(); String url=rset2.getString(3).trim(); String title=rset2.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> |
| IIS Site Maintenance (Private-Password Required) |
| Home Page <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn3 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt3 = conn3.createStatement (); ResultSet rset3 = stmt3.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='1'"); while (rset3.next ()) { String id=rset3.getString(1).trim(); String itsgroup=rset3.getString(2).trim(); String url=rset3.getString(3).trim(); String title=rset3.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> | NYC Site <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn4 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt4 = conn4.createStatement (); ResultSet rset4 = stmt4.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='2'"); while (rset4.next ()) { String id=rset4.getString(1).trim(); String itsgroup=rset4.getString(2).trim(); String url=rset4.getString(3).trim(); String title=rset4.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> | ||||||
| Lesbian-Gay <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn5 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt5 = conn5.createStatement (); ResultSet rset5 = stmt5.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='5'"); while (rset5.next ()) { String id=rset5.getString(1).trim(); String itsgroup=rset5.getString(2).trim(); String url=rset5.getString(3).trim(); String title=rset5.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> | Hiphop <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn6 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt6 = conn6.createStatement (); ResultSet rset6 = stmt6.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='3'"); while (rset6.next ()) { String id=rset6.getString(1).trim(); String itsgroup=rset6.getString(2).trim(); String url=rset6.getString(3).trim(); String title=rset6.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> Reggae | <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn7 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt7 = conn7.createStatement (); ResultSet rset7 = stmt7.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='4'"); while (rset7.next ()) { String id=rset7.getString(1).trim(); String itsgroup=rset7.getString(2).trim(); String url=rset7.getString(3).trim(); String title=rset7.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> My Resume | <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn8 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt8 = conn8.createStatement (); ResultSet rset8 = stmt8.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='6'"); while (rset8.next ()) { String id=rset8.getString(1).trim(); String itsgroup=rset8.getString(2).trim(); String url=rset8.getString(3).trim(); String title=rset8.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> About Me | <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn9 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt9 = conn9.createStatement (); ResultSet rset9 = stmt9.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='7'"); while (rset9.next ()) { String id=rset9.getString(1).trim(); String itsgroup=rset9.getString(2).trim(); String url=rset9.getString(3).trim(); String title=rset9.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> Site Search | <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn10 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt10 = conn10.createStatement (); ResultSet rset10 = stmt10.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='8'"); while (rset10.next ()) { String id=rset10.getString(1).trim(); String itsgroup=rset10.getString(2).trim(); String url=rset10.getString(3).trim(); String title=rset10.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> Ghetto Haunted House | <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn11 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt11 = conn11.createStatement (); ResultSet rset11 = stmt11.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='9'"); while (rset11.next ()) { String id=rset11.getString(1).trim(); String itsgroup=rset11.getString(2).trim(); String url=rset11.getString(3).trim(); String title=rset11.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> Computers/IT | <% Class.forName ("gwe.sql.gweMysqlDriver"); Connection conn12 = DriverManager.getConnection ("jdbc:mysql://:3306/siteindex2","guest","guest"); Statement stmt12 = conn12.createStatement (); ResultSet rset12 = stmt12.executeQuery ("SELECT id,itsgroup,url,title FROM thesites WHERE itsgroup='10'"); while (rset12.next ()) { String id=rset12.getString(1).trim(); String itsgroup=rset12.getString(2).trim(); String url=rset12.getString(3).trim(); String title=rset12.getString(4).trim(); out.print(""); out.print (title); out.print(""); out.print(" "); } %> |