<%@ page language="java" %> <%@ page import="java.sql.*" %> <%@ page import="org.gjt.mm.mysql.Driver" %> <%@ page import="java.lang.*" %> <% Connection connection = null; Statement statement = null; ResultSet rs = null; ResultSet rs2 = null; long lCount = 0; Class.forName("org.gjt.mm.mysql.Driver").newInstance(); connection = DriverManager.getConnection("jdbc:mysql://localhost/the2deve_CannonChess?user=the2deve_general&password=password"); statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = statement.executeQuery("SELECT Announcements.desc, Announcements.annc_date FROM Announcements WHERE expiration > CURDATE() ORDER BY annc_date DESC"); rs.first(); statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs2 = statement.executeQuery("SELECT Links.desc, Links.url FROM Links ORDER BY Links.desc"); rs2.first(); %> Cannon Chess Team

Welcome to the Cannon Chess Team Website

View Current Standings



Announcements

<% do { %> <% }while(rs.next()); %>
Date Announcement
<%=rs.getString("annc_date")%> <%=rs.getString("desc")%>



Links

<% do { %> <% }while(rs2.next()); %>
Description URL
<%=rs2.getString("desc")%> "><%=rs2.getString("url")%>